VIEW: APPS.RLM_SCHEDULE_ITEMS_V

Source

View Text - Preformatted

SELECT distinct a.schedule_item_num, a.item_description_ext, a.header_id, 'INTERFACE' origin_table, a.cust_ship_from_org_ext, a.cust_ship_to_ext, a.customer_item_ext, a.customer_item_id, a.inventory_item_id, a.supplier_item_ext, a.cust_assigned_id_ext, a.country_of_origin_ext, a.commodity_ext, a.cust_model_number_ext, a.item_eng_cng_lvl_ext, a.customer_item_revision, a.item_release_status_ext, a.item_measurements_ext, a.ship_del_pattern_ext, a.ship_del_rule_name, a.ship_del_time_code_ext, a.cust_po_number, a.cust_po_date, a.cust_po_release_num, a.cust_po_line_num, a.cust_contract_num_ext, a.import_license_ext, a.import_license_date_ext, a.letter_credit_ext, a.letter_credit_expdt_ext, a.cust_item_price_ext, a.cust_item_price_uom_ext, a.pack_units_per_pack_ext, a.pack_size_ext, a.pack_uom_code_ext, a.hazard_code_qual_ext, a.hazard_code_ext, a.hazard_description_ext, a.handling_code_ext, a.return_container_ext, a.ship_label_info_line_1, 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_label_info_line_10, a.cust_bill_to_ext, a.cust_intrmd_ship_to_ext, a.other_name_code_1, a.other_name_value_1, a.other_name_code_2, a.other_name_value_2, a.item_ref_code_1, a.item_ref_value_1, a.item_ref_code_2, a.item_ref_value_2, a.item_ref_code_3, a.item_ref_value_3, a.item_contact_code_1, a.item_contact_value_1, a.item_contact_code_2, a.item_contact_value_2, a.ship_from_name_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_county_ext, a.ship_from_postal_cd_ext, a.ship_from_province_ext, a.ship_from_state_ext, a.ship_from_country_ext, a.ship_from_org_id, a.ship_to_name_ext, 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_city_ext, a.ship_to_county_ext, a.ship_to_postal_cd_ext, a.ship_to_province_ext, a.ship_to_state_ext, a.ship_to_country_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.bill_to_name_ext, 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_city_ext, a.bill_to_county_ext, a.bill_to_postal_cd_ext, a.bill_to_province_ext, a.bill_to_state_ext, a.bill_to_country_ext, a.bill_to_address_id, a.intrmd_st_name_ext, 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_county_ext, a.intrmd_st_postal_cd_ext, a.intrmd_st_province_ext, a.intrmd_st_state_ext, a.intrmd_st_country_ext, a.ITEM_NOTE_TEXT, a.industry_attribute1, a.INTRMD_SHIP_TO_ID , a.customer_dock_code, a.carrier_qualifier_ext, a.carrier_id_code_ext, a.transit_time_qual_ext, a.transit_time_ext, a.transport_loc_qual_ext, a.transport_method_ext, a.transport_location_ext, a.weight_qualifier_ext, a.weight_ext, a.weight_uom_ext, a.routing_desc_ext, a.routing_seq_code_ext, a.equipment_code_ext, a.equipment_number_ext, a.cust_assembly_ext, a.cust_manufacturer_ext, a.cust_model_serial_number, a.cust_order_num_ext, a.cust_process_num_ext, a.cust_production_line, a.cust_production_seq_num, a.cust_set_num_ext, a.customer_job, a.lading_quantity_ext, a.prime_contrctr_part_ext, a.ship_to_customer_id, a.ORG_ID FROM rlm_interface_lines_all a,rlm_schedule_interface_hdr_v b WHERE a.header_id = b.header_id and b.origin_table ='INTERFACE' and a.process_status <> 5 and a.ORG_ID = b.ORG_ID UNION SELECT distinct a.schedule_item_num, a.item_description_ext, a.header_id, 'SCHEDULE' origin_table, a.cust_ship_from_org_ext, a.cust_ship_to_ext, a.customer_item_ext, a.customer_item_id, a.inventory_item_id, a.supplier_item_ext, a.cust_assigned_id_ext, a.country_of_origin_ext, a.commodity_ext, a.cust_model_number_ext, a.item_eng_cng_lvl_ext, a.customer_item_revision, a.item_release_status_ext, a.item_measurements_ext, a.ship_del_pattern_ext, a.ship_del_rule_name, a.ship_del_time_code_ext, a.cust_po_number, a.cust_po_date, a.cust_po_release_num, a.cust_po_line_num, a.cust_contract_num_ext, a.import_license_ext, a.import_license_date_ext, a.letter_credit_ext, a.letter_credit_expdt_ext, a.cust_item_price_ext, a.cust_item_price_uom_ext, a.pack_units_per_pack_ext, a.pack_size_ext, a.pack_uom_code_ext, a.hazard_code_qual_ext, a.hazard_code_ext, a.hazard_description_ext, a.handling_code_ext, a.return_container_ext, a.ship_label_info_line_1, 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_label_info_line_10, a.cust_bill_to_ext, a.cust_intrmd_ship_to_ext, a.other_name_code_1, a.other_name_value_1, a.other_name_code_2, a.other_name_value_2, a.item_ref_code_1, a.item_ref_value_1, a.item_ref_code_2, a.item_ref_value_2, a.item_ref_code_3, a.item_ref_value_3, a.item_contact_code_1, a.item_contact_value_1, a.item_contact_code_2, a.item_contact_value_2, a.ship_from_name_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_county_ext, a.ship_from_postal_cd_ext, a.ship_from_province_ext, a.ship_from_state_ext, a.ship_from_country_ext, a.ship_from_org_id, a.ship_to_name_ext, 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_city_ext, a.ship_to_county_ext, a.ship_to_postal_cd_ext, a.ship_to_province_ext, a.ship_to_state_ext, a.ship_to_country_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.bill_to_name_ext, 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_city_ext, a.bill_to_county_ext, a.bill_to_postal_cd_ext, a.bill_to_province_ext, a.bill_to_state_ext, a.bill_to_country_ext, a.bill_to_address_id, a.intrmd_st_name_ext, 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_county_ext, a.intrmd_st_postal_cd_ext, a.intrmd_st_province_ext, a.intrmd_st_state_ext, a.intrmd_st_country_ext, a.ITEM_NOTE_TEXT, a.industry_attribute1, a.INTRMD_SHIP_TO_ID, a.customer_dock_code, a.carrier_qualifier_ext, a.carrier_id_code_ext, a.transit_time_qual_ext, a.transit_time_ext, a.transport_loc_qual_ext, a.transport_method_ext, a.transport_location_ext, a.weight_qualifier_ext, a.weight_ext, a.weight_uom_ext, a.routing_desc_ext, a.routing_seq_code_ext, a.equipment_code_ext, a.equipment_number_ext, a.cust_assembly_ext, a.cust_manufacturer_ext, a.cust_model_serial_number, a.cust_order_num_ext, a.cust_process_num_ext, a.cust_production_line, a.cust_production_seq_num, a.cust_set_num_ext, a.customer_job, a.lading_quantity_ext, a.prime_contrctr_part_ext, a.ship_to_customer_id, a.ORG_ID FROM rlm_schedule_lines_all a,rlm_schedule_interface_hdr_v b where a.header_id = b.header_id and b.origin_table ='SCHEDULE' and a.ORG_ID = b.ORG_ID UNION SELECT distinct a.schedule_item_num, a.item_description_ext, b.header_id, 'INTERFACE' origin_table, a.cust_ship_from_org_ext, a.cust_ship_to_ext, a.customer_item_ext, a.customer_item_id, a.inventory_item_id, a.supplier_item_ext, a.cust_assigned_id_ext, a.country_of_origin_ext, a.commodity_ext, a.cust_model_number_ext, a.item_eng_cng_lvl_ext, a.customer_item_revision, a.item_release_status_ext, a.item_measurements_ext, a.ship_del_pattern_ext, a.ship_del_rule_name, a.ship_del_time_code_ext, a.cust_po_number, a.cust_po_date, a.cust_po_release_num, a.cust_po_line_num, a.cust_contract_num_ext, a.import_license_ext, a.import_license_date_ext, a.letter_credit_ext, a.letter_credit_expdt_ext, a.cust_item_price_ext, a.cust_item_price_uom_ext, a.pack_units_per_pack_ext, a.pack_size_ext, a.pack_uom_code_ext, a.hazard_code_qual_ext, a.hazard_code_ext, a.hazard_description_ext, a.handling_code_ext, a.return_container_ext, a.ship_label_info_line_1, 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_label_info_line_10, a.cust_bill_to_ext, a.cust_intrmd_ship_to_ext, a.other_name_code_1, a.other_name_value_1, a.other_name_code_2, a.other_name_value_2, a.item_ref_code_1, a.item_ref_value_1, a.item_ref_code_2, a.item_ref_value_2, a.item_ref_code_3, a.item_ref_value_3, a.item_contact_code_1, a.item_contact_value_1, a.item_contact_code_2, a.item_contact_value_2, a.ship_from_name_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_county_ext, a.ship_from_postal_cd_ext, a.ship_from_province_ext, a.ship_from_state_ext, a.ship_from_country_ext, a.ship_from_org_id, a.ship_to_name_ext, 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_city_ext, a.ship_to_county_ext, a.ship_to_postal_cd_ext, a.ship_to_province_ext, a.ship_to_state_ext, a.ship_to_country_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.bill_to_name_ext, 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_city_ext, a.bill_to_county_ext, a.bill_to_postal_cd_ext, a.bill_to_province_ext, a.bill_to_state_ext, a.bill_to_country_ext, a.bill_to_address_id, a.intrmd_st_name_ext, 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_county_ext, a.intrmd_st_postal_cd_ext, a.intrmd_st_province_ext, a.intrmd_st_state_ext, a.intrmd_st_country_ext, a.ITEM_NOTE_TEXT, a.industry_attribute1, a.INTRMD_SHIP_TO_ID, a.customer_dock_code, a.carrier_qualifier_ext, a.carrier_id_code_ext, a.transit_time_qual_ext, a.transit_time_ext, a.transport_loc_qual_ext, a.transport_method_ext, a.transport_location_ext, a.weight_qualifier_ext, a.weight_ext, a.weight_uom_ext, a.routing_desc_ext, a.routing_seq_code_ext, a.equipment_code_ext, a.equipment_number_ext, a.cust_assembly_ext, a.cust_manufacturer_ext, a.cust_model_serial_number, a.cust_order_num_ext, a.cust_process_num_ext, a.cust_production_line, a.cust_production_seq_num, a.cust_set_num_ext, a.customer_job, a.lading_quantity_ext, a.prime_contrctr_part_ext, a.ship_to_customer_id, a.ORG_ID FROM rlm_schedule_lines_all a,rlm_schedule_interface_hdr_v b where a.header_id = b.schedule_header_id and b.origin_table ='INTERFACE' and a.process_status = 5 and a.ORG_ID = b.ORG_ID

View Text - HTML Formatted

SELECT DISTINCT A.SCHEDULE_ITEM_NUM
, A.ITEM_DESCRIPTION_EXT
, A.HEADER_ID
, 'INTERFACE' ORIGIN_TABLE
, A.CUST_SHIP_FROM_ORG_EXT
, A.CUST_SHIP_TO_EXT
, A.CUSTOMER_ITEM_EXT
, A.CUSTOMER_ITEM_ID
, A.INVENTORY_ITEM_ID
, A.SUPPLIER_ITEM_EXT
, A.CUST_ASSIGNED_ID_EXT
, A.COUNTRY_OF_ORIGIN_EXT
, A.COMMODITY_EXT
, A.CUST_MODEL_NUMBER_EXT
, A.ITEM_ENG_CNG_LVL_EXT
, A.CUSTOMER_ITEM_REVISION
, A.ITEM_RELEASE_STATUS_EXT
, A.ITEM_MEASUREMENTS_EXT
, A.SHIP_DEL_PATTERN_EXT
, A.SHIP_DEL_RULE_NAME
, A.SHIP_DEL_TIME_CODE_EXT
, A.CUST_PO_NUMBER
, A.CUST_PO_DATE
, A.CUST_PO_RELEASE_NUM
, A.CUST_PO_LINE_NUM
, A.CUST_CONTRACT_NUM_EXT
, A.IMPORT_LICENSE_EXT
, A.IMPORT_LICENSE_DATE_EXT
, A.LETTER_CREDIT_EXT
, A.LETTER_CREDIT_EXPDT_EXT
, A.CUST_ITEM_PRICE_EXT
, A.CUST_ITEM_PRICE_UOM_EXT
, A.PACK_UNITS_PER_PACK_EXT
, A.PACK_SIZE_EXT
, A.PACK_UOM_CODE_EXT
, A.HAZARD_CODE_QUAL_EXT
, A.HAZARD_CODE_EXT
, A.HAZARD_DESCRIPTION_EXT
, A.HANDLING_CODE_EXT
, A.RETURN_CONTAINER_EXT
, A.SHIP_LABEL_INFO_LINE_1
, 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_LABEL_INFO_LINE_10
, A.CUST_BILL_TO_EXT
, A.CUST_INTRMD_SHIP_TO_EXT
, A.OTHER_NAME_CODE_1
, A.OTHER_NAME_VALUE_1
, A.OTHER_NAME_CODE_2
, A.OTHER_NAME_VALUE_2
, A.ITEM_REF_CODE_1
, A.ITEM_REF_VALUE_1
, A.ITEM_REF_CODE_2
, A.ITEM_REF_VALUE_2
, A.ITEM_REF_CODE_3
, A.ITEM_REF_VALUE_3
, A.ITEM_CONTACT_CODE_1
, A.ITEM_CONTACT_VALUE_1
, A.ITEM_CONTACT_CODE_2
, A.ITEM_CONTACT_VALUE_2
, A.SHIP_FROM_NAME_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_COUNTY_EXT
, A.SHIP_FROM_POSTAL_CD_EXT
, A.SHIP_FROM_PROVINCE_EXT
, A.SHIP_FROM_STATE_EXT
, A.SHIP_FROM_COUNTRY_EXT
, A.SHIP_FROM_ORG_ID
, A.SHIP_TO_NAME_EXT
, 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_CITY_EXT
, A.SHIP_TO_COUNTY_EXT
, A.SHIP_TO_POSTAL_CD_EXT
, A.SHIP_TO_PROVINCE_EXT
, A.SHIP_TO_STATE_EXT
, A.SHIP_TO_COUNTRY_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.BILL_TO_NAME_EXT
, 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_CITY_EXT
, A.BILL_TO_COUNTY_EXT
, A.BILL_TO_POSTAL_CD_EXT
, A.BILL_TO_PROVINCE_EXT
, A.BILL_TO_STATE_EXT
, A.BILL_TO_COUNTRY_EXT
, A.BILL_TO_ADDRESS_ID
, A.INTRMD_ST_NAME_EXT
, 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_COUNTY_EXT
, A.INTRMD_ST_POSTAL_CD_EXT
, A.INTRMD_ST_PROVINCE_EXT
, A.INTRMD_ST_STATE_EXT
, A.INTRMD_ST_COUNTRY_EXT
, A.ITEM_NOTE_TEXT
, A.INDUSTRY_ATTRIBUTE1
, A.INTRMD_SHIP_TO_ID
, A.CUSTOMER_DOCK_CODE
, A.CARRIER_QUALIFIER_EXT
, A.CARRIER_ID_CODE_EXT
, A.TRANSIT_TIME_QUAL_EXT
, A.TRANSIT_TIME_EXT
, A.TRANSPORT_LOC_QUAL_EXT
, A.TRANSPORT_METHOD_EXT
, A.TRANSPORT_LOCATION_EXT
, A.WEIGHT_QUALIFIER_EXT
, A.WEIGHT_EXT
, A.WEIGHT_UOM_EXT
, A.ROUTING_DESC_EXT
, A.ROUTING_SEQ_CODE_EXT
, A.EQUIPMENT_CODE_EXT
, A.EQUIPMENT_NUMBER_EXT
, A.CUST_ASSEMBLY_EXT
, A.CUST_MANUFACTURER_EXT
, A.CUST_MODEL_SERIAL_NUMBER
, A.CUST_ORDER_NUM_EXT
, A.CUST_PROCESS_NUM_EXT
, A.CUST_PRODUCTION_LINE
, A.CUST_PRODUCTION_SEQ_NUM
, A.CUST_SET_NUM_EXT
, A.CUSTOMER_JOB
, A.LADING_QUANTITY_EXT
, A.PRIME_CONTRCTR_PART_EXT
, A.SHIP_TO_CUSTOMER_ID
, A.ORG_ID
FROM RLM_INTERFACE_LINES_ALL A
, RLM_SCHEDULE_INTERFACE_HDR_V B
WHERE A.HEADER_ID = B.HEADER_ID
AND B.ORIGIN_TABLE ='INTERFACE'
AND A.PROCESS_STATUS <> 5
AND A.ORG_ID = B.ORG_ID UNION SELECT DISTINCT A.SCHEDULE_ITEM_NUM
, A.ITEM_DESCRIPTION_EXT
, A.HEADER_ID
, 'SCHEDULE' ORIGIN_TABLE
, A.CUST_SHIP_FROM_ORG_EXT
, A.CUST_SHIP_TO_EXT
, A.CUSTOMER_ITEM_EXT
, A.CUSTOMER_ITEM_ID
, A.INVENTORY_ITEM_ID
, A.SUPPLIER_ITEM_EXT
, A.CUST_ASSIGNED_ID_EXT
, A.COUNTRY_OF_ORIGIN_EXT
, A.COMMODITY_EXT
, A.CUST_MODEL_NUMBER_EXT
, A.ITEM_ENG_CNG_LVL_EXT
, A.CUSTOMER_ITEM_REVISION
, A.ITEM_RELEASE_STATUS_EXT
, A.ITEM_MEASUREMENTS_EXT
, A.SHIP_DEL_PATTERN_EXT
, A.SHIP_DEL_RULE_NAME
, A.SHIP_DEL_TIME_CODE_EXT
, A.CUST_PO_NUMBER
, A.CUST_PO_DATE
, A.CUST_PO_RELEASE_NUM
, A.CUST_PO_LINE_NUM
, A.CUST_CONTRACT_NUM_EXT
, A.IMPORT_LICENSE_EXT
, A.IMPORT_LICENSE_DATE_EXT
, A.LETTER_CREDIT_EXT
, A.LETTER_CREDIT_EXPDT_EXT
, A.CUST_ITEM_PRICE_EXT
, A.CUST_ITEM_PRICE_UOM_EXT
, A.PACK_UNITS_PER_PACK_EXT
, A.PACK_SIZE_EXT
, A.PACK_UOM_CODE_EXT
, A.HAZARD_CODE_QUAL_EXT
, A.HAZARD_CODE_EXT
, A.HAZARD_DESCRIPTION_EXT
, A.HANDLING_CODE_EXT
, A.RETURN_CONTAINER_EXT
, A.SHIP_LABEL_INFO_LINE_1
, 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_LABEL_INFO_LINE_10
, A.CUST_BILL_TO_EXT
, A.CUST_INTRMD_SHIP_TO_EXT
, A.OTHER_NAME_CODE_1
, A.OTHER_NAME_VALUE_1
, A.OTHER_NAME_CODE_2
, A.OTHER_NAME_VALUE_2
, A.ITEM_REF_CODE_1
, A.ITEM_REF_VALUE_1
, A.ITEM_REF_CODE_2
, A.ITEM_REF_VALUE_2
, A.ITEM_REF_CODE_3
, A.ITEM_REF_VALUE_3
, A.ITEM_CONTACT_CODE_1
, A.ITEM_CONTACT_VALUE_1
, A.ITEM_CONTACT_CODE_2
, A.ITEM_CONTACT_VALUE_2
, A.SHIP_FROM_NAME_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_COUNTY_EXT
, A.SHIP_FROM_POSTAL_CD_EXT
, A.SHIP_FROM_PROVINCE_EXT
, A.SHIP_FROM_STATE_EXT
, A.SHIP_FROM_COUNTRY_EXT
, A.SHIP_FROM_ORG_ID
, A.SHIP_TO_NAME_EXT
, 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_CITY_EXT
, A.SHIP_TO_COUNTY_EXT
, A.SHIP_TO_POSTAL_CD_EXT
, A.SHIP_TO_PROVINCE_EXT
, A.SHIP_TO_STATE_EXT
, A.SHIP_TO_COUNTRY_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.BILL_TO_NAME_EXT
, 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_CITY_EXT
, A.BILL_TO_COUNTY_EXT
, A.BILL_TO_POSTAL_CD_EXT
, A.BILL_TO_PROVINCE_EXT
, A.BILL_TO_STATE_EXT
, A.BILL_TO_COUNTRY_EXT
, A.BILL_TO_ADDRESS_ID
, A.INTRMD_ST_NAME_EXT
, 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_COUNTY_EXT
, A.INTRMD_ST_POSTAL_CD_EXT
, A.INTRMD_ST_PROVINCE_EXT
, A.INTRMD_ST_STATE_EXT
, A.INTRMD_ST_COUNTRY_EXT
, A.ITEM_NOTE_TEXT
, A.INDUSTRY_ATTRIBUTE1
, A.INTRMD_SHIP_TO_ID
, A.CUSTOMER_DOCK_CODE
, A.CARRIER_QUALIFIER_EXT
, A.CARRIER_ID_CODE_EXT
, A.TRANSIT_TIME_QUAL_EXT
, A.TRANSIT_TIME_EXT
, A.TRANSPORT_LOC_QUAL_EXT
, A.TRANSPORT_METHOD_EXT
, A.TRANSPORT_LOCATION_EXT
, A.WEIGHT_QUALIFIER_EXT
, A.WEIGHT_EXT
, A.WEIGHT_UOM_EXT
, A.ROUTING_DESC_EXT
, A.ROUTING_SEQ_CODE_EXT
, A.EQUIPMENT_CODE_EXT
, A.EQUIPMENT_NUMBER_EXT
, A.CUST_ASSEMBLY_EXT
, A.CUST_MANUFACTURER_EXT
, A.CUST_MODEL_SERIAL_NUMBER
, A.CUST_ORDER_NUM_EXT
, A.CUST_PROCESS_NUM_EXT
, A.CUST_PRODUCTION_LINE
, A.CUST_PRODUCTION_SEQ_NUM
, A.CUST_SET_NUM_EXT
, A.CUSTOMER_JOB
, A.LADING_QUANTITY_EXT
, A.PRIME_CONTRCTR_PART_EXT
, A.SHIP_TO_CUSTOMER_ID
, A.ORG_ID
FROM RLM_SCHEDULE_LINES_ALL A
, RLM_SCHEDULE_INTERFACE_HDR_V B
WHERE A.HEADER_ID = B.HEADER_ID
AND B.ORIGIN_TABLE ='SCHEDULE'
AND A.ORG_ID = B.ORG_ID UNION SELECT DISTINCT A.SCHEDULE_ITEM_NUM
, A.ITEM_DESCRIPTION_EXT
, B.HEADER_ID
, 'INTERFACE' ORIGIN_TABLE
, A.CUST_SHIP_FROM_ORG_EXT
, A.CUST_SHIP_TO_EXT
, A.CUSTOMER_ITEM_EXT
, A.CUSTOMER_ITEM_ID
, A.INVENTORY_ITEM_ID
, A.SUPPLIER_ITEM_EXT
, A.CUST_ASSIGNED_ID_EXT
, A.COUNTRY_OF_ORIGIN_EXT
, A.COMMODITY_EXT
, A.CUST_MODEL_NUMBER_EXT
, A.ITEM_ENG_CNG_LVL_EXT
, A.CUSTOMER_ITEM_REVISION
, A.ITEM_RELEASE_STATUS_EXT
, A.ITEM_MEASUREMENTS_EXT
, A.SHIP_DEL_PATTERN_EXT
, A.SHIP_DEL_RULE_NAME
, A.SHIP_DEL_TIME_CODE_EXT
, A.CUST_PO_NUMBER
, A.CUST_PO_DATE
, A.CUST_PO_RELEASE_NUM
, A.CUST_PO_LINE_NUM
, A.CUST_CONTRACT_NUM_EXT
, A.IMPORT_LICENSE_EXT
, A.IMPORT_LICENSE_DATE_EXT
, A.LETTER_CREDIT_EXT
, A.LETTER_CREDIT_EXPDT_EXT
, A.CUST_ITEM_PRICE_EXT
, A.CUST_ITEM_PRICE_UOM_EXT
, A.PACK_UNITS_PER_PACK_EXT
, A.PACK_SIZE_EXT
, A.PACK_UOM_CODE_EXT
, A.HAZARD_CODE_QUAL_EXT
, A.HAZARD_CODE_EXT
, A.HAZARD_DESCRIPTION_EXT
, A.HANDLING_CODE_EXT
, A.RETURN_CONTAINER_EXT
, A.SHIP_LABEL_INFO_LINE_1
, 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_LABEL_INFO_LINE_10
, A.CUST_BILL_TO_EXT
, A.CUST_INTRMD_SHIP_TO_EXT
, A.OTHER_NAME_CODE_1
, A.OTHER_NAME_VALUE_1
, A.OTHER_NAME_CODE_2
, A.OTHER_NAME_VALUE_2
, A.ITEM_REF_CODE_1
, A.ITEM_REF_VALUE_1
, A.ITEM_REF_CODE_2
, A.ITEM_REF_VALUE_2
, A.ITEM_REF_CODE_3
, A.ITEM_REF_VALUE_3
, A.ITEM_CONTACT_CODE_1
, A.ITEM_CONTACT_VALUE_1
, A.ITEM_CONTACT_CODE_2
, A.ITEM_CONTACT_VALUE_2
, A.SHIP_FROM_NAME_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_COUNTY_EXT
, A.SHIP_FROM_POSTAL_CD_EXT
, A.SHIP_FROM_PROVINCE_EXT
, A.SHIP_FROM_STATE_EXT
, A.SHIP_FROM_COUNTRY_EXT
, A.SHIP_FROM_ORG_ID
, A.SHIP_TO_NAME_EXT
, 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_CITY_EXT
, A.SHIP_TO_COUNTY_EXT
, A.SHIP_TO_POSTAL_CD_EXT
, A.SHIP_TO_PROVINCE_EXT
, A.SHIP_TO_STATE_EXT
, A.SHIP_TO_COUNTRY_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.BILL_TO_NAME_EXT
, 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_CITY_EXT
, A.BILL_TO_COUNTY_EXT
, A.BILL_TO_POSTAL_CD_EXT
, A.BILL_TO_PROVINCE_EXT
, A.BILL_TO_STATE_EXT
, A.BILL_TO_COUNTRY_EXT
, A.BILL_TO_ADDRESS_ID
, A.INTRMD_ST_NAME_EXT
, 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_COUNTY_EXT
, A.INTRMD_ST_POSTAL_CD_EXT
, A.INTRMD_ST_PROVINCE_EXT
, A.INTRMD_ST_STATE_EXT
, A.INTRMD_ST_COUNTRY_EXT
, A.ITEM_NOTE_TEXT
, A.INDUSTRY_ATTRIBUTE1
, A.INTRMD_SHIP_TO_ID
, A.CUSTOMER_DOCK_CODE
, A.CARRIER_QUALIFIER_EXT
, A.CARRIER_ID_CODE_EXT
, A.TRANSIT_TIME_QUAL_EXT
, A.TRANSIT_TIME_EXT
, A.TRANSPORT_LOC_QUAL_EXT
, A.TRANSPORT_METHOD_EXT
, A.TRANSPORT_LOCATION_EXT
, A.WEIGHT_QUALIFIER_EXT
, A.WEIGHT_EXT
, A.WEIGHT_UOM_EXT
, A.ROUTING_DESC_EXT
, A.ROUTING_SEQ_CODE_EXT
, A.EQUIPMENT_CODE_EXT
, A.EQUIPMENT_NUMBER_EXT
, A.CUST_ASSEMBLY_EXT
, A.CUST_MANUFACTURER_EXT
, A.CUST_MODEL_SERIAL_NUMBER
, A.CUST_ORDER_NUM_EXT
, A.CUST_PROCESS_NUM_EXT
, A.CUST_PRODUCTION_LINE
, A.CUST_PRODUCTION_SEQ_NUM
, A.CUST_SET_NUM_EXT
, A.CUSTOMER_JOB
, A.LADING_QUANTITY_EXT
, A.PRIME_CONTRCTR_PART_EXT
, A.SHIP_TO_CUSTOMER_ID
, A.ORG_ID
FROM RLM_SCHEDULE_LINES_ALL A
, RLM_SCHEDULE_INTERFACE_HDR_V B
WHERE A.HEADER_ID = B.SCHEDULE_HEADER_ID
AND B.ORIGIN_TABLE ='INTERFACE'
AND A.PROCESS_STATUS = 5
AND A.ORG_ID = B.ORG_ID