DBA Data[Home] [Help]

APPS.CST_EAMCOST_PUB dependencies on WIP_REQUIREMENT_OPERATIONS

Line 2632: FROM wip_requirement_operations wro,

2628: decode(msi.eam_item_type,
2629: 3,decode(wdj.issue_zero_cost_flag,'Y',0,
2630: nvl(ccicv.overhead_cost,0)),
2631: NVL(ccicv.overhead_cost,0))), l_ext_precision) overhead_cost
2632: FROM wip_requirement_operations wro,
2633: cst_cg_item_costs_view ccicv,
2634: mtl_system_items_b msi,
2635: wip_discrete_jobs wdj
2636: WHERE wro.wip_entity_id = p_wip_entity_id

Line 2669: FROM wip_requirement_operations wro,

2665: ) *
2666: NVL(wro.unit_price,0)), l_ext_precision) mat_value,
2667: msi.inventory_item_id item_id,
2668: mic.category_id category_id
2669: FROM wip_requirement_operations wro,
2670: (SELECT cedi.work_order_number,
2671: cedi.organization_id,
2672: cedi.task_number,
2673: cedi.item_id,

Line 4028: FROM wip_requirement_operations wro,

4024: p_request_id,
4025: p_prog_app_id,
4026: p_prog_id,
4027: SYSDATE
4028: FROM wip_requirement_operations wro,
4029: cst_cg_item_costs_view ccicv,
4030: wip_discrete_jobs wdj,
4031: mtl_system_items_b msi
4032: WHERE wro.wip_entity_id = p_wip_entity_id

Line 4280: FROM wip_requirement_operations wro,

4276: p_request_id,
4277: p_prog_app_id,
4278: p_prog_id,
4279: SYSDATE
4280: FROM wip_requirement_operations wro,
4281: (SELECT
4282: cedi.work_order_number,
4283: cedi.organization_id,
4284: cedi.task_number,