DBA Data[Home] [Help]

APPS.AHL_PRD_WORKORDER_PVT dependencies on WIP_COST_TXN_INTERFACE

Line 4691: FROM WIP_COST_TXN_INTERFACE wict

4687:
4688: -- Fix for Bug 9439418
4689: CURSOR chk_pending_txns (p_wip_entity_id NUMBER) IS
4690: SELECT 'x'
4691: FROM WIP_COST_TXN_INTERFACE wict
4692: WHERE wict.wip_entity_id = p_wip_entity_id
4693: AND process_status IN (1,2,3);
4694:
4695: -- added for ER 9368251

Line 11164: from ahl_workorders awos, wip_COST_TXN_INTERFACE wict

11160: where awo.wip_entity_id = wipt.wip_entity_id
11161: and awo.visit_id = c_visit_id
11162: UNION ALL
11163: select 'x'
11164: from ahl_workorders awos, wip_COST_TXN_INTERFACE wict
11165: where awos.wip_entity_id = wict.wip_entity_id
11166: and awos.visit_id = c_visit_id
11167: and process_status IN (1,3)
11168: );