DBA Data[Home] [Help]

APPS.CST_EAMCOST_PUB dependencies on WIP_REQUIREMENT_OPERATIONS

Line 2854: FROM wip_requirement_operations wro,

2850: decode(msi.eam_item_type,
2851: 3,decode(wdj.issue_zero_cost_flag,'Y',0,
2852: nvl(ccicv.overhead_cost,0)),
2853: NVL(ccicv.overhead_cost,0))), l_ext_precision) overhead_cost
2854: FROM wip_requirement_operations wro,
2855: cst_cg_item_costs_view ccicv,
2856: mtl_system_items_b msi,
2857: wip_discrete_jobs wdj
2858: WHERE wro.wip_entity_id = p_wip_entity_id

Line 2891: FROM wip_requirement_operations wro,

2887: ) *
2888: NVL(wro.unit_price,0)), l_ext_precision) mat_value,
2889: msi.inventory_item_id item_id,
2890: mic.category_id category_id
2891: FROM wip_requirement_operations wro,
2892: (SELECT cedi.work_order_number,
2893: cedi.organization_id,
2894: cedi.task_number,
2895: cedi.item_id,

Line 4250: FROM wip_requirement_operations wro,

4246: p_request_id,
4247: p_prog_app_id,
4248: p_prog_id,
4249: SYSDATE
4250: FROM wip_requirement_operations wro,
4251: cst_cg_item_costs_view ccicv,
4252: wip_discrete_jobs wdj,
4253: mtl_system_items_b msi
4254: WHERE wro.wip_entity_id = p_wip_entity_id

Line 4502: FROM wip_requirement_operations wro,

4498: p_request_id,
4499: p_prog_app_id,
4500: p_prog_id,
4501: SYSDATE
4502: FROM wip_requirement_operations wro,
4503: (SELECT
4504: cedi.work_order_number,
4505: cedi.organization_id,
4506: cedi.task_number,