eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

VIEW: APPS.RLM_SCHEDULE_INTERFACE_LINES_V

Source

View Text - Preformatted


SELECT a.PRIMARY_UOM_CODE, a.LINE_ID , a.LINE_NUMBER , a.CUSTOMER_ITEM_EXT, a.CUSTOMER_ITEM_ID , a.DATE_TYPE_CODE , a.INVENTORY_ITEM_ID, a.ITEM_DETAIL_SUBTYPE , a.ITEM_DETAIL_TYPE , a.QTY_TYPE_CODE , a.HEADER_ID , a.START_DATE_TIME , to_date(to_char(a.START_DATE_TIME,'YYYY/MM/DD'),'YYYY/MM/DD') start_date , a.UOM_CODE , a.ATO_DATA_TYPE , a.CUST_PO_RELEASE_NUM , a.CUST_PO_DATE , a.CUST_PO_LINE_NUM , a.CUST_PO_NUMBER , a.RETURN_CONTAINER_EXT , a.ROUTING_DESC_EXT , a.ROUTING_SEQ_CODE_EXT , a.SCHEDULE_ITEM_NUM , a.SHIP_DEL_PATTERN_EXT , a.ship_del_rule_name, a.SHIP_DEL_TIME_CODE_EXT , a.SHIP_FROM_ADDRESS_1_EXT , a.SHIP_FROM_ADDRESS_2_EXT , a.SHIP_FROM_ADDRESS_3_EXT , a.SHIP_FROM_ADDRESS_4_EXT , a.SHIP_FROM_CITY_EXT , a.SHIP_FROM_COUNTRY_EXT , a.SHIP_FROM_COUNTY_EXT , a.SHIP_FROM_NAME_EXT , a.SHIP_FROM_ORG_ID , a.SHIP_FROM_POSTAL_CD_EXT , a.SHIP_FROM_PROVINCE_EXT , a.SHIP_FROM_STATE_EXT , a.SHIP_LABEL_INFO_LINE_1 , a.SHIP_LABEL_INFO_LINE_10 , a.SHIP_LABEL_INFO_LINE_2 , a.SHIP_LABEL_INFO_LINE_3 , a.SHIP_LABEL_INFO_LINE_4 , a.SHIP_LABEL_INFO_LINE_5 , a.SHIP_LABEL_INFO_LINE_6 , a.SHIP_LABEL_INFO_LINE_7 , a.SHIP_LABEL_INFO_LINE_8 , a.SHIP_LABEL_INFO_LINE_9 , a.SHIP_TO_ADDRESS_1_EXT , a.SHIP_TO_ADDRESS_2_EXT , a.SHIP_TO_ADDRESS_3_EXT , a.SHIP_TO_ADDRESS_4_EXT , a.SHIP_TO_ADDRESS_ID , a.SHIP_TO_ORG_ID , a.INVOICE_TO_ORG_ID , a.INTMED_SHIP_TO_ORG_ID , a.DELIVER_TO_ORG_ID , a.SHIP_TO_CITY_EXT , a.SHIP_TO_COUNTRY_EXT , a.SHIP_TO_COUNTY_EXT , a.SHIP_TO_NAME_EXT , a.SHIP_TO_POSTAL_CD_EXT , a.SHIP_TO_PROVINCE_EXT , a.SHIP_TO_SITE_USE_ID , a.SHIP_TO_STATE_EXT , a.SUBLINE_ASSIGNED_ID_EXT , a.SUBLINE_CONFIG_CODE_EXT , a.SUBLINE_CUST_ITEM_EXT , a.SUBLINE_CUST_ITEM_ID , a.SUBLINE_MODEL_NUM_EXT , a.SUBLINE_QUANTITY , a.SUBLINE_UOM_CODE , a.SUPPLIER_ITEM_EXT , a.TRANSIT_TIME_EXT , a.TRANSIT_TIME_QUAL_EXT , a.CUST_PRODUCTION_SEQ_NUM , a.TRANSPORT_LOC_QUAL_EXT , a.TRANSPORT_LOCATION_EXT , a.TRANSPORT_METHOD_EXT , a.WEIGHT_EXT , a.WEIGHT_QUALIFIER_EXT , a.WEIGHT_UOM_EXT , a.ITEM_DETAIL_SUBTYPE_EXT , a.ITEM_DETAIL_TYPE_EXT , a.QTY_TYPE_CODE_EXT , a.DATE_TYPE_CODE_EXT , a.FBO_CONFIGURATION_KEY_1 , a.FBO_CONFIGURATION_KEY_2 , a.FBO_CONFIGURATION_KEY_3 , a.FBO_CONFIGURATION_KEY_4 , a.FBO_CONFIGURATION_KEY_5 , a.MATCH_KEY_ACROSS , a.MATCH_KEY_WITHIN , a.CRITICAL_KEY_ATTRIBUTES , a.LAST_UPDATE_DATE , a.LAST_UPDATED_BY , a.CREATION_DATE , a.CREATED_BY , a.ATTRIBUTE_CATEGORY , a.ATTRIBUTE1 , a.ATTRIBUTE2 , a.ATTRIBUTE3 , a.ATTRIBUTE4 , a.ATTRIBUTE5 , a.ATTRIBUTE6 , a.ATTRIBUTE7 , a.ATTRIBUTE8 , a.ATTRIBUTE9 , a.ATTRIBUTE10 , a.ATTRIBUTE11 , a.ATTRIBUTE12 , a.ATTRIBUTE13 , a.ATTRIBUTE14 , a.ATTRIBUTE15 , a.LAST_UPDATE_LOGIN , a.REQUEST_ID , a.PROGRAM_APPLICATION_ID , a.PROGRAM_ID , a.PROGRAM_UPDATE_DATE , a.BILL_TO_ADDRESS_1_EXT , a.BILL_TO_ADDRESS_2_EXT , a.BILL_TO_ADDRESS_3_EXT , a.BILL_TO_ADDRESS_4_EXT , a.BILL_TO_ADDRESS_ID , a.BILL_TO_CITY_EXT , a.BILL_TO_COUNTRY_EXT , a.BILL_TO_COUNTY_EXT , a.BILL_TO_NAME_EXT , a.BILL_TO_POSTAL_CD_EXT , a.BILL_TO_PROVINCE_EXT , a.BILL_TO_SITE_USE_ID , a.BILL_TO_STATE_EXT , a.CARRIER_ID_CODE_EXT , a.CARRIER_QUALIFIER_EXT , a.COMMODITY_EXT , a.COUNTRY_OF_ORIGIN_EXT , a.CUST_ASSEMBLY_EXT , a.CUST_ASSIGNED_ID_EXT , a.CUST_BILL_TO_EXT , a.CUST_CONTRACT_NUM_EXT , a.CUSTOMER_DOCK_CODE , a.CUST_INTRMD_SHIP_TO_EXT , a.CUST_ITEM_PRICE_EXT , a.CUST_ITEM_PRICE_UOM_EXT , a.CUSTOMER_ITEM_REVISION , a.CUSTOMER_JOB , a.CUST_MANUFACTURER_EXT , a.CUST_MODEL_NUMBER_EXT , a.CUST_MODEL_SERIAL_NUMBER , a.CUST_ORDER_NUM_EXT , a.CUST_PROCESS_NUM_EXT , a.CUST_PRODUCTION_LINE , a.CUST_SET_NUM_EXT , a.CUST_SHIP_FROM_ORG_EXT , a.CUST_SHIP_TO_EXT , a.CUST_UOM_EXT , a.END_DATE_TIME , a.EQUIPMENT_CODE_EXT , a.EQUIPMENT_NUMBER_EXT , a.HANDLING_CODE_EXT , a.HAZARD_CODE_EXT , a.HAZARD_CODE_QUAL_EXT , a.HAZARD_DESCRIPTION_EXT , a.IMPORT_LICENSE_DATE_EXT , a.IMPORT_LICENSE_EXT , a.INDUSTRY_ATTRIBUTE1 , a.INDUSTRY_ATTRIBUTE10 , a.INDUSTRY_ATTRIBUTE11 , a.INDUSTRY_ATTRIBUTE12 , a.INDUSTRY_ATTRIBUTE13 , a.INDUSTRY_ATTRIBUTE14 , a.INDUSTRY_ATTRIBUTE15 , a.INDUSTRY_ATTRIBUTE2 , a.INDUSTRY_ATTRIBUTE3 , a.INDUSTRY_ATTRIBUTE4 , a.INDUSTRY_ATTRIBUTE5 , a.INDUSTRY_ATTRIBUTE6 , a.INDUSTRY_ATTRIBUTE7 , a.INDUSTRY_ATTRIBUTE8 , a.INDUSTRY_ATTRIBUTE9 , a.INDUSTRY_CONTEXT , a.INTRMD_SHIP_TO_ID , a.INTRMD_ST_ADDRESS_1_EXT , a.INTRMD_ST_ADDRESS_2_EXT , a.INTRMD_ST_ADDRESS_3_EXT , a.INTRMD_ST_ADDRESS_4_EXT , a.INTRMD_ST_CITY_EXT , a.INTRMD_ST_COUNTRY_EXT , a.INTRMD_ST_COUNTY_EXT , a.INTRMD_ST_NAME_EXT , a.INTRMD_ST_POSTAL_CD_EXT , a.INTRMD_ST_PROVINCE_EXT , a.INTRMD_ST_STATE_EXT , a.INTRMD_ST_SITE_USE_ID , a.ITEM_CONTACT_CODE_1 , a.ITEM_CONTACT_CODE_2 , a.ITEM_CONTACT_VALUE_1 , a.ITEM_CONTACT_VALUE_2 , a.ITEM_DESCRIPTION_EXT , a.ITEM_DETAIL_QUANTITY , a.ITEM_DETAIL_REF_CODE_1 , a.ITEM_DETAIL_REF_CODE_2 , a.ITEM_DETAIL_REF_CODE_3 , a.ITEM_DETAIL_REF_VALUE_1 , a.ITEM_DETAIL_REF_VALUE_2 , a.ITEM_DETAIL_REF_VALUE_3 , a.ITEM_ENG_CNG_LVL_EXT , a.ITEM_MEASUREMENTS_EXT , a.ITEM_NOTE_TEXT , a.ITEM_REF_CODE_1 , a.ITEM_REF_CODE_2 , a.ITEM_REF_CODE_3 , a.ITEM_REF_VALUE_1 , a.ITEM_REF_VALUE_2 , a.ITEM_REF_VALUE_3 , a.ITEM_RELEASE_STATUS_EXT , a.LADING_QUANTITY_EXT , a.LETTER_CREDIT_EXPDT_EXT , a.LETTER_CREDIT_EXT , a.LINE_REFERENCE , a.LINK_TO_LINE_REF , a.OTHER_NAME_CODE_1 , a.OTHER_NAME_CODE_2 , a.OTHER_NAME_VALUE_1 , a.OTHER_NAME_VALUE_2 , a.PACK_SIZE_EXT , a.PACK_UNITS_PER_PACK_EXT , a.PACK_UOM_CODE_EXT , a.PACKAGING_CODE_EXT , a.PRIMARY_QUANTITY , a.PRIME_CONTRCTR_PART_EXT , a.PROCESS_STATUS , a.TP_ATTRIBUTE1 , a.TP_ATTRIBUTE2 , a.TP_ATTRIBUTE3 , a.TP_ATTRIBUTE4 , a.TP_ATTRIBUTE5 , a.TP_ATTRIBUTE6 , a.TP_ATTRIBUTE7 , a.TP_ATTRIBUTE8 , a.TP_ATTRIBUTE9 , a.TP_ATTRIBUTE10 , a.TP_ATTRIBUTE11 , a.TP_ATTRIBUTE12 , a.TP_ATTRIBUTE13 , a.TP_ATTRIBUTE14 , a.TP_ATTRIBUTE15 , a.TP_ATTRIBUTE_CATEGORY , 'INTERFACE' origin_table, a.line_source, a.ship_to_customer_id, a.ORG_ID from rlm_interface_lines a, rlm_interface_headers b WHERE a.header_id = b.header_id and b.process_status != 3 and a.process_status !=5 and a.ORG_ID = b.ORG_ID UNION SELECT a.PRIMARY_UOM_CODE, a.LINE_ID , a.LINE_NUMBER , a.CUSTOMER_ITEM_EXT, a.CUSTOMER_ITEM_ID , a.DATE_TYPE_CODE , a.INVENTORY_ITEM_ID, a.ITEM_DETAIL_SUBTYPE , a.ITEM_DETAIL_TYPE , a.QTY_TYPE_CODE , b.HEADER_ID , a.START_DATE_TIME , to_date(to_char(a.START_DATE_TIME,'YYYY/MM/DD'), 'YYYY/MM/DD') start_date , a.UOM_CODE , a.ATO_DATA_TYPE , a.CUST_PO_RELEASE_NUM , a.CUST_PO_DATE , a.CUST_PO_LINE_NUM , a.CUST_PO_NUMBER , a.RETURN_CONTAINER_EXT , a.ROUTING_DESC_EXT , a.ROUTING_SEQ_CODE_EXT , a.SCHEDULE_ITEM_NUM , a.SHIP_DEL_PATTERN_EXT , a.ship_del_rule_name, a.SHIP_DEL_TIME_CODE_EXT , a.SHIP_FROM_ADDRESS_1_EXT , a.SHIP_FROM_ADDRESS_2_EXT , a.SHIP_FROM_ADDRESS_3_EXT , a.SHIP_FROM_ADDRESS_4_EXT , a.SHIP_FROM_CITY_EXT , a.SHIP_FROM_COUNTRY_EXT , a.SHIP_FROM_COUNTY_EXT , a.SHIP_FROM_NAME_EXT , a.SHIP_FROM_ORG_ID , a.SHIP_FROM_POSTAL_CD_EXT , a.SHIP_FROM_PROVINCE_EXT , a.SHIP_FROM_STATE_EXT , a.SHIP_LABEL_INFO_LINE_1 , a.SHIP_LABEL_INFO_LINE_10 , a.SHIP_LABEL_INFO_LINE_2 , a.SHIP_LABEL_INFO_LINE_3 , a.SHIP_LABEL_INFO_LINE_4 , a.SHIP_LABEL_INFO_LINE_5 , a.SHIP_LABEL_INFO_LINE_6 , a.SHIP_LABEL_INFO_LINE_7 , a.SHIP_LABEL_INFO_LINE_8 , a.SHIP_LABEL_INFO_LINE_9 , a.SHIP_TO_ADDRESS_1_EXT , a.SHIP_TO_ADDRESS_2_EXT , a.SHIP_TO_ADDRESS_3_EXT , a.SHIP_TO_ADDRESS_4_EXT , a.SHIP_TO_ADDRESS_ID , a.SHIP_TO_ORG_ID , a.INVOICE_TO_ORG_ID , a.INTMED_SHIP_TO_ORG_ID , a.DELIVER_TO_ORG_ID , a.SHIP_TO_CITY_EXT , a.SHIP_TO_COUNTRY_EXT , a.SHIP_TO_COUNTY_EXT , a.SHIP_TO_NAME_EXT , a.SHIP_TO_POSTAL_CD_EXT , a.SHIP_TO_PROVINCE_EXT , a.SHIP_TO_SITE_USE_ID , a.SHIP_TO_STATE_EXT , a.SUBLINE_ASSIGNED_ID_EXT , a.SUBLINE_CONFIG_CODE_EXT , a.SUBLINE_CUST_ITEM_EXT , a.SUBLINE_CUST_ITEM_ID , a.SUBLINE_MODEL_NUM_EXT , a.SUBLINE_QUANTITY , a.SUBLINE_UOM_CODE , a.SUPPLIER_ITEM_EXT , a.TRANSIT_TIME_EXT , a.TRANSIT_TIME_QUAL_EXT , a.CUST_PRODUCTION_SEQ_NUM , a.TRANSPORT_LOC_QUAL_EXT , a.TRANSPORT_LOCATION_EXT , a.TRANSPORT_METHOD_EXT , a.WEIGHT_EXT , a.WEIGHT_QUALIFIER_EXT , a.WEIGHT_UOM_EXT , a.ITEM_DETAIL_SUBTYPE_EXT , a.ITEM_DETAIL_TYPE_EXT , a.QTY_TYPE_CODE_EXT , a.DATE_TYPE_CODE_EXT , a.FBO_CONFIGURATION_KEY_1 , a.FBO_CONFIGURATION_KEY_2 , a.FBO_CONFIGURATION_KEY_3 , a.FBO_CONFIGURATION_KEY_4 , a.FBO_CONFIGURATION_KEY_5 , a.MATCH_KEY_ACROSS , a.MATCH_KEY_WITHIN , a.CRITICAL_KEY_ATTRIBUTES , a.LAST_UPDATE_DATE , a.LAST_UPDATED_BY , a.CREATION_DATE , a.CREATED_BY , a.ATTRIBUTE_CATEGORY , a.ATTRIBUTE1 , a.ATTRIBUTE2 , a.ATTRIBUTE3 , a.ATTRIBUTE4 , a.ATTRIBUTE5 , a.ATTRIBUTE6 , a.ATTRIBUTE7 , a.ATTRIBUTE8 , a.ATTRIBUTE9 , a.ATTRIBUTE10 , a.ATTRIBUTE11 , a.ATTRIBUTE12 , a.ATTRIBUTE13 , a.ATTRIBUTE14 , a.ATTRIBUTE15 , a.LAST_UPDATE_LOGIN , a.REQUEST_ID , a.PROGRAM_APPLICATION_ID , a.PROGRAM_ID , a.PROGRAM_UPDATE_DATE , a.BILL_TO_ADDRESS_1_EXT , a.BILL_TO_ADDRESS_2_EXT , a.BILL_TO_ADDRESS_3_EXT , a.BILL_TO_ADDRESS_4_EXT , a.BILL_TO_ADDRESS_ID , a.BILL_TO_CITY_EXT , a.BILL_TO_COUNTRY_EXT , a.BILL_TO_COUNTY_EXT , a.BILL_TO_NAME_EXT , a.BILL_TO_POSTAL_CD_EXT , a.BILL_TO_PROVINCE_EXT , a.BILL_TO_SITE_USE_ID , a.BILL_TO_STATE_EXT , a.CARRIER_ID_CODE_EXT , a.CARRIER_QUALIFIER_EXT , a.COMMODITY_EXT , a.COUNTRY_OF_ORIGIN_EXT , a.CUST_ASSEMBLY_EXT , a.CUST_ASSIGNED_ID_EXT , a.CUST_BILL_TO_EXT , a.CUST_CONTRACT_NUM_EXT , a.CUSTOMER_DOCK_CODE , a.CUST_INTRMD_SHIP_TO_EXT , a.CUST_ITEM_PRICE_EXT , a.CUST_ITEM_PRICE_UOM_EXT , a.CUSTOMER_ITEM_REVISION , a.CUSTOMER_JOB , a.CUST_MANUFACTURER_EXT , a.CUST_MODEL_NUMBER_EXT , a.CUST_MODEL_SERIAL_NUMBER , a.CUST_ORDER_NUM_EXT , a.CUST_PROCESS_NUM_EXT , a.CUST_PRODUCTION_LINE , a.CUST_SET_NUM_EXT , a.CUST_SHIP_FROM_ORG_EXT , a.CUST_SHIP_TO_EXT , a.CUST_UOM_EXT , a.END_DATE_TIME , a.EQUIPMENT_CODE_EXT , a.EQUIPMENT_NUMBER_EXT , a.HANDLING_CODE_EXT , a.HAZARD_CODE_EXT , a.HAZARD_CODE_QUAL_EXT , a.HAZARD_DESCRIPTION_EXT , a.IMPORT_LICENSE_DATE_EXT , a.IMPORT_LICENSE_EXT , a.INDUSTRY_ATTRIBUTE1 , a.INDUSTRY_ATTRIBUTE10 , a.INDUSTRY_ATTRIBUTE11 , a.INDUSTRY_ATTRIBUTE12 , a.INDUSTRY_ATTRIBUTE13 , a.INDUSTRY_ATTRIBUTE14 , a.INDUSTRY_ATTRIBUTE15 , a.INDUSTRY_ATTRIBUTE2 , a.INDUSTRY_ATTRIBUTE3 , a.INDUSTRY_ATTRIBUTE4 , a.INDUSTRY_ATTRIBUTE5 , a.INDUSTRY_ATTRIBUTE6 , a.INDUSTRY_ATTRIBUTE7 , a.INDUSTRY_ATTRIBUTE8 , a.INDUSTRY_ATTRIBUTE9 , a.INDUSTRY_CONTEXT , a.INTRMD_SHIP_TO_ID , a.INTRMD_ST_ADDRESS_1_EXT , a.INTRMD_ST_ADDRESS_2_EXT , a.INTRMD_ST_ADDRESS_3_EXT , a.INTRMD_ST_ADDRESS_4_EXT , a.INTRMD_ST_CITY_EXT , a.INTRMD_ST_COUNTRY_EXT , a.INTRMD_ST_COUNTY_EXT , a.INTRMD_ST_NAME_EXT , a.INTRMD_ST_POSTAL_CD_EXT , a.INTRMD_ST_PROVINCE_EXT , a.INTRMD_ST_STATE_EXT , a.INTRMD_ST_SITE_USE_ID , a.ITEM_CONTACT_CODE_1 , a.ITEM_CONTACT_CODE_2 , a.ITEM_CONTACT_VALUE_1 , a.ITEM_CONTACT_VALUE_2 , a.ITEM_DESCRIPTION_EXT , a.ITEM_DETAIL_QUANTITY , a.ITEM_DETAIL_REF_CODE_1 , a.ITEM_DETAIL_REF_CODE_2 , a.ITEM_DETAIL_REF_CODE_3 , a.ITEM_DETAIL_REF_VALUE_1 , a.ITEM_DETAIL_REF_VALUE_2 , a.ITEM_DETAIL_REF_VALUE_3 , a.ITEM_ENG_CNG_LVL_EXT , a.ITEM_MEASUREMENTS_EXT , a.ITEM_NOTE_TEXT , a.ITEM_REF_CODE_1 , a.ITEM_REF_CODE_2 , a.ITEM_REF_CODE_3 , a.ITEM_REF_VALUE_1 , a.ITEM_REF_VALUE_2 , a.ITEM_REF_VALUE_3 , a.ITEM_RELEASE_STATUS_EXT , a.LADING_QUANTITY_EXT , a.LETTER_CREDIT_EXPDT_EXT , a.LETTER_CREDIT_EXT , a.LINE_REFERENCE , a.LINK_TO_LINE_REF , a.OTHER_NAME_CODE_1 , a.OTHER_NAME_CODE_2 , a.OTHER_NAME_VALUE_1 , a.OTHER_NAME_VALUE_2 , a.PACK_SIZE_EXT , a.PACK_UNITS_PER_PACK_EXT , a.PACK_UOM_CODE_EXT , a.PACKAGING_CODE_EXT , a.PRIMARY_QUANTITY , a.PRIME_CONTRCTR_PART_EXT , a.PROCESS_STATUS , a.TP_ATTRIBUTE1 , a.TP_ATTRIBUTE2 , a.TP_ATTRIBUTE3 , a.TP_ATTRIBUTE4 , a.TP_ATTRIBUTE5 , a.TP_ATTRIBUTE6 , a.TP_ATTRIBUTE7 , a.TP_ATTRIBUTE8 , a.TP_ATTRIBUTE9 , a.TP_ATTRIBUTE10 , a.TP_ATTRIBUTE11 , a.TP_ATTRIBUTE12 , a.TP_ATTRIBUTE13 , a.TP_ATTRIBUTE14 , a.TP_ATTRIBUTE15 , a.TP_ATTRIBUTE_CATEGORY , 'INTERFACE' origin_table, a.line_source, a.ship_to_customer_id, a.ORG_ID from rlm_schedule_lines_all a, rlm_interface_headers b WHERE a.header_id = b.schedule_header_id and b.process_status != 3 and a.process_status =5 and a.ORG_ID = b.ORG_ID UNION SELECT a.PRIMARY_UOM_CODE, a.LINE_ID , a.LINE_NUMBER , a.CUSTOMER_ITEM_EXT, a.CUSTOMER_ITEM_ID , a.DATE_TYPE_CODE , a.INVENTORY_ITEM_ID, a.ITEM_DETAIL_SUBTYPE , a.ITEM_DETAIL_TYPE , a.QTY_TYPE_CODE , a.HEADER_ID , a.START_DATE_TIME , to_date(to_char(a.START_DATE_TIME,'YYYY/MM/DD'),'YYYY/MM/DD') start_date , a.UOM_CODE , a.ATO_DATA_TYPE , a.CUST_PO_RELEASE_NUM , a.CUST_PO_DATE , a.CUST_PO_LINE_NUM , a.CUST_PO_NUMBER , a.RETURN_CONTAINER_EXT , a.ROUTING_DESC_EXT , a.ROUTING_SEQ_CODE_EXT , a.SCHEDULE_ITEM_NUM , a.SHIP_DEL_PATTERN_EXT , a.ship_del_rule_name, a.SHIP_DEL_TIME_CODE_EXT , a.SHIP_FROM_ADDRESS_1_EXT , a.SHIP_FROM_ADDRESS_2_EXT , a.SHIP_FROM_ADDRESS_3_EXT , a.SHIP_FROM_ADDRESS_4_EXT , a.SHIP_FROM_CITY_EXT , a.SHIP_FROM_COUNTRY_EXT , a.SHIP_FROM_COUNTY_EXT , a.SHIP_FROM_NAME_EXT , a.SHIP_FROM_ORG_ID , a.SHIP_FROM_POSTAL_CD_EXT , a.SHIP_FROM_PROVINCE_EXT , a.SHIP_FROM_STATE_EXT , a.SHIP_LABEL_INFO_LINE_1 , a.SHIP_LABEL_INFO_LINE_10 , a.SHIP_LABEL_INFO_LINE_2 , a.SHIP_LABEL_INFO_LINE_3 , a.SHIP_LABEL_INFO_LINE_4 , a.SHIP_LABEL_INFO_LINE_5 , a.SHIP_LABEL_INFO_LINE_6 , a.SHIP_LABEL_INFO_LINE_7 , a.SHIP_LABEL_INFO_LINE_8 , a.SHIP_LABEL_INFO_LINE_9 , a.SHIP_TO_ADDRESS_1_EXT , a.SHIP_TO_ADDRESS_2_EXT , a.SHIP_TO_ADDRESS_3_EXT , a.SHIP_TO_ADDRESS_4_EXT , a.SHIP_TO_ADDRESS_ID , a.SHIP_TO_ORG_ID , a.INVOICE_TO_ORG_ID , a.INTMED_SHIP_TO_ORG_ID , a.DELIVER_TO_ORG_ID , a.SHIP_TO_CITY_EXT , a.SHIP_TO_COUNTRY_EXT , a.SHIP_TO_COUNTY_EXT , a.SHIP_TO_NAME_EXT , a.SHIP_TO_POSTAL_CD_EXT , a.SHIP_TO_PROVINCE_EXT , a.SHIP_TO_SITE_USE_ID , a.SHIP_TO_STATE_EXT , a.SUBLINE_ASSIGNED_ID_EXT , a.SUBLINE_CONFIG_CODE_EXT , a.SUBLINE_CUST_ITEM_EXT , a.SUBLINE_CUST_ITEM_ID , a.SUBLINE_MODEL_NUM_EXT , a.SUBLINE_QUANTITY , a.SUBLINE_UOM_CODE , a.SUPPLIER_ITEM_EXT , a.TRANSIT_TIME_EXT , a.TRANSIT_TIME_QUAL_EXT , a.CUST_PRODUCTION_SEQ_NUM , a.TRANSPORT_LOC_QUAL_EXT , a.TRANSPORT_LOCATION_EXT , a.TRANSPORT_METHOD_EXT , a.WEIGHT_EXT , a.WEIGHT_QUALIFIER_EXT , a.WEIGHT_UOM_EXT , a.ITEM_DETAIL_SUBTYPE_EXT , a.ITEM_DETAIL_TYPE_EXT , a.QTY_TYPE_CODE_EXT , a.DATE_TYPE_CODE_EXT , a.FBO_CONFIGURATION_KEY_1 , a.FBO_CONFIGURATION_KEY_2 , a.FBO_CONFIGURATION_KEY_3 , a.FBO_CONFIGURATION_KEY_4 , a.FBO_CONFIGURATION_KEY_5 , a.MATCH_KEY_ACROSS , a.MATCH_KEY_WITHIN , a.CRITICAL_KEY_ATTRIBUTES , a.LAST_UPDATE_DATE , a.LAST_UPDATED_BY , a.CREATION_DATE , a.CREATED_BY , a.ATTRIBUTE_CATEGORY , a.ATTRIBUTE1 , a.ATTRIBUTE2 , a.ATTRIBUTE3 , a.ATTRIBUTE4 , a.ATTRIBUTE5 , a.ATTRIBUTE6 , a.ATTRIBUTE7 , a.ATTRIBUTE8 , a.ATTRIBUTE9 , a.ATTRIBUTE10 , a.ATTRIBUTE11 , a.ATTRIBUTE12 , a.ATTRIBUTE13 , a.ATTRIBUTE14 , a.ATTRIBUTE15 , a.LAST_UPDATE_LOGIN , a.REQUEST_ID , a.PROGRAM_APPLICATION_ID , a.PROGRAM_ID , a.PROGRAM_UPDATE_DATE , a.BILL_TO_ADDRESS_1_EXT , a.BILL_TO_ADDRESS_2_EXT , a.BILL_TO_ADDRESS_3_EXT , a.BILL_TO_ADDRESS_4_EXT , a.BILL_TO_ADDRESS_ID , a.BILL_TO_CITY_EXT , a.BILL_TO_COUNTRY_EXT , a.BILL_TO_COUNTY_EXT , a.BILL_TO_NAME_EXT , a.BILL_TO_POSTAL_CD_EXT , a.BILL_TO_PROVINCE_EXT , a.BILL_TO_SITE_USE_ID , a.BILL_TO_STATE_EXT , a.CARRIER_ID_CODE_EXT , a.CARRIER_QUALIFIER_EXT , a.COMMODITY_EXT , a.COUNTRY_OF_ORIGIN_EXT , a.CUST_ASSEMBLY_EXT , a.CUST_ASSIGNED_ID_EXT , a.CUST_BILL_TO_EXT , a.CUST_CONTRACT_NUM_EXT , a.CUSTOMER_DOCK_CODE , a.CUST_INTRMD_SHIP_TO_EXT , a.CUST_ITEM_PRICE_EXT , a.CUST_ITEM_PRICE_UOM_EXT , a.CUSTOMER_ITEM_REVISION , a.CUSTOMER_JOB , a.CUST_MANUFACTURER_EXT , a.CUST_MODEL_NUMBER_EXT , a.CUST_MODEL_SERIAL_NUMBER , a.CUST_ORDER_NUM_EXT , a.CUST_PROCESS_NUM_EXT , a.CUST_PRODUCTION_LINE , a.CUST_SET_NUM_EXT , a.CUST_SHIP_FROM_ORG_EXT , a.CUST_SHIP_TO_EXT , a.CUST_UOM_EXT , a.END_DATE_TIME , a.EQUIPMENT_CODE_EXT , a.EQUIPMENT_NUMBER_EXT , a.HANDLING_CODE_EXT , a.HAZARD_CODE_EXT , a.HAZARD_CODE_QUAL_EXT , a.HAZARD_DESCRIPTION_EXT , a.IMPORT_LICENSE_DATE_EXT , a.IMPORT_LICENSE_EXT , a.INDUSTRY_ATTRIBUTE1 , a.INDUSTRY_ATTRIBUTE10 , a.INDUSTRY_ATTRIBUTE11 , a.INDUSTRY_ATTRIBUTE12 , a.INDUSTRY_ATTRIBUTE13 , a.INDUSTRY_ATTRIBUTE14 , a.INDUSTRY_ATTRIBUTE15 , a.INDUSTRY_ATTRIBUTE2 , a.INDUSTRY_ATTRIBUTE3 , a.INDUSTRY_ATTRIBUTE4 , a.INDUSTRY_ATTRIBUTE5 , a.INDUSTRY_ATTRIBUTE6 , a.INDUSTRY_ATTRIBUTE7 , a.INDUSTRY_ATTRIBUTE8 , a.INDUSTRY_ATTRIBUTE9 , a.INDUSTRY_CONTEXT , a.INTRMD_SHIP_TO_ID , a.INTRMD_ST_ADDRESS_1_EXT , a.INTRMD_ST_ADDRESS_2_EXT , a.INTRMD_ST_ADDRESS_3_EXT , a.INTRMD_ST_ADDRESS_4_EXT , a.INTRMD_ST_CITY_EXT , a.INTRMD_ST_COUNTRY_EXT , a.INTRMD_ST_COUNTY_EXT , a.INTRMD_ST_NAME_EXT , a.INTRMD_ST_POSTAL_CD_EXT , a.INTRMD_ST_PROVINCE_EXT , a.INTRMD_ST_STATE_EXT , a.INTRMD_ST_SITE_USE_ID , a.ITEM_CONTACT_CODE_1 , a.ITEM_CONTACT_CODE_2 , a.ITEM_CONTACT_VALUE_1 , a.ITEM_CONTACT_VALUE_2 , a.ITEM_DESCRIPTION_EXT , a.ITEM_DETAIL_QUANTITY , a.ITEM_DETAIL_REF_CODE_1 , a.ITEM_DETAIL_REF_CODE_2 , a.ITEM_DETAIL_REF_CODE_3 , a.ITEM_DETAIL_REF_VALUE_1 , a.ITEM_DETAIL_REF_VALUE_2 , a.ITEM_DETAIL_REF_VALUE_3 , a.ITEM_ENG_CNG_LVL_EXT , a.ITEM_MEASUREMENTS_EXT , a.ITEM_NOTE_TEXT , a.ITEM_REF_CODE_1 , a.ITEM_REF_CODE_2 , a.ITEM_REF_CODE_3 , a.ITEM_REF_VALUE_1 , a.ITEM_REF_VALUE_2 , a.ITEM_REF_VALUE_3 , a.ITEM_RELEASE_STATUS_EXT , a.LADING_QUANTITY_EXT , a.LETTER_CREDIT_EXPDT_EXT , a.LETTER_CREDIT_EXT , a.LINE_REFERENCE , a.LINK_TO_LINE_REF , a.OTHER_NAME_CODE_1 , a.OTHER_NAME_CODE_2 , a.OTHER_NAME_VALUE_1 , a.OTHER_NAME_VALUE_2 , a.PACK_SIZE_EXT , a.PACK_UNITS_PER_PACK_EXT , a.PACK_UOM_CODE_EXT , a.PACKAGING_CODE_EXT , a.PRIMARY_QUANTITY , a.PRIME_CONTRCTR_PART_EXT , a.PROCESS_STATUS , a.TP_ATTRIBUTE1 , a.TP_ATTRIBUTE2 , a.TP_ATTRIBUTE3 , a.TP_ATTRIBUTE4 , a.TP_ATTRIBUTE5 , a.TP_ATTRIBUTE6 , a.TP_ATTRIBUTE7 , a.TP_ATTRIBUTE8 , a.TP_ATTRIBUTE9 , a.TP_ATTRIBUTE10 , a.TP_ATTRIBUTE11 , a.TP_ATTRIBUTE12 , a.TP_ATTRIBUTE13 , a.TP_ATTRIBUTE14 , a.TP_ATTRIBUTE15 , a.TP_ATTRIBUTE_CATEGORY , 'SCHEDULE' origin_table, a.line_source, a.ship_to_customer_id, a.ORG_ID from rlm_schedule_lines_all a , rlm_schedule_headers b where a.header_id = b.header_id and a.ORG_ID = b.ORG_ID and not exists ( select schedule_header_id from rlm_interface_headers_all rih where rih.schedule_header_id = b.header_id and rih.ORG_ID = a.ORG_ID) and b.process_status !=3

View Text - HTML Formatted

SELECT A.PRIMARY_UOM_CODE
, A.LINE_ID
, A.LINE_NUMBER
, A.CUSTOMER_ITEM_EXT
, A.CUSTOMER_ITEM_ID
, A.DATE_TYPE_CODE
, A.INVENTORY_ITEM_ID
, A.ITEM_DETAIL_SUBTYPE
, A.ITEM_DETAIL_TYPE
, A.QTY_TYPE_CODE
, A.HEADER_ID
, A.START_DATE_TIME
, TO_DATE(TO_CHAR(A.START_DATE_TIME
, 'YYYY/MM/DD')
, 'YYYY/MM/DD') START_DATE
, A.UOM_CODE
, A.ATO_DATA_TYPE
, A.CUST_PO_RELEASE_NUM
, A.CUST_PO_DATE
, A.CUST_PO_LINE_NUM
, A.CUST_PO_NUMBER
, A.RETURN_CONTAINER_EXT
, A.ROUTING_DESC_EXT
, A.ROUTING_SEQ_CODE_EXT
, A.SCHEDULE_ITEM_NUM
, A.SHIP_DEL_PATTERN_EXT
, A.SHIP_DEL_RULE_NAME
, A.SHIP_DEL_TIME_CODE_EXT
, A.SHIP_FROM_ADDRESS_1_EXT
, A.SHIP_FROM_ADDRESS_2_EXT
, A.SHIP_FROM_ADDRESS_3_EXT
, A.SHIP_FROM_ADDRESS_4_EXT
, A.SHIP_FROM_CITY_EXT
, A.SHIP_FROM_COUNTRY_EXT
, A.SHIP_FROM_COUNTY_EXT
, A.SHIP_FROM_NAME_EXT
, A.SHIP_FROM_ORG_ID
, A.SHIP_FROM_POSTAL_CD_EXT
, A.SHIP_FROM_PROVINCE_EXT
, A.SHIP_FROM_STATE_EXT
, A.SHIP_LABEL_INFO_LINE_1
, A.SHIP_LABEL_INFO_LINE_10
, A.SHIP_LABEL_INFO_LINE_2
, A.SHIP_LABEL_INFO_LINE_3
, A.SHIP_LABEL_INFO_LINE_4
, A.SHIP_LABEL_INFO_LINE_5
, A.SHIP_LABEL_INFO_LINE_6
, A.SHIP_LABEL_INFO_LINE_7
, A.SHIP_LABEL_INFO_LINE_8
, A.SHIP_LABEL_INFO_LINE_9
, A.SHIP_TO_ADDRESS_1_EXT
, A.SHIP_TO_ADDRESS_2_EXT
, A.SHIP_TO_ADDRESS_3_EXT
, A.SHIP_TO_ADDRESS_4_EXT
, A.SHIP_TO_ADDRESS_ID
, A.SHIP_TO_ORG_ID
, A.INVOICE_TO_ORG_ID
, A.INTMED_SHIP_TO_ORG_ID
, A.DELIVER_TO_ORG_ID
, A.SHIP_TO_CITY_EXT
, A.SHIP_TO_COUNTRY_EXT
, A.SHIP_TO_COUNTY_EXT
, A.SHIP_TO_NAME_EXT
, A.SHIP_TO_POSTAL_CD_EXT
, A.SHIP_TO_PROVINCE_EXT
, A.SHIP_TO_SITE_USE_ID
, A.SHIP_TO_STATE_EXT
, A.SUBLINE_ASSIGNED_ID_EXT
, A.SUBLINE_CONFIG_CODE_EXT
, A.SUBLINE_CUST_ITEM_EXT
, A.SUBLINE_CUST_ITEM_ID
, A.SUBLINE_MODEL_NUM_EXT
, A.SUBLINE_QUANTITY
, A.SUBLINE_UOM_CODE
, A.SUPPLIER_ITEM_EXT
, A.TRANSIT_TIME_EXT
, A.TRANSIT_TIME_QUAL_EXT
, A.CUST_PRODUCTION_SEQ_NUM
, A.TRANSPORT_LOC_QUAL_EXT
, A.TRANSPORT_LOCATION_EXT
, A.TRANSPORT_METHOD_EXT
, A.WEIGHT_EXT
, A.WEIGHT_QUALIFIER_EXT
, A.WEIGHT_UOM_EXT
, A.ITEM_DETAIL_SUBTYPE_EXT
, A.ITEM_DETAIL_TYPE_EXT
, A.QTY_TYPE_CODE_EXT
, A.DATE_TYPE_CODE_EXT
, A.FBO_CONFIGURATION_KEY_1
, A.FBO_CONFIGURATION_KEY_2
, A.FBO_CONFIGURATION_KEY_3
, A.FBO_CONFIGURATION_KEY_4
, A.FBO_CONFIGURATION_KEY_5
, A.MATCH_KEY_ACROSS
, A.MATCH_KEY_WITHIN
, A.CRITICAL_KEY_ATTRIBUTES
, A.LAST_UPDATE_DATE
, A.LAST_UPDATED_BY
, A.CREATION_DATE
, A.CREATED_BY
, A.ATTRIBUTE_CATEGORY
, A.ATTRIBUTE1
, A.ATTRIBUTE2
, A.ATTRIBUTE3
, A.ATTRIBUTE4
, A.ATTRIBUTE5
, A.ATTRIBUTE6
, A.ATTRIBUTE7
, A.ATTRIBUTE8
, A.ATTRIBUTE9
, A.ATTRIBUTE10
, A.ATTRIBUTE11
, A.ATTRIBUTE12
, A.ATTRIBUTE13
, A.ATTRIBUTE14
, A.ATTRIBUTE15
, A.LAST_UPDATE_LOGIN
, A.REQUEST_ID
, A.PROGRAM_APPLICATION_ID
, A.PROGRAM_ID
, A.PROGRAM_UPDATE_DATE
, A.BILL_TO_ADDRESS_1_EXT
, A.BILL_TO_ADDRESS_2_EXT
, A.BILL_TO_ADDRESS_3_EXT
, A.BILL_TO_ADDRESS_4_EXT
, A.BILL_TO_ADDRESS_ID
, A.BILL_TO_CITY_EXT
, A.BILL_TO_COUNTRY_EXT
, A.BILL_TO_COUNTY_EXT
, A.BILL_TO_NAME_EXT
, A.BILL_TO_POSTAL_CD_EXT
, A.BILL_TO_PROVINCE_EXT
, A.BILL_TO_SITE_USE_ID
, A.BILL_TO_STATE_EXT
, A.CARRIER_ID_CODE_EXT
, A.CARRIER_QUALIFIER_EXT
, A.COMMODITY_EXT
, A.COUNTRY_OF_ORIGIN_EXT
, A.CUST_ASSEMBLY_EXT
, A.CUST_ASSIGNED_ID_EXT
, A.CUST_BILL_TO_EXT
, A.CUST_CONTRACT_NUM_EXT
, A.CUSTOMER_DOCK_CODE
, A.CUST_INTRMD_SHIP_TO_EXT
, A.CUST_ITEM_PRICE_EXT
, A.CUST_ITEM_PRICE_UOM_EXT
, A.CUSTOMER_ITEM_REVISION
, A.CUSTOMER_JOB
, A.CUST_MANUFACTURER_EXT
, A.CUST_MODEL_NUMBER_EXT
, A.CUST_MODEL_SERIAL_NUMBER
, A.CUST_ORDER_NUM_EXT
, A.CUST_PROCESS_NUM_EXT
, A.CUST_PRODUCTION_LINE
, A.CUST_SET_NUM_EXT
, A.CUST_SHIP_FROM_ORG_EXT
, A.CUST_SHIP_TO_EXT
, A.CUST_UOM_EXT
, A.END_DATE_TIME
, A.EQUIPMENT_CODE_EXT
, A.EQUIPMENT_NUMBER_EXT
, A.HANDLING_CODE_EXT
, A.HAZARD_CODE_EXT
, A.HAZARD_CODE_QUAL_EXT
, A.HAZARD_DESCRIPTION_EXT
, A.IMPORT_LICENSE_DATE_EXT
, A.IMPORT_LICENSE_EXT
, A.INDUSTRY_ATTRIBUTE1
, A.INDUSTRY_ATTRIBUTE10
, A.INDUSTRY_ATTRIBUTE11
, A.INDUSTRY_ATTRIBUTE12
, A.INDUSTRY_ATTRIBUTE13
, A.INDUSTRY_ATTRIBUTE14
, A.INDUSTRY_ATTRIBUTE15
, A.INDUSTRY_ATTRIBUTE2
, A.INDUSTRY_ATTRIBUTE3
, A.INDUSTRY_ATTRIBUTE4
, A.INDUSTRY_ATTRIBUTE5
, A.INDUSTRY_ATTRIBUTE6
, A.INDUSTRY_ATTRIBUTE7
, A.INDUSTRY_ATTRIBUTE8
, A.INDUSTRY_ATTRIBUTE9
, A.INDUSTRY_CONTEXT
, A.INTRMD_SHIP_TO_ID
, A.INTRMD_ST_ADDRESS_1_EXT
, A.INTRMD_ST_ADDRESS_2_EXT
, A.INTRMD_ST_ADDRESS_3_EXT
, A.INTRMD_ST_ADDRESS_4_EXT
, A.INTRMD_ST_CITY_EXT
, A.INTRMD_ST_COUNTRY_EXT
, A.INTRMD_ST_COUNTY_EXT
, A.INTRMD_ST_NAME_EXT
, A.INTRMD_ST_POSTAL_CD_EXT
, A.INTRMD_ST_PROVINCE_EXT
, A.INTRMD_ST_STATE_EXT
, A.INTRMD_ST_SITE_USE_ID
, A.ITEM_CONTACT_CODE_1
, A.ITEM_CONTACT_CODE_2
, A.ITEM_CONTACT_VALUE_1
, A.ITEM_CONTACT_VALUE_2
, A.ITEM_DESCRIPTION_EXT
, A.ITEM_DETAIL_QUANTITY
, A.ITEM_DETAIL_REF_CODE_1
, A.ITEM_DETAIL_REF_CODE_2
, A.ITEM_DETAIL_REF_CODE_3
, A.ITEM_DETAIL_REF_VALUE_1
, A.ITEM_DETAIL_REF_VALUE_2
, A.ITEM_DETAIL_REF_VALUE_3
, A.ITEM_ENG_CNG_LVL_EXT
, A.ITEM_MEASUREMENTS_EXT
, A.ITEM_NOTE_TEXT
, A.ITEM_REF_CODE_1
, A.ITEM_REF_CODE_2
, A.ITEM_REF_CODE_3
, A.ITEM_REF_VALUE_1
, A.ITEM_REF_VALUE_2
, A.ITEM_REF_VALUE_3
, A.ITEM_RELEASE_STATUS_EXT
, A.LADING_QUANTITY_EXT
, A.LETTER_CREDIT_EXPDT_EXT
, A.LETTER_CREDIT_EXT
, A.LINE_REFERENCE
, A.LINK_TO_LINE_REF
, A.OTHER_NAME_CODE_1
, A.OTHER_NAME_CODE_2
, A.OTHER_NAME_VALUE_1
, A.OTHER_NAME_VALUE_2
, A.PACK_SIZE_EXT
, A.PACK_UNITS_PER_PACK_EXT
, A.PACK_UOM_CODE_EXT
, A.PACKAGING_CODE_EXT
, A.PRIMARY_QUANTITY
, A.PRIME_CONTRCTR_PART_EXT
, A.PROCESS_STATUS
, A.TP_ATTRIBUTE1
, A.TP_ATTRIBUTE2
, A.TP_ATTRIBUTE3
, A.TP_ATTRIBUTE4
, A.TP_ATTRIBUTE5
, A.TP_ATTRIBUTE6
, A.TP_ATTRIBUTE7
, A.TP_ATTRIBUTE8
, A.TP_ATTRIBUTE9
, A.TP_ATTRIBUTE10
, A.TP_ATTRIBUTE11
, A.TP_ATTRIBUTE12
, A.TP_ATTRIBUTE13
, A.TP_ATTRIBUTE14
, A.TP_ATTRIBUTE15
, A.TP_ATTRIBUTE_CATEGORY
, 'INTERFACE' ORIGIN_TABLE
, A.LINE_SOURCE
, A.SHIP_TO_CUSTOMER_ID
, A.ORG_ID
FROM RLM_INTERFACE_LINES A
, RLM_INTERFACE_HEADERS B
WHERE A.HEADER_ID = B.HEADER_ID
AND B.PROCESS_STATUS != 3
AND A.PROCESS_STATUS !=5
AND A.ORG_ID = B.ORG_ID UNION SELECT A.PRIMARY_UOM_CODE
, A.LINE_ID
, A.LINE_NUMBER
, A.CUSTOMER_ITEM_EXT
, A.CUSTOMER_ITEM_ID
, A.DATE_TYPE_CODE
, A.INVENTORY_ITEM_ID
, A.ITEM_DETAIL_SUBTYPE
, A.ITEM_DETAIL_TYPE
, A.QTY_TYPE_CODE
, B.HEADER_ID
, A.START_DATE_TIME
, TO_DATE(TO_CHAR(A.START_DATE_TIME
, 'YYYY/MM/DD')
, 'YYYY/MM/DD') START_DATE
, A.UOM_CODE
, A.ATO_DATA_TYPE
, A.CUST_PO_RELEASE_NUM
, A.CUST_PO_DATE
, A.CUST_PO_LINE_NUM
, A.CUST_PO_NUMBER
, A.RETURN_CONTAINER_EXT
, A.ROUTING_DESC_EXT
, A.ROUTING_SEQ_CODE_EXT
, A.SCHEDULE_ITEM_NUM
, A.SHIP_DEL_PATTERN_EXT
, A.SHIP_DEL_RULE_NAME
, A.SHIP_DEL_TIME_CODE_EXT
, A.SHIP_FROM_ADDRESS_1_EXT
, A.SHIP_FROM_ADDRESS_2_EXT
, A.SHIP_FROM_ADDRESS_3_EXT
, A.SHIP_FROM_ADDRESS_4_EXT
, A.SHIP_FROM_CITY_EXT
, A.SHIP_FROM_COUNTRY_EXT
, A.SHIP_FROM_COUNTY_EXT
, A.SHIP_FROM_NAME_EXT
, A.SHIP_FROM_ORG_ID
, A.SHIP_FROM_POSTAL_CD_EXT
, A.SHIP_FROM_PROVINCE_EXT
, A.SHIP_FROM_STATE_EXT
, A.SHIP_LABEL_INFO_LINE_1
, A.SHIP_LABEL_INFO_LINE_10
, A.SHIP_LABEL_INFO_LINE_2
, A.SHIP_LABEL_INFO_LINE_3
, A.SHIP_LABEL_INFO_LINE_4
, A.SHIP_LABEL_INFO_LINE_5
, A.SHIP_LABEL_INFO_LINE_6
, A.SHIP_LABEL_INFO_LINE_7
, A.SHIP_LABEL_INFO_LINE_8
, A.SHIP_LABEL_INFO_LINE_9
, A.SHIP_TO_ADDRESS_1_EXT
, A.SHIP_TO_ADDRESS_2_EXT
, A.SHIP_TO_ADDRESS_3_EXT
, A.SHIP_TO_ADDRESS_4_EXT
, A.SHIP_TO_ADDRESS_ID
, A.SHIP_TO_ORG_ID
, A.INVOICE_TO_ORG_ID
, A.INTMED_SHIP_TO_ORG_ID
, A.DELIVER_TO_ORG_ID
, A.SHIP_TO_CITY_EXT
, A.SHIP_TO_COUNTRY_EXT
, A.SHIP_TO_COUNTY_EXT
, A.SHIP_TO_NAME_EXT
, A.SHIP_TO_POSTAL_CD_EXT
, A.SHIP_TO_PROVINCE_EXT
, A.SHIP_TO_SITE_USE_ID
, A.SHIP_TO_STATE_EXT
, A.SUBLINE_ASSIGNED_ID_EXT
, A.SUBLINE_CONFIG_CODE_EXT
, A.SUBLINE_CUST_ITEM_EXT
, A.SUBLINE_CUST_ITEM_ID
, A.SUBLINE_MODEL_NUM_EXT
, A.SUBLINE_QUANTITY
, A.SUBLINE_UOM_CODE
, A.SUPPLIER_ITEM_EXT
, A.TRANSIT_TIME_EXT
, A.TRANSIT_TIME_QUAL_EXT
, A.CUST_PRODUCTION_SEQ_NUM
, A.TRANSPORT_LOC_QUAL_EXT
, A.TRANSPORT_LOCATION_EXT
, A.TRANSPORT_METHOD_EXT
, A.WEIGHT_EXT
, A.WEIGHT_QUALIFIER_EXT
, A.WEIGHT_UOM_EXT
, A.ITEM_DETAIL_SUBTYPE_EXT
, A.ITEM_DETAIL_TYPE_EXT
, A.QTY_TYPE_CODE_EXT
, A.DATE_TYPE_CODE_EXT
, A.FBO_CONFIGURATION_KEY_1
, A.FBO_CONFIGURATION_KEY_2
, A.FBO_CONFIGURATION_KEY_3
, A.FBO_CONFIGURATION_KEY_4
, A.FBO_CONFIGURATION_KEY_5
, A.MATCH_KEY_ACROSS
, A.MATCH_KEY_WITHIN
, A.CRITICAL_KEY_ATTRIBUTES
, A.LAST_UPDATE_DATE
, A.LAST_UPDATED_BY
, A.CREATION_DATE
, A.CREATED_BY
, A.ATTRIBUTE_CATEGORY
, A.ATTRIBUTE1
, A.ATTRIBUTE2
, A.ATTRIBUTE3
, A.ATTRIBUTE4
, A.ATTRIBUTE5
, A.ATTRIBUTE6
, A.ATTRIBUTE7
, A.ATTRIBUTE8
, A.ATTRIBUTE9
, A.ATTRIBUTE10
, A.ATTRIBUTE11
, A.ATTRIBUTE12
, A.ATTRIBUTE13
, A.ATTRIBUTE14
, A.ATTRIBUTE15
, A.LAST_UPDATE_LOGIN
, A.REQUEST_ID
, A.PROGRAM_APPLICATION_ID
, A.PROGRAM_ID
, A.PROGRAM_UPDATE_DATE
, A.BILL_TO_ADDRESS_1_EXT
, A.BILL_TO_ADDRESS_2_EXT
, A.BILL_TO_ADDRESS_3_EXT
, A.BILL_TO_ADDRESS_4_EXT
, A.BILL_TO_ADDRESS_ID
, A.BILL_TO_CITY_EXT
, A.BILL_TO_COUNTRY_EXT
, A.BILL_TO_COUNTY_EXT
, A.BILL_TO_NAME_EXT
, A.BILL_TO_POSTAL_CD_EXT
, A.BILL_TO_PROVINCE_EXT
, A.BILL_TO_SITE_USE_ID
, A.BILL_TO_STATE_EXT
, A.CARRIER_ID_CODE_EXT
, A.CARRIER_QUALIFIER_EXT
, A.COMMODITY_EXT
, A.COUNTRY_OF_ORIGIN_EXT
, A.CUST_ASSEMBLY_EXT
, A.CUST_ASSIGNED_ID_EXT
, A.CUST_BILL_TO_EXT
, A.CUST_CONTRACT_NUM_EXT
, A.CUSTOMER_DOCK_CODE
, A.CUST_INTRMD_SHIP_TO_EXT
, A.CUST_ITEM_PRICE_EXT
, A.CUST_ITEM_PRICE_UOM_EXT
, A.CUSTOMER_ITEM_REVISION
, A.CUSTOMER_JOB
, A.CUST_MANUFACTURER_EXT
, A.CUST_MODEL_NUMBER_EXT
, A.CUST_MODEL_SERIAL_NUMBER
, A.CUST_ORDER_NUM_EXT
, A.CUST_PROCESS_NUM_EXT
, A.CUST_PRODUCTION_LINE
, A.CUST_SET_NUM_EXT
, A.CUST_SHIP_FROM_ORG_EXT
, A.CUST_SHIP_TO_EXT
, A.CUST_UOM_EXT
, A.END_DATE_TIME
, A.EQUIPMENT_CODE_EXT
, A.EQUIPMENT_NUMBER_EXT
, A.HANDLING_CODE_EXT
, A.HAZARD_CODE_EXT
, A.HAZARD_CODE_QUAL_EXT
, A.HAZARD_DESCRIPTION_EXT
, A.IMPORT_LICENSE_DATE_EXT
, A.IMPORT_LICENSE_EXT
, A.INDUSTRY_ATTRIBUTE1
, A.INDUSTRY_ATTRIBUTE10
, A.INDUSTRY_ATTRIBUTE11
, A.INDUSTRY_ATTRIBUTE12
, A.INDUSTRY_ATTRIBUTE13
, A.INDUSTRY_ATTRIBUTE14
, A.INDUSTRY_ATTRIBUTE15
, A.INDUSTRY_ATTRIBUTE2
, A.INDUSTRY_ATTRIBUTE3
, A.INDUSTRY_ATTRIBUTE4
, A.INDUSTRY_ATTRIBUTE5
, A.INDUSTRY_ATTRIBUTE6
, A.INDUSTRY_ATTRIBUTE7
, A.INDUSTRY_ATTRIBUTE8
, A.INDUSTRY_ATTRIBUTE9
, A.INDUSTRY_CONTEXT
, A.INTRMD_SHIP_TO_ID
, A.INTRMD_ST_ADDRESS_1_EXT
, A.INTRMD_ST_ADDRESS_2_EXT
, A.INTRMD_ST_ADDRESS_3_EXT
, A.INTRMD_ST_ADDRESS_4_EXT
, A.INTRMD_ST_CITY_EXT
, A.INTRMD_ST_COUNTRY_EXT
, A.INTRMD_ST_COUNTY_EXT
, A.INTRMD_ST_NAME_EXT
, A.INTRMD_ST_POSTAL_CD_EXT
, A.INTRMD_ST_PROVINCE_EXT
, A.INTRMD_ST_STATE_EXT
, A.INTRMD_ST_SITE_USE_ID
, A.ITEM_CONTACT_CODE_1
, A.ITEM_CONTACT_CODE_2
, A.ITEM_CONTACT_VALUE_1
, A.ITEM_CONTACT_VALUE_2
, A.ITEM_DESCRIPTION_EXT
, A.ITEM_DETAIL_QUANTITY
, A.ITEM_DETAIL_REF_CODE_1
, A.ITEM_DETAIL_REF_CODE_2
, A.ITEM_DETAIL_REF_CODE_3
, A.ITEM_DETAIL_REF_VALUE_1
, A.ITEM_DETAIL_REF_VALUE_2
, A.ITEM_DETAIL_REF_VALUE_3
, A.ITEM_ENG_CNG_LVL_EXT
, A.ITEM_MEASUREMENTS_EXT
, A.ITEM_NOTE_TEXT
, A.ITEM_REF_CODE_1
, A.ITEM_REF_CODE_2
, A.ITEM_REF_CODE_3
, A.ITEM_REF_VALUE_1
, A.ITEM_REF_VALUE_2
, A.ITEM_REF_VALUE_3
, A.ITEM_RELEASE_STATUS_EXT
, A.LADING_QUANTITY_EXT
, A.LETTER_CREDIT_EXPDT_EXT
, A.LETTER_CREDIT_EXT
, A.LINE_REFERENCE
, A.LINK_TO_LINE_REF
, A.OTHER_NAME_CODE_1
, A.OTHER_NAME_CODE_2
, A.OTHER_NAME_VALUE_1
, A.OTHER_NAME_VALUE_2
, A.PACK_SIZE_EXT
, A.PACK_UNITS_PER_PACK_EXT
, A.PACK_UOM_CODE_EXT
, A.PACKAGING_CODE_EXT
, A.PRIMARY_QUANTITY
, A.PRIME_CONTRCTR_PART_EXT
, A.PROCESS_STATUS
, A.TP_ATTRIBUTE1
, A.TP_ATTRIBUTE2
, A.TP_ATTRIBUTE3
, A.TP_ATTRIBUTE4
, A.TP_ATTRIBUTE5
, A.TP_ATTRIBUTE6
, A.TP_ATTRIBUTE7
, A.TP_ATTRIBUTE8
, A.TP_ATTRIBUTE9
, A.TP_ATTRIBUTE10
, A.TP_ATTRIBUTE11
, A.TP_ATTRIBUTE12
, A.TP_ATTRIBUTE13
, A.TP_ATTRIBUTE14
, A.TP_ATTRIBUTE15
, A.TP_ATTRIBUTE_CATEGORY
, 'INTERFACE' ORIGIN_TABLE
, A.LINE_SOURCE
, A.SHIP_TO_CUSTOMER_ID
, A.ORG_ID
FROM RLM_SCHEDULE_LINES_ALL A
, RLM_INTERFACE_HEADERS B
WHERE A.HEADER_ID = B.SCHEDULE_HEADER_ID
AND B.PROCESS_STATUS != 3
AND A.PROCESS_STATUS =5
AND A.ORG_ID = B.ORG_ID UNION SELECT A.PRIMARY_UOM_CODE
, A.LINE_ID
, A.LINE_NUMBER
, A.CUSTOMER_ITEM_EXT
, A.CUSTOMER_ITEM_ID
, A.DATE_TYPE_CODE
, A.INVENTORY_ITEM_ID
, A.ITEM_DETAIL_SUBTYPE
, A.ITEM_DETAIL_TYPE
, A.QTY_TYPE_CODE
, A.HEADER_ID
, A.START_DATE_TIME
, TO_DATE(TO_CHAR(A.START_DATE_TIME
, 'YYYY/MM/DD')
, 'YYYY/MM/DD') START_DATE
, A.UOM_CODE
, A.ATO_DATA_TYPE
, A.CUST_PO_RELEASE_NUM
, A.CUST_PO_DATE
, A.CUST_PO_LINE_NUM
, A.CUST_PO_NUMBER
, A.RETURN_CONTAINER_EXT
, A.ROUTING_DESC_EXT
, A.ROUTING_SEQ_CODE_EXT
, A.SCHEDULE_ITEM_NUM
, A.SHIP_DEL_PATTERN_EXT
, A.SHIP_DEL_RULE_NAME
, A.SHIP_DEL_TIME_CODE_EXT
, A.SHIP_FROM_ADDRESS_1_EXT
, A.SHIP_FROM_ADDRESS_2_EXT
, A.SHIP_FROM_ADDRESS_3_EXT
, A.SHIP_FROM_ADDRESS_4_EXT
, A.SHIP_FROM_CITY_EXT
, A.SHIP_FROM_COUNTRY_EXT
, A.SHIP_FROM_COUNTY_EXT
, A.SHIP_FROM_NAME_EXT
, A.SHIP_FROM_ORG_ID
, A.SHIP_FROM_POSTAL_CD_EXT
, A.SHIP_FROM_PROVINCE_EXT
, A.SHIP_FROM_STATE_EXT
, A.SHIP_LABEL_INFO_LINE_1
, A.SHIP_LABEL_INFO_LINE_10
, A.SHIP_LABEL_INFO_LINE_2
, A.SHIP_LABEL_INFO_LINE_3
, A.SHIP_LABEL_INFO_LINE_4
, A.SHIP_LABEL_INFO_LINE_5
, A.SHIP_LABEL_INFO_LINE_6
, A.SHIP_LABEL_INFO_LINE_7
, A.SHIP_LABEL_INFO_LINE_8
, A.SHIP_LABEL_INFO_LINE_9
, A.SHIP_TO_ADDRESS_1_EXT
, A.SHIP_TO_ADDRESS_2_EXT
, A.SHIP_TO_ADDRESS_3_EXT
, A.SHIP_TO_ADDRESS_4_EXT
, A.SHIP_TO_ADDRESS_ID
, A.SHIP_TO_ORG_ID
, A.INVOICE_TO_ORG_ID
, A.INTMED_SHIP_TO_ORG_ID
, A.DELIVER_TO_ORG_ID
, A.SHIP_TO_CITY_EXT
, A.SHIP_TO_COUNTRY_EXT
, A.SHIP_TO_COUNTY_EXT
, A.SHIP_TO_NAME_EXT
, A.SHIP_TO_POSTAL_CD_EXT
, A.SHIP_TO_PROVINCE_EXT
, A.SHIP_TO_SITE_USE_ID
, A.SHIP_TO_STATE_EXT
, A.SUBLINE_ASSIGNED_ID_EXT
, A.SUBLINE_CONFIG_CODE_EXT
, A.SUBLINE_CUST_ITEM_EXT
, A.SUBLINE_CUST_ITEM_ID
, A.SUBLINE_MODEL_NUM_EXT
, A.SUBLINE_QUANTITY
, A.SUBLINE_UOM_CODE
, A.SUPPLIER_ITEM_EXT
, A.TRANSIT_TIME_EXT
, A.TRANSIT_TIME_QUAL_EXT
, A.CUST_PRODUCTION_SEQ_NUM
, A.TRANSPORT_LOC_QUAL_EXT
, A.TRANSPORT_LOCATION_EXT
, A.TRANSPORT_METHOD_EXT
, A.WEIGHT_EXT
, A.WEIGHT_QUALIFIER_EXT
, A.WEIGHT_UOM_EXT
, A.ITEM_DETAIL_SUBTYPE_EXT
, A.ITEM_DETAIL_TYPE_EXT
, A.QTY_TYPE_CODE_EXT
, A.DATE_TYPE_CODE_EXT
, A.FBO_CONFIGURATION_KEY_1
, A.FBO_CONFIGURATION_KEY_2
, A.FBO_CONFIGURATION_KEY_3
, A.FBO_CONFIGURATION_KEY_4
, A.FBO_CONFIGURATION_KEY_5
, A.MATCH_KEY_ACROSS
, A.MATCH_KEY_WITHIN
, A.CRITICAL_KEY_ATTRIBUTES
, A.LAST_UPDATE_DATE
, A.LAST_UPDATED_BY
, A.CREATION_DATE
, A.CREATED_BY
, A.ATTRIBUTE_CATEGORY
, A.ATTRIBUTE1
, A.ATTRIBUTE2
, A.ATTRIBUTE3
, A.ATTRIBUTE4
, A.ATTRIBUTE5
, A.ATTRIBUTE6
, A.ATTRIBUTE7
, A.ATTRIBUTE8
, A.ATTRIBUTE9
, A.ATTRIBUTE10
, A.ATTRIBUTE11
, A.ATTRIBUTE12
, A.ATTRIBUTE13
, A.ATTRIBUTE14
, A.ATTRIBUTE15
, A.LAST_UPDATE_LOGIN
, A.REQUEST_ID
, A.PROGRAM_APPLICATION_ID
, A.PROGRAM_ID
, A.PROGRAM_UPDATE_DATE
, A.BILL_TO_ADDRESS_1_EXT
, A.BILL_TO_ADDRESS_2_EXT
, A.BILL_TO_ADDRESS_3_EXT
, A.BILL_TO_ADDRESS_4_EXT
, A.BILL_TO_ADDRESS_ID
, A.BILL_TO_CITY_EXT
, A.BILL_TO_COUNTRY_EXT
, A.BILL_TO_COUNTY_EXT
, A.BILL_TO_NAME_EXT
, A.BILL_TO_POSTAL_CD_EXT
, A.BILL_TO_PROVINCE_EXT
, A.BILL_TO_SITE_USE_ID
, A.BILL_TO_STATE_EXT
, A.CARRIER_ID_CODE_EXT
, A.CARRIER_QUALIFIER_EXT
, A.COMMODITY_EXT
, A.COUNTRY_OF_ORIGIN_EXT
, A.CUST_ASSEMBLY_EXT
, A.CUST_ASSIGNED_ID_EXT
, A.CUST_BILL_TO_EXT
, A.CUST_CONTRACT_NUM_EXT
, A.CUSTOMER_DOCK_CODE
, A.CUST_INTRMD_SHIP_TO_EXT
, A.CUST_ITEM_PRICE_EXT
, A.CUST_ITEM_PRICE_UOM_EXT
, A.CUSTOMER_ITEM_REVISION
, A.CUSTOMER_JOB
, A.CUST_MANUFACTURER_EXT
, A.CUST_MODEL_NUMBER_EXT
, A.CUST_MODEL_SERIAL_NUMBER
, A.CUST_ORDER_NUM_EXT
, A.CUST_PROCESS_NUM_EXT
, A.CUST_PRODUCTION_LINE
, A.CUST_SET_NUM_EXT
, A.CUST_SHIP_FROM_ORG_EXT
, A.CUST_SHIP_TO_EXT
, A.CUST_UOM_EXT
, A.END_DATE_TIME
, A.EQUIPMENT_CODE_EXT
, A.EQUIPMENT_NUMBER_EXT
, A.HANDLING_CODE_EXT
, A.HAZARD_CODE_EXT
, A.HAZARD_CODE_QUAL_EXT
, A.HAZARD_DESCRIPTION_EXT
, A.IMPORT_LICENSE_DATE_EXT
, A.IMPORT_LICENSE_EXT
, A.INDUSTRY_ATTRIBUTE1
, A.INDUSTRY_ATTRIBUTE10
, A.INDUSTRY_ATTRIBUTE11
, A.INDUSTRY_ATTRIBUTE12
, A.INDUSTRY_ATTRIBUTE13
, A.INDUSTRY_ATTRIBUTE14
, A.INDUSTRY_ATTRIBUTE15
, A.INDUSTRY_ATTRIBUTE2
, A.INDUSTRY_ATTRIBUTE3
, A.INDUSTRY_ATTRIBUTE4
, A.INDUSTRY_ATTRIBUTE5
, A.INDUSTRY_ATTRIBUTE6
, A.INDUSTRY_ATTRIBUTE7
, A.INDUSTRY_ATTRIBUTE8
, A.INDUSTRY_ATTRIBUTE9
, A.INDUSTRY_CONTEXT
, A.INTRMD_SHIP_TO_ID
, A.INTRMD_ST_ADDRESS_1_EXT
, A.INTRMD_ST_ADDRESS_2_EXT
, A.INTRMD_ST_ADDRESS_3_EXT
, A.INTRMD_ST_ADDRESS_4_EXT
, A.INTRMD_ST_CITY_EXT
, A.INTRMD_ST_COUNTRY_EXT
, A.INTRMD_ST_COUNTY_EXT
, A.INTRMD_ST_NAME_EXT
, A.INTRMD_ST_POSTAL_CD_EXT
, A.INTRMD_ST_PROVINCE_EXT
, A.INTRMD_ST_STATE_EXT
, A.INTRMD_ST_SITE_USE_ID
, A.ITEM_CONTACT_CODE_1
, A.ITEM_CONTACT_CODE_2
, A.ITEM_CONTACT_VALUE_1
, A.ITEM_CONTACT_VALUE_2
, A.ITEM_DESCRIPTION_EXT
, A.ITEM_DETAIL_QUANTITY
, A.ITEM_DETAIL_REF_CODE_1
, A.ITEM_DETAIL_REF_CODE_2
, A.ITEM_DETAIL_REF_CODE_3
, A.ITEM_DETAIL_REF_VALUE_1
, A.ITEM_DETAIL_REF_VALUE_2
, A.ITEM_DETAIL_REF_VALUE_3
, A.ITEM_ENG_CNG_LVL_EXT
, A.ITEM_MEASUREMENTS_EXT
, A.ITEM_NOTE_TEXT
, A.ITEM_REF_CODE_1
, A.ITEM_REF_CODE_2
, A.ITEM_REF_CODE_3
, A.ITEM_REF_VALUE_1
, A.ITEM_REF_VALUE_2
, A.ITEM_REF_VALUE_3
, A.ITEM_RELEASE_STATUS_EXT
, A.LADING_QUANTITY_EXT
, A.LETTER_CREDIT_EXPDT_EXT
, A.LETTER_CREDIT_EXT
, A.LINE_REFERENCE
, A.LINK_TO_LINE_REF
, A.OTHER_NAME_CODE_1
, A.OTHER_NAME_CODE_2
, A.OTHER_NAME_VALUE_1
, A.OTHER_NAME_VALUE_2
, A.PACK_SIZE_EXT
, A.PACK_UNITS_PER_PACK_EXT
, A.PACK_UOM_CODE_EXT
, A.PACKAGING_CODE_EXT
, A.PRIMARY_QUANTITY
, A.PRIME_CONTRCTR_PART_EXT
, A.PROCESS_STATUS
, A.TP_ATTRIBUTE1
, A.TP_ATTRIBUTE2
, A.TP_ATTRIBUTE3
, A.TP_ATTRIBUTE4
, A.TP_ATTRIBUTE5
, A.TP_ATTRIBUTE6
, A.TP_ATTRIBUTE7
, A.TP_ATTRIBUTE8
, A.TP_ATTRIBUTE9
, A.TP_ATTRIBUTE10
, A.TP_ATTRIBUTE11
, A.TP_ATTRIBUTE12
, A.TP_ATTRIBUTE13
, A.TP_ATTRIBUTE14
, A.TP_ATTRIBUTE15
, A.TP_ATTRIBUTE_CATEGORY
, 'SCHEDULE' ORIGIN_TABLE
, A.LINE_SOURCE
, A.SHIP_TO_CUSTOMER_ID
, A.ORG_ID
FROM RLM_SCHEDULE_LINES_ALL A
, RLM_SCHEDULE_HEADERS B
WHERE A.HEADER_ID = B.HEADER_ID
AND A.ORG_ID = B.ORG_ID
AND NOT EXISTS ( SELECT SCHEDULE_HEADER_ID
FROM RLM_INTERFACE_HEADERS_ALL RIH
WHERE RIH.SCHEDULE_HEADER_ID = B.HEADER_ID
AND RIH.ORG_ID = A.ORG_ID)
AND B.PROCESS_STATUS !=3