APPS.WIP_SO_RESERVATIONS dependencies on WIP_RESERVATIONS_V

Line 2118: FROM wip_reservations_v

2114: WHERE wdj.organization_id = p_org_id
2115: AND wdj.status_type IN (WIP_CONSTANTS.UNRELEASED, WIP_CONSTANTS.RELEASED,
2116: WIP_CONSTANTS.COMP_CHRG)
2117: AND wdj.wip_entity_id IN (SELECT wip_entity_id
2118: FROM wip_reservations_v
2119: WHERE demand_source_line_id = p_line_id
2120: AND demand_source_header_id = p_header_id
2121: AND organization_id = p_org_id);
2122:

Line 2135: FROM wip_reservations_v

2131: WHERE wdj.organization_id = p_org_id
2132: AND wdj.status_type IN (WIP_CONSTANTS.UNRELEASED, WIP_CONSTANTS.RELEASED,
2133: WIP_CONSTANTS.COMP_CHRG)
2134: AND wdj.wip_entity_id IN (SELECT wip_entity_id
2135: FROM wip_reservations_v
2136: WHERE demand_source_line_id = p_line_id
2137: AND demand_source_header_id = p_header_id
2138: AND organization_id = p_org_id)
2139: AND NOT EXISTS (SELECT 1

Line 2140: FROM wip_reservations_v wrv1

2136: WHERE demand_source_line_id = p_line_id
2137: AND demand_source_header_id = p_header_id
2138: AND organization_id = p_org_id)
2139: AND NOT EXISTS (SELECT 1
2140: FROM wip_reservations_v wrv1
2141: WHERE wrv1.demand_source_line_id = p_line_id
2142: AND wrv1.demand_source_header_id = p_header_id
2143: AND ((wrv1.organization_id <> p_org_id)
2144: OR (wrv1.wip_entity_id <> wdj.wip_entity_id)))

Line 2146: FROM wip_reservations_v wrv2

2142: AND wrv1.demand_source_header_id = p_header_id
2143: AND ((wrv1.organization_id <> p_org_id)
2144: OR (wrv1.wip_entity_id <> wdj.wip_entity_id)))
2145: AND NOT EXISTS (SELECT 1
2146: FROM wip_reservations_v wrv2
2147: WHERE wrv2.wip_entity_id = wdj.wip_entity_id
2148: AND wrv2.organization_id = wdj.organization_id
2149: AND ((wrv2.demand_source_header_id <> p_header_id)
2150: OR (wrv2.demand_source_line_id <> p_line_id)));

Line 2155: FROM wip_discrete_jobs wdj, wip_reservations_v wrv

2151: */
2152:
2153: Cursor l_1to1_cursor IS
2154: SELECT wdj.wip_entity_id
2155: FROM wip_discrete_jobs wdj, wip_reservations_v wrv
2156: WHERE wdj.organization_id = p_org_id
2157: AND wdj.organization_id = wrv.organization_id
2158: AND wdj.status_type IN (WIP_CONSTANTS.UNRELEASED,
2159: WIP_CONSTANTS.RELEASED,

Line 2165: FROM wip_reservations_v wrv1

2161: AND wdj.wip_entity_id = wrv.wip_entity_id
2162: AND wrv.demand_source_line_id = p_line_id
2163: AND wrv.demand_source_header_id = p_header_id
2164: AND NOT EXISTS (SELECT 1
2165: FROM wip_reservations_v wrv1
2166: WHERE (wrv1.demand_source_line_id = p_line_id AND
2167: wrv1.demand_source_header_id = p_header_id AND
2168: (wrv1.organization_id <> p_org_id OR
2169: wrv1.wip_entity_id <> wdj.wip_entity_id))

Line 2384: from wip_reservations_v

2380: l_quantity_completed := current_job.quantity_completed;
2381:
2382: select nvl(sum(primary_quantity),0)
2383: into l_job_reservation_quantity
2384: from wip_reservations_v
2385: where wip_entity_id = l_wip_entity_id;
2386: /*
2387: dbms_output.put_line ('wip_entity_id: '||l_wip_entity_id );
2388: dbms_output.put_line ('l_job_start_quantity : '||l_job_start_quantity );