DBA Data[Home] [Help]

APPS.CSD_RECALLS_PVT dependencies on WIP_DISCRETE_JOBS

Line 99: wip_discrete_jobs wdj,

95: cii.quantity
96: BULK COLLECT INTO l_post_wipml_tbl
97: FROM csd_recall_lines crl,
98: wip_entities we,
99: wip_discrete_jobs wdj,
100: csd_service_codes_tl csc,
101: mtl_system_items_b msi,
102: csi_item_instances cii
103: WHERE crl.processing_group_id = p_rec_group_id

Line 1346: wip_discrete_jobs wdj

1342: AND crl.repair_line_id = crj.repair_line_id
1343: AND NOT EXISTS
1344: (SELECT 'exists'
1345: FROM wip_period_balances wpb,
1346: wip_discrete_jobs wdj
1347: WHERE wpb.wip_entity_id = crj.wip_entity_id
1348: AND wpb.wip_entity_id = wdj.wip_entity_id
1349: AND wdj.status_type NOT IN (7,12,4,5)
1350: GROUP BY wpb.wip_entity_id