DBA Data[Home] [Help]

APPS.CST_PACEAMCOST_GRP dependencies on MTL_SYSTEM_ITEMS_B

Line 1333: mtl_system_items_b msi,

1329: nvl(cpic.overhead_cost,0)),
1330: NVL(cpic.overhead_cost,0))), l_ext_precision) overhead_cost
1331: FROM wip_requirement_operations wro,
1332: cst_pac_item_costs cpic,
1333: mtl_system_items_b msi,
1334: wip_discrete_jobs wdj
1335: WHERE wro.wip_entity_id = p_wip_entity_id
1336: AND wdj.wip_entity_id = wro.wip_entity_id
1337: AND cpic.inventory_item_id = wro.inventory_item_id

Line 1380: mtl_system_items_b msi

1376: /* We convert to primary_uom because the required_quantity in WRO is
1377: always in the primary unit of measure. Sum is needed because there
1378: could be multiple POs/Reqs for the same non-stockable item */
1379: FROM cst_eam_direct_items_temp ced,
1380: mtl_system_items_b msi
1381: WHERE ced.item_id = msi.inventory_item_id
1382: AND ced.organization_id = msi.organization_id
1383: AND ced.work_order_number = p_wip_entity_id
1384: GROUP BY ced.work_order_number,

Line 1389: mtl_system_items_b msi,

1385: ced.organization_id,
1386: ced.task_number,
1387: ced.item_id
1388: ) cediv,
1389: mtl_system_items_b msi,
1390: mtl_item_categories mic,
1391: mtl_default_category_sets mdcs
1392: WHERE wro.wip_entity_id = p_wip_entity_id
1393: AND cediv.work_order_number(+) = wro.wip_entity_id