APPS.WSH_PURGE dependencies on FTE_SHIPMENT_STATUS_DETAILS

Line 1326: FTE_SHIPMENT_STATUS_DETAILS, FTE_SHIPMENT_STATUS_EXCEPTIONS,

1322: WSH_EXCEPTIONS, WSH_TRANSACTIONS_HISTORY, WSH_DOCUMENT_INSTANCES,
1323: WSH_FREIGHT_COSTS
1324:
1325: If FTE is installed,
1326: FTE_SHIPMENT_STATUS_DETAILS, FTE_SHIPMENT_STATUS_EXCEPTIONS,
1327: FTE_MESSAGE_PARTNER, FTE_MESSAGE_CONTACT, FTE_MESSAGE_LOCATION,
1328: FTE_DELIVERY_PROOF, FTE_SHIPMENT_STATUS_HEADERS
1329:
1330: If ITM Screening is done,

Line 1410: FROM fte_shipment_status_details

1406:
1407: IF (wsh_util_core.fte_is_installed='Y') THEN
1408:
1409: DELETE
1410: FROM fte_shipment_status_details
1411: WHERE transaction_id IN (SELECT transaction_id
1412: FROM fte_shipment_status_headers
1413: WHERE delivery_id = l_delivery_id);
1414:

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

1413: WHERE delivery_id = l_delivery_id);
1414:
1415: IF SQL%FOUND THEN
1416: IF l_debug_on THEN
1417: WSH_DEBUG_SV.logmsg(l_module_name,'Deleted from fte_shipment_status_details: DELIVERY_ID=' || l_delivery_id, WSH_DEBUG_SV.C_PROC_LEVEL);
1418: END IF;
1419: END IF;
1420:
1421: DELETE