APPS.WSH_PROCESS_INTERFACED_PKG dependencies on WSH_DEL_ASSGN_INTERFACE

Line 1052: FROM wsh_del_details_interface wddi, wsh_del_assgn_interface wdai

1048: wddi.deliver_to_location_code, wddi.customer_number, wddi.subinventory,
1049: wddi.revision, wddi.lot_number, wddi.locator_id,
1050: wddi.intmed_ship_to_location_code, wddi.delivery_detail_interface_id,
1051: wddi.customer_name, wddi.container_flag
1052: FROM wsh_del_details_interface wddi, wsh_del_assgn_interface wdai
1053: WHERE wdai.delivery_interface_id = p_delivery_interface_id
1054: AND wddi.delivery_detail_interface_id =
1055: wdai.delivery_detail_interface_id
1056: AND wddi.INTERFACE_ACTION_CODE = '94X_INBOUND'

Line 1221: FROM wsh_del_details_interface wddi, wsh_del_assgn_interface wdai

1217:
1218: BEGIN
1219: SELECT DISTINCT customer_name
1220: INTO l_detail_customer_name
1221: FROM wsh_del_details_interface wddi, wsh_del_assgn_interface wdai
1222: WHERE wddi.delivery_detail_interface_id = wdai.delivery_detail_interface_id
1223: AND wddi.customer_name IS NOT NULL
1224: AND wdai.delivery_interface_id = p_delivery_interface_id
1225: AND wddi.INTERFACE_ACTION_CODE = '94X_INBOUND'

Line 1727: FROM wsh_del_assgn_interface

1723:
1724: CURSOR detail_interface_ids
1725: IS
1726: SELECT delivery_detail_interface_id, del_assgn_interface_id
1727: FROM wsh_del_assgn_interface
1728: WHERE delivery_interface_id = p_delivery_interface_id
1729: AND INTERFACE_ACTION_CODE = '94X_INBOUND';
1730:
1731: CURSOR ids

Line 1795: DELETE wsh_del_assgn_interface

1791: DELETE wsh_del_details_interface
1792: WHERE delivery_detail_interface_id = detail_interface_ids_rec.delivery_detail_interface_id
1793: AND INTERFACE_ACTION_CODE = '94X_INBOUND';
1794:
1795: DELETE wsh_del_assgn_interface
1796: WHERE delivery_detail_interface_id = detail_interface_ids_rec.delivery_detail_interface_id
1797: AND INTERFACE_ACTION_CODE = '94X_INBOUND';
1798: END LOOP; -- End of FOR Details_Interface_IDs_Rec ...
1799: