215: from
216: wip_cost_txn_interface wcti,
217: wip_discrete_jobs wdj,
218: wip_period_balances wpb,
219: cst_cost_elements cce
220: WHERE wcti.group_id = l_group_id
221: AND wcti.line_id IS NULL
222: AND wdj.wip_entity_id = wcti.wip_entity_id
223: AND wdj.organization_id = wcti.organization_id
300: from
301: wip_cost_txn_interface wcti,
302: wip_discrete_jobs wdj,
303: wip_period_balances wpb,
304: cst_cost_elements cce
305: WHERE wcti.group_id = l_group_id
306: AND wcti.line_id IS NULL
307: AND wdj.wip_entity_id = wcti.wip_entity_id
308: AND wdj.organization_id = wcti.organization_id
572: from
573: wip_cost_txn_interface wcti,
574: wip_txn_allocations alloc,
575: wip_period_balances wpb,
576: cst_cost_elements cce,
577: wip_repetitive_schedules wrs
578: WHERE wcti.group_id = l_group_id
579: AND wcti.line_id IS NOT NULL
580: AND WRS.WIP_ENTITY_ID = WCTI.WIP_ENTITY_ID
664: from
665: wip_cost_txn_interface wcti,
666: wip_txn_allocations alloc,
667: wip_period_balances wpb,
668: cst_cost_elements cce,
669: wip_repetitive_schedules wrs
670: WHERE wcti.group_id = l_group_id
671: AND wcti.line_id IS NOT NULL
672: AND WRS.WIP_ENTITY_ID = WCTI.WIP_ENTITY_ID