APPS.WSH_PURGE dependencies on FTE_INVOICE_LINES

Line 1694: FTE_INVOICE_LINES, FTE_INVOICE_HISTORY, FTE_INVOICE_HEADERS,

1690: WSH_FREIGHT_COSTS, WSH_DOCUMENT_INSTANCES, WSH_DELIVERY_LEG_ACTIVITIES,
1691: WSH_DELIVERY_LEG_DETAILS, WSH_DELIVERY_LEGS
1692:
1693: If FTE is installed,
1694: FTE_INVOICE_LINES, FTE_INVOICE_HISTORY, FTE_INVOICE_HEADERS,
1695: FTE_FAILURE_REASONS
1696: -----------------------------------------------------------------------------*/
1697:
1698: PROCEDURE Purge_Delivery_Legs( p_tbl_del_leg_purge_set Del_Leg_ID_Tbl_Type,

Line 1738: FROM fte_invoice_lines

1734:
1735: IF (wsh_util_core.fte_is_installed='Y') THEN
1736:
1737: DELETE
1738: FROM fte_invoice_lines
1739: WHERE invoice_header_id IN ( SELECT fih.invoice_header_id
1740: FROM fte_invoice_headers fih,
1741: wsh_document_instances wdi
1742: WHERE wdi.entity_id = l_leg_id

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

1744: AND wdi.sequence_number = fih.bol
1745: ) ;
1746: IF SQL%FOUND THEN
1747: IF l_debug_on THEN
1748: WSH_DEBUG_SV.logmsg(l_module_name,'Deleted from fte_invoice_lines: LEG_ID=' || l_leg_id, WSH_DEBUG_SV.C_PROC_LEVEL);
1749: END IF;
1750: END IF;
1751:
1752: DELETE