APPS.CST_EAMCOST_PUB dependencies on MTL_SYSTEM_ITEMS_B

Line 2634: mtl_system_items_b msi,

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
2637: AND wdj.wip_entity_id = wro.wip_entity_id
2638: AND ccicv.inventory_item_id = wro.inventory_item_id

Line 2685: mtl_system_items_b msi

2681: ) quantity_ordered
2682: /* Sum is needed because there could be multiple POs/Reqs
2683: for the same non-stockable item */
2684: FROM cst_eam_direct_items_temp cedi,
2685: mtl_system_items_b msi
2686: WHERE cedi.item_id = msi.inventory_item_id
2687: AND cedi.organization_id = msi.organization_id
2688: AND cedi.work_order_number = p_wip_entity_id
2689: GROUP

Line 2695: mtl_system_items_b msi,

2691: cedi.organization_id,
2692: cedi.task_number,
2693: cedi.item_id
2694: ) wediv,
2695: mtl_system_items_b msi,
2696: mtl_item_categories mic,
2697: mtl_default_category_sets mdcs
2698: WHERE wro.wip_entity_id = p_wip_entity_id
2699: AND wediv.work_order_number(+) = wro.wip_entity_id

Line 4031: mtl_system_items_b msi

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
4033: AND ccicv.inventory_item_id = wro.inventory_item_id
4034: AND ccicv.organization_id = wro.organization_id
4035: AND ccicv.cost_group_id = decode(l_primary_cost_method,1,1,

Line 4297: mtl_system_items_b msi

4293: ) quantity_ordered
4294: /* Sum is needed because there could be multiple POs/Reqs
4295: for the same non-stockable item */
4296: FROM cst_eam_direct_items_temp cedi,
4297: mtl_system_items_b msi
4298: WHERE cedi.item_id = msi.inventory_item_id
4299: AND cedi.organization_id = msi.organization_id
4300: AND cedi.work_order_number = p_wip_entity_id
4301: GROUP

Line 4307: mtl_system_items_b msi

4303: cedi.organization_id,
4304: cedi.task_number,
4305: cedi.item_id
4306: ) wediv,
4307: mtl_system_items_b msi
4308: WHERE wro.wip_entity_id = p_wip_entity_id
4309: AND wediv.work_order_number(+) = wro.wip_entity_id
4310: AND wediv.item_id(+) = wro.inventory_item_id
4311: AND wediv.organization_id(+) = wro.organization_id

Line 5744: FROM mtl_system_items_b

5740: ELSE
5741: l_stmt_num := 80;
5742: SELECT nvl(outside_operation_flag,'N')
5743: INTO l_osp_item
5744: FROM mtl_system_items_b
5745: WHERE inventory_item_id = l_item_id
5746: AND organization_id = l_org_id;
5747:
5748: if (l_debug = 'Y') then

Line 6090: from mtl_system_items_b msi

6086: else
6087:
6088: SELECT msi.primary_uom_code
6089: INTO l_directItem_rec.primary_uom
6090: from mtl_system_items_b msi
6091: where msi.inventory_item_id = l_item_id
6092: and msi.organization_id = l_directItem_rec.organization_id;
6093:
6094: l_directItem_rec.primary_quantity := inv_convert.inv_um_convert(