APPS.WSH_PURGE dependencies on FTE_INVOICE_LINES

Line 1569: FTE_INVOICE_LINES, FTE_INVOICE_HISTORY, FTE_INVOICE_HEADERS,

1565: WSH_FREIGHT_COSTS, WSH_DOCUMENT_INSTANCES, WSH_DELIVERY_LEG_ACTIVITIES,
1566: WSH_DELIVERY_LEG_DETAILS, WSH_DELIVERY_LEGS
1567:
1568: If FTE is installed,
1569: FTE_INVOICE_LINES, FTE_INVOICE_HISTORY, FTE_INVOICE_HEADERS,
1570: FTE_FAILURE_REASONS
1571: -----------------------------------------------------------------------------*/
1572:
1573: PROCEDURE Purge_Delivery_Legs( p_tbl_del_leg_purge_set Del_Leg_ID_Tbl_Type,

Line 1613: FROM fte_invoice_lines

1609:
1610: IF (wsh_util_core.fte_is_installed='Y') THEN
1611:
1612: DELETE
1613: FROM fte_invoice_lines
1614: WHERE invoice_header_id IN ( SELECT fih.invoice_header_id
1615: FROM fte_invoice_headers fih,
1616: wsh_document_instances wdi
1617: WHERE wdi.entity_id = l_leg_id

Line 1623: WSH_DEBUG_SV.logmsg(l_module_name,'Deleted from fte_invoice_lines: LEG_ID=' || l_leg_id, WSH_DEBUG_SV.C_PROC_LEVEL);

1619: AND wdi.sequence_number = fih.bol
1620: ) ;
1621: IF SQL%FOUND THEN
1622: IF l_debug_on THEN
1623: WSH_DEBUG_SV.logmsg(l_module_name,'Deleted from fte_invoice_lines: LEG_ID=' || l_leg_id, WSH_DEBUG_SV.C_PROC_LEVEL);
1624: END IF;
1625: END IF;
1626:
1627: DELETE