APPS.CST_EAMCOST_PUB dependencies on MTL_SYSTEM_ITEMS

Line 49: FROM mtl_system_items msi

45: IS
46: SELECT msi.outside_operation_uom_type
47: , rt.primary_quantity
48: , rt.transaction_type
49: FROM mtl_system_items msi
50: , rcv_transactions rt
51: , po_lines_all pl
52: WHERE rt.transaction_id = p_rcv_trx_id
53: AND rt.po_line_id = pl.po_line_id

Line 2856: mtl_system_items_b msi,

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

Line 2907: mtl_system_items_b msi

2903: ) quantity_ordered
2904: /* Sum is needed because there could be multiple POs/Reqs
2905: for the same non-stockable item */
2906: FROM cst_eam_direct_items_temp cedi,
2907: mtl_system_items_b msi
2908: WHERE cedi.item_id = msi.inventory_item_id
2909: AND cedi.organization_id = msi.organization_id
2910: AND cedi.work_order_number = p_wip_entity_id
2911: GROUP

Line 2917: mtl_system_items_b msi,

2913: cedi.organization_id,
2914: cedi.task_number,
2915: cedi.item_id
2916: ) wediv,
2917: mtl_system_items_b msi,
2918: mtl_item_categories mic,
2919: mtl_default_category_sets mdcs
2920: WHERE wro.wip_entity_id = p_wip_entity_id
2921: AND wediv.work_order_number(+) = wro.wip_entity_id

Line 4253: mtl_system_items_b msi

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
4255: AND ccicv.inventory_item_id = wro.inventory_item_id
4256: AND ccicv.organization_id = wro.organization_id
4257: AND ccicv.cost_group_id = decode(l_primary_cost_method,1,1,

Line 4519: mtl_system_items_b msi

4515: ) quantity_ordered
4516: /* Sum is needed because there could be multiple POs/Reqs
4517: for the same non-stockable item */
4518: FROM cst_eam_direct_items_temp cedi,
4519: mtl_system_items_b msi
4520: WHERE cedi.item_id = msi.inventory_item_id
4521: AND cedi.organization_id = msi.organization_id
4522: AND cedi.work_order_number = p_wip_entity_id
4523: GROUP

Line 4529: mtl_system_items_b msi

4525: cedi.organization_id,
4526: cedi.task_number,
4527: cedi.item_id
4528: ) wediv,
4529: mtl_system_items_b msi
4530: WHERE wro.wip_entity_id = p_wip_entity_id
4531: AND wediv.work_order_number(+) = wro.wip_entity_id
4532: AND wediv.item_id(+) = wro.inventory_item_id
4533: AND wediv.organization_id(+) = wro.organization_id

Line 6040: FROM mtl_system_items_b

6036: ELSE
6037: l_stmt_num := 80;
6038: SELECT nvl(outside_operation_flag,'N')
6039: INTO l_osp_item
6040: FROM mtl_system_items_b
6041: WHERE inventory_item_id = l_item_id
6042: AND organization_id = l_org_id;
6043:
6044: if (l_debug = 'Y') then

Line 6444: from mtl_system_items_b msi

6440: else
6441:
6442: SELECT msi.primary_uom_code
6443: INTO l_directItem_rec.primary_uom
6444: from mtl_system_items_b msi
6445: where msi.inventory_item_id = l_item_id
6446: and msi.organization_id = l_directItem_rec.organization_id;
6447:
6448: l_directItem_rec.primary_quantity := inv_convert.inv_um_convert(

Line 11483: , mtl_system_items msi

11479: , mp.encumbrance_account mp_encumbrance_account
11480: FROM wip_entities we
11481: , wip_discrete_jobs wdj
11482: , wip_accounting_classes wac
11483: , mtl_system_items msi
11484: , mtl_parameters mp
11485: WHERE we.wip_entity_id = p_wip_entity_id
11486: AND we.wip_entity_id = wdj.wip_entity_id
11487: AND wac.organization_id = wdj.organization_id