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 296: FROM mtl_system_items_b

292: --
293: --===================================================================
294: SELECT primary_uom_code
295: INTO g_primary_uom
296: FROM mtl_system_items_b
297: WHERE inventory_item_id = g_inventory_item_id
298: AND organization_id = g_from_organization_id;
299:
300: --===================================================================

Line 938: qp_pricing_attributes qpa, mtl_system_items_b msi

934:
935: SELECT spll.operand, substr(spl.currency_code, 1, 15), msi.primary_uom_code
936: INTO l_transfer_price, l_pricelist_currency, l_primary_uom
937: FROM qp_list_headers_b spl, qp_list_lines spll,
938: qp_pricing_attributes qpa, mtl_system_items_b msi
939: WHERE msi.organization_id = g_from_organization_id
940: AND msi.inventory_item_id = g_inventory_item_id
941: AND spl.list_header_id = l_pricelist_id
942: AND spll.list_header_id = spl.list_header_id