APPS.CST_EAM_WORKORDERS_PVT dependencies on WIP_ENTITIES

Line 268: FROM wip_entities

264: IF (p_range = 2) THEN
265: l_stmt_num := 30;
266: SELECT wip_entity_name
267: INTO l_wip_entity_name
268: FROM wip_entities
269: WHERE wip_entity_id = p_specific_workorder;
270: END IF;
271:
272: l_stmt_num := 30;

Line 487: WIP_ENTITIES we,

483: sum(nvl(wpepb.system_estimated_lab_cost,0)) - sum(nvl(wpepb.actual_lab_cost,0)) VAR_LABR_COST,
484: sum(nvl(wpepb.system_estimated_eqp_cost,0)) - sum(nvl(wpepb.actual_eqp_cost,0)) VAR_EQUIP_COST
485: FROM CST_PAC_EAM_PERIOD_BALANCES WPEPB,
486: MTL_PARAMETERS mp,
487: WIP_ENTITIES we,
488: BOM_DEPARTMENTS bd,
489: MFG_LOOKUPS lu1
490:
491: Where wpepb.legal_entity_id = :p_legal_entity_id

Line 528: WIP_ENTITIES we,

524: sum(nvl(wpepb.system_estimated_eqp_cost,0)) - sum(nvl(wpepb.actual_eqp_cost,0)) VAR_EQUIP_COST
525:
526: FROM CST_PAC_EAM_PERIOD_BALANCES WPEPB,
527: MTL_PARAMETERS mp,
528: WIP_ENTITIES we,
529: BOM_DEPARTMENTS bd,
530: MFG_LOOKUPS lu1
531:
532: Where wpepb.legal_entity_id = :p_legal_entity_id

Line 571: WIP_ENTITIES we,

567: sum(nvl(wpepb.system_estimated_eqp_cost,0)) - sum(nvl(wpepb.actual_eqp_cost,0)) VAR_EQUIP_COST
568:
569: FROM CST_PAC_EAM_PERIOD_BALANCES WPEPB,
570: MTL_PARAMETERS mp,
571: WIP_ENTITIES we,
572: BOM_DEPARTMENTS bd,
573: MFG_LOOKUPS lu1
574:
575: Where wpepb.legal_entity_id = :p_legal_entity_id