DBA Data[Home] [Help]

APPS.CSD_DEPOT_UPDATE_PVT dependencies on WIP_DISCRETE_JOBS

Line 141: wip_discrete_jobs wdj

137: -- Cursor to get wip entity id
138: CURSOR get_wip_entity (p_inc_id in number) IS
139: SELECT distinct crog.wip_entity_id
140: FROM csd_repair_order_groups crog,
141: wip_discrete_jobs wdj
142: WHERE crog.wip_entity_id = wdj.wip_entity_id
143: AND wdj.status_type in ( 4,12,5)
144: AND crog.incident_id = p_inc_id;
145:

Line 310: -- Get the qty completed from wip_discrete_jobs based on the wip_entity_id

306: LOOP
307:
308: -- Get the actual quantity completed
309: BEGIN
310: -- Get the qty completed from wip_discrete_jobs based on the wip_entity_id
311: -- Only if the wip job that is completed will be processed
312: -- and the partial completed qty will not be processed
313:
314: SELECT wip_entity_id,

Line 328: FROM wip_discrete_jobs

324: p_date_completed,
325: p_organization_id,
326: p_routing_reference_id,
327: p_last_updated_by
328: FROM wip_discrete_jobs
329: WHERE wip_entity_id = C1.wip_entity_id
330: AND status_type in ( 4,12,5);
331: EXCEPTION
332: WHEN NO_DATA_FOUND THEN