APPS.CSD_RECALLS_PVT dependencies on WIP_PERIOD_BALANCES

Line 1311: wip_period_balances wpb

1307: FROM csd_recall_metrics crm,
1308: csd_recall_headers_b crh,
1309: csd_recall_lines crl,
1310: csd_repair_job_xref crj,
1311: wip_period_balances wpb
1312: WHERE crm.metric_id IN
1313: (SELECT * FROM TABLE(CAST(l_metric_ids AS JTF_NUMBER_TABLE)))
1314: AND crm.recall_number = crh.recall_number
1315: AND crh.recall_id = crl.recall_id

Line 1345: FROM wip_period_balances wpb,

1341: AND crh.recall_id = crl.recall_id
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)

Line 1400: FROM wip_period_balances

1396: AND crh.recall_id = crl.recall_id
1397: AND crl.repair_line_id = crj.repair_line_id
1398: AND EXISTS (
1399: SELECT 'exists'
1400: FROM wip_period_balances
1401: WHERE wip_entity_id = crj.wip_entity_id
1402: GROUP BY wip_entity_id
1403: HAVING SUM(tl_resource_in+pl_resource_in+tl_overhead_in+pl_material_in+pl_material_overhead_in+pl_overhead_in) > 0)
1404: GROUP BY crh.recall_number