DBA Data[Home] [Help]

APPS.WIP_VALIDATEMLHEADER_PVT dependencies on WIP_RESERVATIONS_V

Line 2183: from wip_reservations_v wr

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

Line 2187: from wip_reservations_v wr

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

Line 3953: from wip_reservations_v wr

3949: l_old_status number := 0 ; /* Fix for Bug#4406036 */
3950:
3951: cursor check_so_link is
3952: select nvl(sum(wr.primary_quantity), 0)
3953: from wip_reservations_v wr
3954: where wr.wip_entity_id = wjsi_row.wip_entity_id
3955: and wr.inventory_item_id = nvl(wjsi_row.primary_item_id, wdj_row.primary_item_id)
3956: and wr.organization_id = wjsi_row.organization_id;
3957: begin