eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.WIP_VALIDATEMLHEADER_PVT dependencies on WIP_RESERVATIONS_V

Line 2181: from wip_reservations_v wr

2177: from wip_discrete_jobs wdj
2178: where wdj.organization_id = wjsi.organization_id
2179: and wdj.wip_entity_id = wjsi.wip_entity_id)
2180: or (0 < (select count(*)
2181: from wip_reservations_v wr
2182: where wr.wip_entity_id = wjsi.wip_entity_id
2183: and wr.organization_id = wjsi.organization_id) and
2184: wjsi.start_quantity < (select sum(wr.primary_quantity)
2185: from wip_reservations_v wr

Line 2185: from wip_reservations_v wr

2181: from wip_reservations_v wr
2182: where wr.wip_entity_id = wjsi.wip_entity_id
2183: and wr.organization_id = wjsi.organization_id) and
2184: wjsi.start_quantity < (select sum(wr.primary_quantity)
2185: from wip_reservations_v wr
2186: where wr.organization_id = wjsi.organization_id
2187: and wr.wip_entity_id = wjsi.wip_entity_id)))
2188: returning wjsi.interface_id bulk collect into l_interfaceTbl;
2189:

Line 3847: from wip_reservations_v wr

3843: l_old_status number := 0 ; /* Fix for Bug#4406036 */
3844:
3845: cursor check_so_link is
3846: select nvl(sum(wr.primary_quantity), 0)
3847: from wip_reservations_v wr
3848: where wr.wip_entity_id = wjsi_row.wip_entity_id
3849: and wr.inventory_item_id = nvl(wjsi_row.primary_item_id, wdj_row.primary_item_id)
3850: and wr.organization_id = wjsi_row.organization_id;
3851: begin