DBA Data[Home] [Help]

APPS.WSH_PURGE dependencies on FTE_INVOICE_HISTORY

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 1641: FROM fte_invoice_history

1637: END IF;
1638: END IF;
1639:
1640: DELETE
1641: FROM fte_invoice_history
1642: WHERE bol IN (SELECT sequence_number
1643: FROM wsh_document_instances
1644: WHERE entity_id = l_leg_id
1645: AND entity_name = 'WSH_DELIVERY_LEGS') ;

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

1645: AND entity_name = 'WSH_DELIVERY_LEGS') ;
1646:
1647: IF SQL%FOUND THEN
1648: IF l_debug_on THEN
1649: WSH_DEBUG_SV.logmsg(l_module_name,'Deleted from fte_invoice_history: LEG_ID=' || l_leg_id, WSH_DEBUG_SV.C_PROC_LEVEL);
1650: END IF;
1651: END IF;
1652:
1653: DELETE