APPS.WSH_PURGE dependencies on FTE_SHIPMENT_STATUS_DETAILS

Line 1201: FTE_SHIPMENT_STATUS_DETAILS, FTE_SHIPMENT_STATUS_EXCEPTIONS,

1197: WSH_EXCEPTIONS, WSH_TRANSACTIONS_HISTORY, WSH_DOCUMENT_INSTANCES,
1198: WSH_FREIGHT_COSTS
1199:
1200: If FTE is installed,
1201: FTE_SHIPMENT_STATUS_DETAILS, FTE_SHIPMENT_STATUS_EXCEPTIONS,
1202: FTE_MESSAGE_PARTNER, FTE_MESSAGE_CONTACT, FTE_MESSAGE_LOCATION,
1203: FTE_DELIVERY_PROOF, FTE_SHIPMENT_STATUS_HEADERS
1204:
1205: If ITM Screening is done,

Line 1285: FROM fte_shipment_status_details

1281:
1282: IF (wsh_util_core.fte_is_installed='Y') THEN
1283:
1284: DELETE
1285: FROM fte_shipment_status_details
1286: WHERE transaction_id IN (SELECT transaction_id
1287: FROM fte_shipment_status_headers
1288: WHERE delivery_id = l_delivery_id);
1289:

Line 1292: WSH_DEBUG_SV.logmsg(l_module_name,'Deleted from fte_shipment_status_details: DELIVERY_ID=' || l_delivery_id, WSH_DEBUG_SV.C_PROC_LEVEL);

1288: WHERE delivery_id = l_delivery_id);
1289:
1290: IF SQL%FOUND THEN
1291: IF l_debug_on THEN
1292: WSH_DEBUG_SV.logmsg(l_module_name,'Deleted from fte_shipment_status_details: DELIVERY_ID=' || l_delivery_id, WSH_DEBUG_SV.C_PROC_LEVEL);
1293: END IF;
1294: END IF;
1295:
1296: DELETE