SQL> execute DBMS_METADATA.SET_TRANSFORM_PARAM (DBMS_METADATA.SESSION_TRANSFORM,'PRETTY',TRUE); PL/SQL procedure successfully completed. SQL> execute DBMS_METADATA.SET_TRANSFORM_PARAM (DBMS_METADATA.SESSION_TRANSFORM,'STORAGE',FALSE); PL/SQL procedure successfully completed. SQL> execute DBMS_METADATA.SET_TRANSFORM_PARAM (DBMS_METADATA.SESSION_TRANSFORM,'SEGMENT_ATTRIBUTES',false); PL/SQL procedure successfully completed. SQL> TRUNCATE TABLE PLAN_TABLE; Table truncated. SQL> EXPLAIN PLAN FOR SELECT /*+ hint index(element.print_order) */ 2 distinct xpd.drop_id, 3 xpd.drop_number, 4 xpdcr.element_name, 5 xpdcr.actual_value, 6 nvl(MLN.PARENT_LOT_NUMBER, 0) PARENT_LOT, 7 nvl(WDD.LOT_NUMBER, 0) CHILD_LOT1, 8 nvl(WDD.SHIPPED_QUANTITY2,0) SEC_UOM_PC, 9 nvl(WDD.NET_WEIGHT, 0) NET_WEIGHT, 10 nvl(WND.GROSS_WEIGHT, 0) GROSS_WEIGHT, 11 WDD.WEIGHT_UOM_CODE NET_GROSS_UOM, 12 mdev.element_value Alloy_no, 13 ooha.order_number, 14 ooha.header_id, 15 ooha.sold_to_org_id, 16 CUST_ACCT.ACCOUNT_NUMBER CUSTOMER_NUMBER, 17 ship_cas.party_site_id, 18 xpd.plant_code, 19 element.print_order 20 FROM MTL_SYSTEM_ITEMS_B MSIB, 21 WSH_NEW_DELIVERIES WND, 22 WSH_DELIVERY_DETAILS WDD, 23 WSH_DELIVERY_ASSIGNMENTS WDA, 24 OE_ORDER_LINES_ALL OOLA, 25 OE_ORDER_HEADERS_ALL OOHA, 26 hz_cust_accounts cust_acct, 27 hz_cust_site_uses_all ship_su, 28 hz_cust_acct_sites_all ship_cas, 29 MTL_LOT_NUMBERS MLN, 30 MTL_DESCR_ELEMENT_VALUES MDEV, 31 -- HR_ORGANIZATION_UNITS hou, 32 -- hr_locations_all hla, 33 org_organization_definitions ood, 34 xxgmd_pm_drops xpd, 35 xxgmd_pm_drop_chem_results xpdcr, 36 xxgmd_pm_cspecs cspec, 37 xxgmd_pm_cspec_elements cspec_el, 38 xxgmd_pm_cspec_element_rules cspec_rule, 39 xxgmd_pm_elements element 40 WHERE 1 = 1 41 AND WND.DELIVERY_ID = WDA.DELIVERY_ID 42 AND WDD.DELIVERY_DETAIL_ID = WDA.DELIVERY_DETAIL_ID 43 AND WDD.SOURCE_LINE_ID = OOLA.LINE_ID 44 AND OOLA.HEADER_ID = OOHA.HEADER_ID 45 AND MSIB.INVENTORY_ITEM_ID = OOLA.INVENTORY_ITEM_ID 46 AND MSIB.ORGANIZATION_ID(+) = WDD.ORGANIZATION_ID 47 and msib.inventory_item_id = mdev.inventory_item_id 48 -- AND HOU.LOCATION_ID = HLA.LOCATION_ID(+) 49 AND OOHA.SHIP_FROM_ORG_ID = OOD.ORGANIZATION_ID 50 -- AND OOD.OPERATING_UNIT = HOU.ORGANIZATION_ID 51 AND OOHA.sold_to_org_id = cust_acct.cust_account_id(+) 52 AND MLN.LOT_NUMBER(+) = WDD.LOT_NUMBER 53 AND mln.inventory_item_id(+) = wdd.inventory_item_id --Added on 26-Nov-12 from offshore 54 and mdev.element_name = 'C-ALLOY' 55 and xpd.drop_number = MLN.PARENT_LOT_NUMBER 56 AND xpd.plant_code = ood.organization_code 57 AND xpd.drop_id = xpdcr.drop_id 58 AND wnd.DELIVERY_ID = :P_DELIVERY_ID 59 -- AND ship_cas.cust_account_id = ooha.sold_to_org_id 60 AND ship_cas.cust_acct_site_id = ship_su.cust_acct_site_id 61 AND ooha.deliver_to_org_id = ship_su.site_use_id 62 AND cspec.cspec_name = mdev.element_value 63 AND cspec.cspec_id = cspec_el.cspec_id 64 AND cspec_rule.cspec_element_id = cspec_el.cspec_element_id 65 and cspec_rule.party_site_id = ship_cas.party_site_id 66 and cspec_rule.print_element = 'Y' 67 and cspec_el.element_id = element.element_id 68 and upper(element.element_name) = upper(xpdcr.element_name) 69 and upper(xpdcr.element_name) <> 'AL' 70 AND SYSDATE BETWEEN cspec.effective_start_date 71 AND NVL (cspec.effective_end_date,SYSDATE + 500 ) 72 order by element.print_order; Explained. SQL> SELECT DBMS_METADATA.GET_DDL (object_type, object_name, object_owner) 2 FROM plan_table 3 WHERE object_type IN ('TABLE','VIEW'); ERROR: ORA-31603: object "WSH_DELIVERY_ASSIGNMENTS" of type TABLE not found in schema "WSH" ORA-06512: at "SYS.DBMS_METADATA", line 5088 ORA-06512: at "SYS.DBMS_METADATA", line 7589 ORA-06512: at line 1 no rows selected SQL> SELECT DBMS_METADATA.GET_DDL ('INDEX', index_name, index_owner) 2 FROM all_indexes 3 WHERE table_owner, table_name IN ( 4 SELECT object_owner, object_name 5 FROM plan_table p 6 WHERE object_type IN ('TABLE') 7 ); WHERE table_owner, table_name IN ( * ERROR at line 3: ORA-00920: invalid relational operator SQL> SELECT TABLE_NAME, INDEX_NAME, COLUMN_NAME, COLUMN_POSITION 2 FROM ALL_IND_COLUMNS 3 WHERE TABLE_NAME IN (SELECT OBJECT_NAME FROM PLAN_TABLE p WHERE object_type = 'TABLE') ORDER BY 1,2,4; TABLE_NAME INDEX_NAME ------------------------------ ------------------------------ COLUMN_NAME -------------------------------------------------------------------------------- COLUMN_POSITION --------------- GL_LEDGERS GL_LEDGERS_N1 CHART_OF_ACCOUNTS_ID 1 GL_LEDGERS GL_LEDGERS_N1 PERIOD_SET_NAME 2 TABLE_NAME INDEX_NAME ------------------------------ ------------------------------ COLUMN_NAME -------------------------------------------------------------------------------- COLUMN_POSITION --------------- GL_LEDGERS GL_LEDGERS_N1 ACCOUNTED_PERIOD_TYPE 3 GL_LEDGERS GL_LEDGERS_N2 BAL_SEG_VALUE_SET_ID TABLE_NAME INDEX_NAME ------------------------------ ------------------------------ COLUMN_NAME -------------------------------------------------------------------------------- COLUMN_POSITION --------------- 1 GL_LEDGERS GL_LEDGERS_N3 MGT_SEG_VALUE_SET_ID 1 GL_LEDGERS GL_LEDGERS_U1 TABLE_NAME INDEX_NAME ------------------------------ ------------------------------ COLUMN_NAME -------------------------------------------------------------------------------- COLUMN_POSITION --------------- NAME 1 GL_LEDGERS GL_LEDGERS_U2 LEDGER_ID 1 TABLE_NAME INDEX_NAME ------------------------------ ------------------------------ COLUMN_NAME -------------------------------------------------------------------------------- COLUMN_POSITION --------------- GL_LEDGERS GL_LEDGERS_U3 SHORT_NAME 1 HR_ALL_ORGANIZATION_UNITS HR_ORGANIZATION_UNITS_FK1 BUSINESS_GROUP_ID 1 TABLE_NAME INDEX_NAME ------------------------------ ------------------------------ COLUMN_NAME -------------------------------------------------------------------------------- COLUMN_POSITION --------------- HR_ALL_ORGANIZATION_UNITS HR_ORGANIZATION_UNITS_FK2 COST_ALLOCATION_KEYFLEX_ID 1 HR_ALL_ORGANIZATION_UNITS HR_ORGANIZATION_UNITS_FK3 LOCATION_ID TABLE_NAME INDEX_NAME ------------------------------ ------------------------------ COLUMN_NAME -------------------------------------------------------------------------------- COLUMN_POSITION --------------- 1 HR_ALL_ORGANIZATION_UNITS HR_ORGANIZATION_UNITS_FK4 SOFT_CODING_KEYFLEX_ID 1 HR_ALL_ORGANIZATION_UNITS HR_ORGANIZATION_UNITS_PK TABLE_NAME INDEX_NAME ------------------------------ ------------------------------ COLUMN_NAME -------------------------------------------------------------------------------- COLUMN_POSITION --------------- ORGANIZATION_ID 1 HR_ALL_ORGANIZATION_UNITS HR_ORGANIZATION_UNITS_UK2 NAME 1 TABLE_NAME INDEX_NAME ------------------------------ ------------------------------ COLUMN_NAME -------------------------------------------------------------------------------- COLUMN_POSITION --------------- HR_ALL_ORGANIZATION_UNITS HR_ORGANIZATION_UNITS_UK2 BUSINESS_GROUP_ID 2 HR_ORGANIZATION_INFORMATION HR_ORGANIZATION_INFORMATIO_FK1 ORG_INFORMATION_CONTEXT 1 TABLE_NAME INDEX_NAME ------------------------------ ------------------------------ COLUMN_NAME -------------------------------------------------------------------------------- COLUMN_POSITION --------------- HR_ORGANIZATION_INFORMATION HR_ORGANIZATION_INFORMATIO_FK2 ORGANIZATION_ID 1 HR_ORGANIZATION_INFORMATION HR_ORGANIZATION_INFORMATIO_FK2 ORG_INFORMATION_CONTEXT TABLE_NAME INDEX_NAME ------------------------------ ------------------------------ COLUMN_NAME -------------------------------------------------------------------------------- COLUMN_POSITION --------------- 2 HR_ORGANIZATION_INFORMATION HR_ORGANIZATION_INFORMATIO_IX1 ORG_INFORMATION1 1 HR_ORGANIZATION_INFORMATION HR_ORGANIZATION_INFORMATIO_PK TABLE_NAME INDEX_NAME ------------------------------ ------------------------------ COLUMN_NAME -------------------------------------------------------------------------------- COLUMN_POSITION --------------- ORG_INFORMATION_ID 1 HZ_CUST_ACCOUNTS HZ_CUST_ACCOUNTS_N2 PARTY_ID 1 TABLE_NAME INDEX_NAME ------------------------------ ------------------------------ COLUMN_NAME -------------------------------------------------------------------------------- COLUMN_POSITION --------------- HZ_CUST_ACCOUNTS HZ_CUST_ACCOUNTS_N3 ACCOUNT_NAME 1 HZ_CUST_ACCOUNTS HZ_CUST_ACCOUNTS_N4 SYS_NC00136$ 1 TABLE_NAME INDEX_NAME ------------------------------ ------------------------------ COLUMN_NAME -------------------------------------------------------------------------------- COLUMN_POSITION --------------- HZ_CUST_ACCOUNTS HZ_CUST_ACCOUNTS_N5 SELLING_PARTY_ID 1 HZ_CUST_ACCOUNTS HZ_CUST_ACCOUNTS_U1 CUST_ACCOUNT_ID TABLE_NAME INDEX_NAME ------------------------------ ------------------------------ COLUMN_NAME -------------------------------------------------------------------------------- COLUMN_POSITION --------------- 1 HZ_CUST_ACCOUNTS HZ_CUST_ACCOUNTS_U2 ACCOUNT_NUMBER 1 HZ_CUST_ACCOUNTS HZ_CUST_ACCOUNTS_U3 TABLE_NAME INDEX_NAME ------------------------------ ------------------------------ COLUMN_NAME -------------------------------------------------------------------------------- COLUMN_POSITION --------------- ORIG_SYSTEM_REFERENCE 1 HZ_CUST_ACCT_SITES_ALL HZ_CUST_ACCT_SITES_N1 PARTY_SITE_ID 1 TABLE_NAME INDEX_NAME ------------------------------ ------------------------------ COLUMN_NAME -------------------------------------------------------------------------------- COLUMN_POSITION --------------- HZ_CUST_ACCT_SITES_ALL HZ_CUST_ACCT_SITES_N2 CUST_ACCOUNT_ID 1 HZ_CUST_ACCT_SITES_ALL HZ_CUST_ACCT_SITES_N2 STATUS 2 TABLE_NAME INDEX_NAME ------------------------------ ------------------------------ COLUMN_NAME -------------------------------------------------------------------------------- COLUMN_POSITION --------------- HZ_CUST_ACCT_SITES_ALL HZ_CUST_ACCT_SITES_N2 BILL_TO_FLAG 3 HZ_CUST_ACCT_SITES_ALL HZ_CUST_ACCT_SITES_N3 CUST_ACCOUNT_ID TABLE_NAME INDEX_NAME ------------------------------ ------------------------------ COLUMN_NAME -------------------------------------------------------------------------------- COLUMN_POSITION --------------- 1 HZ_CUST_ACCT_SITES_ALL HZ_CUST_ACCT_SITES_N3 STATUS 2 HZ_CUST_ACCT_SITES_ALL HZ_CUST_ACCT_SITES_N3 TABLE_NAME INDEX_NAME ------------------------------ ------------------------------ COLUMN_NAME -------------------------------------------------------------------------------- COLUMN_POSITION --------------- SHIP_TO_FLAG 3 HZ_CUST_ACCT_SITES_ALL HZ_CUST_ACCT_SITES_N4 ECE_TP_LOCATION_CODE 1 TABLE_NAME INDEX_NAME ------------------------------ ------------------------------ COLUMN_NAME -------------------------------------------------------------------------------- COLUMN_POSITION --------------- HZ_CUST_ACCT_SITES_ALL HZ_CUST_ACCT_SITES_U1 CUST_ACCT_SITE_ID 1 HZ_CUST_ACCT_SITES_ALL HZ_CUST_ACCT_SITES_U2 ORIG_SYSTEM_REFERENCE 1 TABLE_NAME INDEX_NAME ------------------------------ ------------------------------ COLUMN_NAME -------------------------------------------------------------------------------- COLUMN_POSITION --------------- HZ_CUST_ACCT_SITES_ALL HZ_CUST_ACCT_SITES_U2 ORG_ID 2 HZ_CUST_ACCT_SITES_ALL HZ_CUST_ACCT_SITES_U3 TP_HEADER_ID TABLE_NAME INDEX_NAME ------------------------------ ------------------------------ COLUMN_NAME -------------------------------------------------------------------------------- COLUMN_POSITION --------------- 1 HZ_CUST_SITE_USES_ALL HZ_CUST_SITE_USES_N1 CUST_ACCT_SITE_ID 1 HZ_CUST_SITE_USES_ALL HZ_CUST_SITE_USES_N1 TABLE_NAME INDEX_NAME ------------------------------ ------------------------------ COLUMN_NAME -------------------------------------------------------------------------------- COLUMN_POSITION --------------- SITE_USE_CODE 2 HZ_CUST_SITE_USES_ALL HZ_CUST_SITE_USES_N1 PRIMARY_FLAG 3 TABLE_NAME INDEX_NAME ------------------------------ ------------------------------ COLUMN_NAME -------------------------------------------------------------------------------- COLUMN_POSITION --------------- HZ_CUST_SITE_USES_ALL HZ_CUST_SITE_USES_N2 REQUEST_ID 1 HZ_CUST_SITE_USES_ALL HZ_CUST_SITE_USES_N2 STATUS 2 TABLE_NAME INDEX_NAME ------------------------------ ------------------------------ COLUMN_NAME -------------------------------------------------------------------------------- COLUMN_POSITION --------------- HZ_CUST_SITE_USES_ALL HZ_CUST_SITE_USES_N4 LOCATION 1 HZ_CUST_SITE_USES_ALL HZ_CUST_SITE_USES_N5 TAX_REFERENCE TABLE_NAME INDEX_NAME ------------------------------ ------------------------------ COLUMN_NAME -------------------------------------------------------------------------------- COLUMN_POSITION --------------- 1 HZ_CUST_SITE_USES_ALL HZ_CUST_SITE_USES_N5 ORG_ID 2 HZ_CUST_SITE_USES_ALL HZ_CUST_SITE_USES_N6 TABLE_NAME INDEX_NAME ------------------------------ ------------------------------ COLUMN_NAME -------------------------------------------------------------------------------- COLUMN_POSITION --------------- BILL_TO_SITE_USE_ID 1 HZ_CUST_SITE_USES_ALL HZ_CUST_SITE_USES_N6 SITE_USE_CODE 2 TABLE_NAME INDEX_NAME ------------------------------ ------------------------------ COLUMN_NAME -------------------------------------------------------------------------------- COLUMN_POSITION --------------- HZ_CUST_SITE_USES_ALL HZ_CUST_SITE_USES_N6 ORG_ID 3 HZ_CUST_SITE_USES_ALL HZ_CUST_SITE_USES_U1 SITE_USE_ID 1 TABLE_NAME INDEX_NAME ------------------------------ ------------------------------ COLUMN_NAME -------------------------------------------------------------------------------- COLUMN_POSITION --------------- MTL_DESCR_ELEMENT_VALUES MTL_DESCR_ELEMENT_VALUES_N1 ELEMENT_NAME 1 MTL_DESCR_ELEMENT_VALUES MTL_DESCR_ELEMENT_VALUES_N1 ELEMENT_VALUE TABLE_NAME INDEX_NAME ------------------------------ ------------------------------ COLUMN_NAME -------------------------------------------------------------------------------- COLUMN_POSITION --------------- 2 MTL_DESCR_ELEMENT_VALUES MTL_DESCR_ELEMENT_VALUES_U1 INVENTORY_ITEM_ID 1 MTL_DESCR_ELEMENT_VALUES MTL_DESCR_ELEMENT_VALUES_U1 TABLE_NAME INDEX_NAME ------------------------------ ------------------------------ COLUMN_NAME -------------------------------------------------------------------------------- COLUMN_POSITION --------------- ELEMENT_NAME 2 MTL_LOT_NUMBERS MTL_LOT_NUMBERS_N1 LOT_NUMBER 1 TABLE_NAME INDEX_NAME ------------------------------ ------------------------------ COLUMN_NAME -------------------------------------------------------------------------------- COLUMN_POSITION --------------- MTL_LOT_NUMBERS MTL_LOT_NUMBERS_N2 ORGANIZATION_ID 1 MTL_LOT_NUMBERS MTL_LOT_NUMBERS_N2 INVENTORY_ITEM_ID 2 TABLE_NAME INDEX_NAME ------------------------------ ------------------------------ COLUMN_NAME -------------------------------------------------------------------------------- COLUMN_POSITION --------------- MTL_LOT_NUMBERS MTL_LOT_NUMBERS_N2 PARENT_LOT_NUMBER 3 MTL_LOT_NUMBERS MTL_LOT_NUMBERS_N3 ORGANIZATION_ID TABLE_NAME INDEX_NAME ------------------------------ ------------------------------ COLUMN_NAME -------------------------------------------------------------------------------- COLUMN_POSITION --------------- 1 MTL_LOT_NUMBERS MTL_LOT_NUMBERS_N3 INVENTORY_ITEM_ID 2 MTL_LOT_NUMBERS MTL_LOT_NUMBERS_N3 TABLE_NAME INDEX_NAME ------------------------------ ------------------------------ COLUMN_NAME -------------------------------------------------------------------------------- COLUMN_POSITION --------------- GRADE_CODE 3 MTL_LOT_NUMBERS MTL_LOT_NUMBERS_U1 INVENTORY_ITEM_ID 1 TABLE_NAME INDEX_NAME ------------------------------ ------------------------------ COLUMN_NAME -------------------------------------------------------------------------------- COLUMN_POSITION --------------- MTL_LOT_NUMBERS MTL_LOT_NUMBERS_U1 ORGANIZATION_ID 2 MTL_LOT_NUMBERS MTL_LOT_NUMBERS_U1 LOT_NUMBER 3 TABLE_NAME INDEX_NAME ------------------------------ ------------------------------ COLUMN_NAME -------------------------------------------------------------------------------- COLUMN_POSITION --------------- MTL_LOT_NUMBERS MTL_LOT_NUMBERS_U2 GEN_OBJECT_ID 1 MTL_PARAMETERS MTL_PARAMETERS_N1 MASTER_ORGANIZATION_ID TABLE_NAME INDEX_NAME ------------------------------ ------------------------------ COLUMN_NAME -------------------------------------------------------------------------------- COLUMN_POSITION --------------- 1 MTL_PARAMETERS MTL_PARAMETERS_N2 COST_ORGANIZATION_ID 1 MTL_PARAMETERS MTL_PARAMETERS_U1 TABLE_NAME INDEX_NAME ------------------------------ ------------------------------ COLUMN_NAME -------------------------------------------------------------------------------- COLUMN_POSITION --------------- ORGANIZATION_ID 1 OE_ORDER_HEADERS_ALL OE_ORDER_HEADERS_N1 BLANKET_NUMBER 1 TABLE_NAME INDEX_NAME ------------------------------ ------------------------------ COLUMN_NAME -------------------------------------------------------------------------------- COLUMN_POSITION --------------- OE_ORDER_HEADERS_ALL OE_ORDER_HEADERS_N2 SOLD_TO_ORG_ID 1 OE_ORDER_HEADERS_ALL OE_ORDER_HEADERS_N3 SHIP_TO_ORG_ID 1 TABLE_NAME INDEX_NAME ------------------------------ ------------------------------ COLUMN_NAME -------------------------------------------------------------------------------- COLUMN_POSITION --------------- OE_ORDER_HEADERS_ALL OE_ORDER_HEADERS_N4 INVOICE_TO_ORG_ID 1 OE_ORDER_HEADERS_ALL OE_ORDER_HEADERS_N5 CUST_PO_NUMBER TABLE_NAME INDEX_NAME ------------------------------ ------------------------------ COLUMN_NAME -------------------------------------------------------------------------------- COLUMN_POSITION --------------- 1 OE_ORDER_HEADERS_ALL OE_ORDER_HEADERS_N6 BATCH_ID 1 OE_ORDER_HEADERS_ALL OE_ORDER_HEADERS_N7 TABLE_NAME INDEX_NAME ------------------------------ ------------------------------ COLUMN_NAME -------------------------------------------------------------------------------- COLUMN_POSITION --------------- ORIG_SYS_DOCUMENT_REF 1 OE_ORDER_HEADERS_ALL OE_ORDER_HEADERS_N7 ORDER_SOURCE_ID 2 TABLE_NAME INDEX_NAME ------------------------------ ------------------------------ COLUMN_NAME -------------------------------------------------------------------------------- COLUMN_POSITION --------------- OE_ORDER_HEADERS_ALL OE_ORDER_HEADERS_N8 OPEN_FLAG 1 OE_ORDER_HEADERS_ALL OE_ORDER_HEADERS_N9 QUOTE_NUMBER 1 TABLE_NAME INDEX_NAME ------------------------------ ------------------------------ COLUMN_NAME -------------------------------------------------------------------------------- COLUMN_POSITION --------------- OE_ORDER_HEADERS_ALL OE_ORDER_HEADERS_N9 ORDER_TYPE_ID 2 OE_ORDER_HEADERS_ALL OE_ORDER_HEADERS_U1 HEADER_ID TABLE_NAME INDEX_NAME ------------------------------ ------------------------------ COLUMN_NAME -------------------------------------------------------------------------------- COLUMN_POSITION --------------- 1 OE_ORDER_HEADERS_ALL OE_ORDER_HEADERS_U2 ORDER_NUMBER 1 OE_ORDER_HEADERS_ALL OE_ORDER_HEADERS_U2 TABLE_NAME INDEX_NAME ------------------------------ ------------------------------ COLUMN_NAME -------------------------------------------------------------------------------- COLUMN_POSITION --------------- ORDER_TYPE_ID 2 OE_ORDER_HEADERS_ALL OE_ORDER_HEADERS_U2 VERSION_NUMBER 3 TABLE_NAME INDEX_NAME ------------------------------ ------------------------------ COLUMN_NAME -------------------------------------------------------------------------------- COLUMN_POSITION --------------- OE_ORDER_LINES_ALL OE_ORDER_LINES_N1 HEADER_ID 1 OE_ORDER_LINES_ALL OE_ORDER_LINES_N10 TOP_MODEL_LINE_ID 1 TABLE_NAME INDEX_NAME ------------------------------ ------------------------------ COLUMN_NAME -------------------------------------------------------------------------------- COLUMN_POSITION --------------- OE_ORDER_LINES_ALL OE_ORDER_LINES_N11 ORDER_SOURCE_ID 1 OE_ORDER_LINES_ALL OE_ORDER_LINES_N11 ORIG_SYS_DOCUMENT_REF TABLE_NAME INDEX_NAME ------------------------------ ------------------------------ COLUMN_NAME -------------------------------------------------------------------------------- COLUMN_POSITION --------------- 2 OE_ORDER_LINES_ALL OE_ORDER_LINES_N11 ORIG_SYS_LINE_REF 3 OE_ORDER_LINES_ALL OE_ORDER_LINES_N11 TABLE_NAME INDEX_NAME ------------------------------ ------------------------------ COLUMN_NAME -------------------------------------------------------------------------------- COLUMN_POSITION --------------- ORIG_SYS_SHIPMENT_REF 4 OE_ORDER_LINES_ALL OE_ORDER_LINES_N12 ARRIVAL_SET_ID 1 TABLE_NAME INDEX_NAME ------------------------------ ------------------------------ COLUMN_NAME -------------------------------------------------------------------------------- COLUMN_POSITION --------------- OE_ORDER_LINES_ALL OE_ORDER_LINES_N13 SHIP_SET_ID 1 OE_ORDER_LINES_ALL OE_ORDER_LINES_N14 LINK_TO_LINE_ID 1 TABLE_NAME INDEX_NAME ------------------------------ ------------------------------ COLUMN_NAME -------------------------------------------------------------------------------- COLUMN_POSITION --------------- OE_ORDER_LINES_ALL OE_ORDER_LINES_N15 OPEN_FLAG 1 OE_ORDER_LINES_ALL OE_ORDER_LINES_N16 CUST_PO_NUMBER TABLE_NAME INDEX_NAME ------------------------------ ------------------------------ COLUMN_NAME -------------------------------------------------------------------------------- COLUMN_POSITION --------------- 1 OE_ORDER_LINES_ALL OE_ORDER_LINES_N17 ATO_LINE_ID 1 OE_ORDER_LINES_ALL OE_ORDER_LINES_N18 TABLE_NAME INDEX_NAME ------------------------------ ------------------------------ COLUMN_NAME -------------------------------------------------------------------------------- COLUMN_POSITION --------------- COMMITMENT_ID 1 OE_ORDER_LINES_ALL OE_ORDER_LINES_N19 BLANKET_NUMBER 1 TABLE_NAME INDEX_NAME ------------------------------ ------------------------------ COLUMN_NAME -------------------------------------------------------------------------------- COLUMN_POSITION --------------- OE_ORDER_LINES_ALL OE_ORDER_LINES_N19 BLANKET_LINE_NUMBER 2 OE_ORDER_LINES_ALL OE_ORDER_LINES_N2 SHIP_TO_ORG_ID 1 TABLE_NAME INDEX_NAME ------------------------------ ------------------------------ COLUMN_NAME -------------------------------------------------------------------------------- COLUMN_POSITION --------------- OE_ORDER_LINES_ALL OE_ORDER_LINES_N2 ORDERED_ITEM_ID 2 OE_ORDER_LINES_ALL OE_ORDER_LINES_N3 INVENTORY_ITEM_ID TABLE_NAME INDEX_NAME ------------------------------ ------------------------------ COLUMN_NAME -------------------------------------------------------------------------------- COLUMN_POSITION --------------- 1 OE_ORDER_LINES_ALL OE_ORDER_LINES_N3 OPEN_FLAG 2 OE_ORDER_LINES_ALL OE_ORDER_LINES_N5 TABLE_NAME INDEX_NAME ------------------------------ ------------------------------ COLUMN_NAME -------------------------------------------------------------------------------- COLUMN_POSITION --------------- PROJECT_ID 1 OE_ORDER_LINES_ALL OE_ORDER_LINES_N5 TASK_ID 2 TABLE_NAME INDEX_NAME ------------------------------ ------------------------------ COLUMN_NAME -------------------------------------------------------------------------------- COLUMN_POSITION --------------- OE_ORDER_LINES_ALL OE_ORDER_LINES_N6 REFERENCE_LINE_ID 1 OE_ORDER_LINES_ALL OE_ORDER_LINES_N7 LINE_SET_ID 1 TABLE_NAME INDEX_NAME ------------------------------ ------------------------------ COLUMN_NAME -------------------------------------------------------------------------------- COLUMN_POSITION --------------- OE_ORDER_LINES_ALL OE_ORDER_LINES_N9 SERVICE_REFERENCE_LINE_ID 1 OE_ORDER_LINES_ALL OE_ORDER_LINES_U1 LINE_ID TABLE_NAME INDEX_NAME ------------------------------ ------------------------------ COLUMN_NAME -------------------------------------------------------------------------------- COLUMN_POSITION --------------- 1 WSH_DELIVERY_ASSIGNMENTS WSH_DELIVERY_ASSIGNMENTS_N1 DELIVERY_ID 1 WSH_DELIVERY_ASSIGNMENTS WSH_DELIVERY_ASSIGNMENTS_N2 TABLE_NAME INDEX_NAME ------------------------------ ------------------------------ COLUMN_NAME -------------------------------------------------------------------------------- COLUMN_POSITION --------------- PARENT_DELIVERY_ID 1 WSH_DELIVERY_ASSIGNMENTS WSH_DELIVERY_ASSIGNMENTS_N3 DELIVERY_DETAIL_ID 1 TABLE_NAME INDEX_NAME ------------------------------ ------------------------------ COLUMN_NAME -------------------------------------------------------------------------------- COLUMN_POSITION --------------- WSH_DELIVERY_ASSIGNMENTS WSH_DELIVERY_ASSIGNMENTS_N4 PARENT_DELIVERY_DETAIL_ID 1 WSH_DELIVERY_ASSIGNMENTS WSH_DELIVERY_ASSIGNMENTS_U1 DELIVERY_ASSIGNMENT_ID 1 TABLE_NAME INDEX_NAME ------------------------------ ------------------------------ COLUMN_NAME -------------------------------------------------------------------------------- COLUMN_POSITION --------------- WSH_DELIVERY_DETAILS WSH_DELIVERY_DETAILS_N1 DATE_SCHEDULED 1 WSH_DELIVERY_DETAILS WSH_DELIVERY_DETAILS_N10 CONTAINER_FLAG TABLE_NAME INDEX_NAME ------------------------------ ------------------------------ COLUMN_NAME -------------------------------------------------------------------------------- COLUMN_POSITION --------------- 1 WSH_DELIVERY_DETAILS WSH_DELIVERY_DETAILS_N12 SOURCE_HEADER_NUMBER 1 WSH_DELIVERY_DETAILS WSH_DELIVERY_DETAILS_N13 TABLE_NAME INDEX_NAME ------------------------------ ------------------------------ COLUMN_NAME -------------------------------------------------------------------------------- COLUMN_POSITION --------------- TOP_MODEL_LINE_ID 1 WSH_DELIVERY_DETAILS WSH_DELIVERY_DETAILS_N14 INV_INTERFACED_FLAG 1 TABLE_NAME INDEX_NAME ------------------------------ ------------------------------ COLUMN_NAME -------------------------------------------------------------------------------- COLUMN_POSITION --------------- WSH_DELIVERY_DETAILS WSH_DELIVERY_DETAILS_N15 DELIVER_TO_LOCATION_ID 1 WSH_DELIVERY_DETAILS WSH_DELIVERY_DETAILS_N15 DELIVER_TO_SITE_USE_ID 2 TABLE_NAME INDEX_NAME ------------------------------ ------------------------------ COLUMN_NAME -------------------------------------------------------------------------------- COLUMN_POSITION --------------- WSH_DELIVERY_DETAILS WSH_DELIVERY_DETAILS_N16 LPN_ID 1 WSH_DELIVERY_DETAILS WSH_DELIVERY_DETAILS_N17 ROUTING_REQ_ID TABLE_NAME INDEX_NAME ------------------------------ ------------------------------ COLUMN_NAME -------------------------------------------------------------------------------- COLUMN_POSITION --------------- 1 WSH_DELIVERY_DETAILS WSH_DELIVERY_DETAILS_N18 BATCH_ID 1 WSH_DELIVERY_DETAILS WSH_DELIVERY_DETAILS_N19 TABLE_NAME INDEX_NAME ------------------------------ ------------------------------ COLUMN_NAME -------------------------------------------------------------------------------- COLUMN_POSITION --------------- CONTAINER_NAME 1 WSH_DELIVERY_DETAILS WSH_DELIVERY_DETAILS_N2 SOURCE_HEADER_ID 1 TABLE_NAME INDEX_NAME ------------------------------ ------------------------------ COLUMN_NAME -------------------------------------------------------------------------------- COLUMN_POSITION --------------- WSH_DELIVERY_DETAILS WSH_DELIVERY_DETAILS_N3 SOURCE_LINE_ID 1 WSH_DELIVERY_DETAILS WSH_DELIVERY_DETAILS_N4 CUSTOMER_ID 1 TABLE_NAME INDEX_NAME ------------------------------ ------------------------------ COLUMN_NAME -------------------------------------------------------------------------------- COLUMN_POSITION --------------- WSH_DELIVERY_DETAILS WSH_DELIVERY_DETAILS_N5 SHIP_FROM_LOCATION_ID 1 WSH_DELIVERY_DETAILS WSH_DELIVERY_DETAILS_N6 SHIP_TO_LOCATION_ID TABLE_NAME INDEX_NAME ------------------------------ ------------------------------ COLUMN_NAME -------------------------------------------------------------------------------- COLUMN_POSITION --------------- 1 WSH_DELIVERY_DETAILS WSH_DELIVERY_DETAILS_N6 SHIP_TO_SITE_USE_ID 2 WSH_DELIVERY_DETAILS WSH_DELIVERY_DETAILS_N7 TABLE_NAME INDEX_NAME ------------------------------ ------------------------------ COLUMN_NAME -------------------------------------------------------------------------------- COLUMN_POSITION --------------- MOVE_ORDER_LINE_ID 1 WSH_DELIVERY_DETAILS WSH_DELIVERY_DETAILS_N8 RELEASED_STATUS 1 TABLE_NAME INDEX_NAME ------------------------------ ------------------------------ COLUMN_NAME -------------------------------------------------------------------------------- COLUMN_POSITION --------------- WSH_DELIVERY_DETAILS WSH_DELIVERY_DETAILS_N8 ORGANIZATION_ID 2 WSH_DELIVERY_DETAILS WSH_DELIVERY_DETAILS_N9 INVENTORY_ITEM_ID 1 TABLE_NAME INDEX_NAME ------------------------------ ------------------------------ COLUMN_NAME -------------------------------------------------------------------------------- COLUMN_POSITION --------------- WSH_DELIVERY_DETAILS WSH_DELIVERY_DETAILS_N9 ORGANIZATION_ID 2 WSH_DELIVERY_DETAILS WSH_DELIVERY_DETAILS_N9 SHIP_FROM_LOCATION_ID TABLE_NAME INDEX_NAME ------------------------------ ------------------------------ COLUMN_NAME -------------------------------------------------------------------------------- COLUMN_POSITION --------------- 3 WSH_DELIVERY_DETAILS WSH_DELIVERY_DETAILS_N9 RELEASED_STATUS 4 WSH_DELIVERY_DETAILS WSH_DELIVERY_DETAILS_U1 TABLE_NAME INDEX_NAME ------------------------------ ------------------------------ COLUMN_NAME -------------------------------------------------------------------------------- COLUMN_POSITION --------------- DELIVERY_DETAIL_ID 1 WSH_NEW_DELIVERIES WSH_NEW_DELIVERIES_N1 STATUS_CODE 1 TABLE_NAME INDEX_NAME ------------------------------ ------------------------------ COLUMN_NAME -------------------------------------------------------------------------------- COLUMN_POSITION --------------- WSH_NEW_DELIVERIES WSH_NEW_DELIVERIES_N10 ASN_SHIPMENT_HEADER_ID 1 WSH_NEW_DELIVERIES WSH_NEW_DELIVERIES_N11 RCV_SHIPMENT_HEADER_ID 1 TABLE_NAME INDEX_NAME ------------------------------ ------------------------------ COLUMN_NAME -------------------------------------------------------------------------------- COLUMN_POSITION --------------- WSH_NEW_DELIVERIES WSH_NEW_DELIVERIES_N12 TMS_INTERFACE_FLAG 1 WSH_NEW_DELIVERIES WSH_NEW_DELIVERIES_N3 ROUTING_RESPONSE_ID TABLE_NAME INDEX_NAME ------------------------------ ------------------------------ COLUMN_NAME -------------------------------------------------------------------------------- COLUMN_POSITION --------------- 1 WSH_NEW_DELIVERIES WSH_NEW_DELIVERIES_N4 ORGANIZATION_ID 1 WSH_NEW_DELIVERIES WSH_NEW_DELIVERIES_N5 TABLE_NAME INDEX_NAME ------------------------------ ------------------------------ COLUMN_NAME -------------------------------------------------------------------------------- COLUMN_POSITION --------------- SHIP_METHOD_CODE 1 WSH_NEW_DELIVERIES WSH_NEW_DELIVERIES_N6 CUSTOMER_ID 1 TABLE_NAME INDEX_NAME ------------------------------ ------------------------------ COLUMN_NAME -------------------------------------------------------------------------------- COLUMN_POSITION --------------- WSH_NEW_DELIVERIES WSH_NEW_DELIVERIES_N6 HASH_VALUE 2 WSH_NEW_DELIVERIES WSH_NEW_DELIVERIES_N7 INITIAL_PICKUP_DATE 1 TABLE_NAME INDEX_NAME ------------------------------ ------------------------------ COLUMN_NAME -------------------------------------------------------------------------------- COLUMN_POSITION --------------- WSH_NEW_DELIVERIES WSH_NEW_DELIVERIES_N8 BATCH_ID 1 WSH_NEW_DELIVERIES WSH_NEW_DELIVERIES_N8 HASH_VALUE TABLE_NAME INDEX_NAME ------------------------------ ------------------------------ COLUMN_NAME -------------------------------------------------------------------------------- COLUMN_POSITION --------------- 2 WSH_NEW_DELIVERIES WSH_NEW_DELIVERIES_N9 AP_BATCH_ID 1 WSH_NEW_DELIVERIES WSH_NEW_DELIVERIES_U1 TABLE_NAME INDEX_NAME ------------------------------ ------------------------------ COLUMN_NAME -------------------------------------------------------------------------------- COLUMN_POSITION --------------- DELIVERY_ID 1 WSH_NEW_DELIVERIES WSH_NEW_DELIVERIES_U2 NAME 1 TABLE_NAME INDEX_NAME ------------------------------ ------------------------------ COLUMN_NAME -------------------------------------------------------------------------------- COLUMN_POSITION --------------- XXGMD_PM_CSPECS XXGMD_PM_CSP_PK CSPEC_ID 1 XXGMD_PM_CSPECS XXGMD_PM_CSP_UK CSPEC_NAME 1 TABLE_NAME INDEX_NAME ------------------------------ ------------------------------ COLUMN_NAME -------------------------------------------------------------------------------- COLUMN_POSITION --------------- XXGMD_PM_CSPECS XXGMD_PM_CSP_UK CSPEC_VERS 2 XXGMD_PM_CSPEC_ELEMENTS XXGMD_PM_CSE_PK CSPEC_ELEMENT_ID TABLE_NAME INDEX_NAME ------------------------------ ------------------------------ COLUMN_NAME -------------------------------------------------------------------------------- COLUMN_POSITION --------------- 1 XXGMD_PM_CSPEC_ELEMENTS XXGMD_PM_CSE_UK CSPEC_ID 1 XXGMD_PM_CSPEC_ELEMENTS XXGMD_PM_CSE_UK TABLE_NAME INDEX_NAME ------------------------------ ------------------------------ COLUMN_NAME -------------------------------------------------------------------------------- COLUMN_POSITION --------------- ELEMENT_ID 2 XXGMD_PM_CSPEC_ELEMENT_RULES XXGMD_PM_CSR_PK CSPEC_ELEMENT_RULE_ID 1 TABLE_NAME INDEX_NAME ------------------------------ ------------------------------ COLUMN_NAME -------------------------------------------------------------------------------- COLUMN_POSITION --------------- XXGMD_PM_CSPEC_ELEMENT_RULES XXGMD_PM_CSR_UK CSPEC_ELEMENT_ID 1 XXGMD_PM_CSPEC_ELEMENT_RULES XXGMD_PM_CSR_UK PARTY_SITE_ID 2 TABLE_NAME INDEX_NAME ------------------------------ ------------------------------ COLUMN_NAME -------------------------------------------------------------------------------- COLUMN_POSITION --------------- XXGMD_PM_DROPS XXGMD_PM_DRP_PK DROP_ID 1 XXGMD_PM_DROPS XXGMD_PM_DRP_UK PLANT_CODE TABLE_NAME INDEX_NAME ------------------------------ ------------------------------ COLUMN_NAME -------------------------------------------------------------------------------- COLUMN_POSITION --------------- 1 XXGMD_PM_DROPS XXGMD_PM_DRP_UK DROP_NUMBER 2 XXGMD_PM_DROP_CHEM_RESULTS XXGMD_PM_DCR_PK TABLE_NAME INDEX_NAME ------------------------------ ------------------------------ COLUMN_NAME -------------------------------------------------------------------------------- COLUMN_POSITION --------------- DROP_RESULT_ID 1 XXGMD_PM_DROP_CHEM_RESULTS XXGMD_PM_DCR_UK DROP_ID 1 TABLE_NAME INDEX_NAME ------------------------------ ------------------------------ COLUMN_NAME -------------------------------------------------------------------------------- COLUMN_POSITION --------------- XXGMD_PM_DROP_CHEM_RESULTS XXGMD_PM_DCR_UK ELEMENT_NAME 2 XXGMD_PM_DROP_CHEM_RESULTS XXGMD_PM_DROP_CHEM_RESULTS_UP SYS_NC00009$ 1 TABLE_NAME INDEX_NAME ------------------------------ ------------------------------ COLUMN_NAME -------------------------------------------------------------------------------- COLUMN_POSITION --------------- XXGMD_PM_ELEMENTS XXGMD_PM_ELEMENTS_NAME_UPPER SYS_NC00009$ 1 XXGMD_PM_ELEMENTS XXGMD_PM_ELEMENTS_PR PRINT_ORDER TABLE_NAME INDEX_NAME ------------------------------ ------------------------------ COLUMN_NAME -------------------------------------------------------------------------------- COLUMN_POSITION --------------- 1 XXGMD_PM_ELEMENTS XXGMD_PM_ELM_PK ELEMENT_ID 1 XXGMD_PM_ELEMENTS XXGMD_PM_ELM_UK TABLE_NAME INDEX_NAME ------------------------------ ------------------------------ COLUMN_NAME -------------------------------------------------------------------------------- COLUMN_POSITION --------------- ELEMENT_NAME 1 174 rows selected. SQL> COMMIT; Commit complete. SQL> spool off;