APPS.GMF_GET_TRANSFER_PRICE_PUB dependencies on MTL_SYSTEM_ITEMS_B

Line 66: g_primary_uom mtl_system_items_b.primary_uom_code%TYPE;

62:
63: g_inventory_item_id NUMBER;
64: g_transaction_qty mtl_material_transactions.transaction_quantity%TYPE;
65: g_transaction_uom mtl_material_transactions.transaction_uom%TYPE;
66: g_primary_uom mtl_system_items_b.primary_uom_code%TYPE;
67:
68: g_transaction_id BINARY_INTEGER; -- will be NULL
69: g_order_line_id BINARY_INTEGER; -- will be order_line_id for Internal Orders
70:

Line 255: FROM mtl_system_items_b

251: --
252: --===================================================================
253: SELECT primary_uom_code
254: INTO g_primary_uom
255: FROM mtl_system_items_b
256: WHERE inventory_item_id = g_inventory_item_id
257: AND organization_id = g_from_organization_id;
258:
259: --===================================================================

Line 854: qp_pricing_attributes qpa, mtl_system_items_b msi

850:
851: SELECT spll.operand, substr(spl.currency_code, 1, 15), msi.primary_uom_code
852: INTO l_transfer_price, l_pricelist_currency, l_primary_uom
853: FROM qp_list_headers_b spl, qp_list_lines spll,
854: qp_pricing_attributes qpa, mtl_system_items_b msi
855: WHERE msi.organization_id = g_from_organization_id
856: AND msi.inventory_item_id = g_inventory_item_id
857: AND spl.list_header_id = l_pricelist_id
858: AND spll.list_header_id = spl.list_header_id