APPS.INV_TRANSACTION_FLOW_PUB dependencies on MTL_SYSTEM_ITEMS

Line 4018: QP_PRICING_ATTRIBUTES QPA, MTL_SYSTEM_ITEMS_B MSI

4014:
4015: SELECT SPLL.operand, substr(SPL.currency_code, 1, 15), msi.primary_uom_code
4016: INTO l_transfer_price, l_invoice_currency_code, l_primary_uom
4017: FROM QP_LIST_HEADERS_B SPL, QP_LIST_LINES SPLL,
4018: QP_PRICING_ATTRIBUTES QPA, MTL_SYSTEM_ITEMS_B MSI
4019: WHERE MSI.organization_id = l_organization_id
4020: AND MSI.inventory_item_id = p_inventory_item_id
4021: AND SPL.list_header_id = p_price_list_id
4022: AND SPLL.list_header_id = SPL.list_header_id

Line 4047: FROM mtl_system_items_kfv

4043: l_transfer_price := -99;
4044: l_return_status := G_RET_STS_ERROR;
4045: SELECT concatenated_segments, primary_uom_code
4046: INTO l_item_description, l_primary_uom
4047: FROM mtl_system_items_kfv
4048: WHERE organization_id = l_organization_id
4049: AND inventory_item_id = p_inventory_item_id;
4050:
4051: SELECT name

Line 4280: FROM mtl_system_items

4276: print_Debug('l_primary_uom is Null ' || l_primary_uom, 'get_transfer_price_for_item');
4277:
4278: SELECT primary_uom_code
4279: into l_primary_uom
4280: FROM mtl_system_items
4281: WHERE organization_id = l_organization_id
4282: AND inventory_item_id = p_inventory_item_id;
4283:
4284: print_Debug('l_primary_uom is ' || l_primary_uom, 'get_transfer_price_for_item');

Line 4292: FROM mtl_system_items

4288:
4289: IF( l_transfer_price is NULL or l_transfer_price = -99 ) then
4290: SELECT description
4291: into l_item_description
4292: FROM mtl_system_items
4293: WHERE organization_id = l_organization_id
4294: AND inventory_item_id = p_inventory_item_id;
4295: END IF;
4296:

Line 4328: FROM mtl_system_items

4324:
4325: IF l_primary_uom IS NULL THEN
4326: SELECT primary_uom_code
4327: INTO l_primary_uom
4328: FROM mtl_system_items
4329: WHERE organization_id = l_organization_id
4330: AND inventory_item_id = p_inventory_item_id;
4331: END IF;
4332:

Line 4697: from mtl_system_items_b

4693: print_Debug('Get the base_item_id for the inventory_item_id ' || p_inventory_item_id, 'GET_TRANSFER_PRICE');
4694: BEGIN
4695: select nvl(base_item_id, 0)
4696: into l_base_item
4697: from mtl_system_items_b
4698: where inventory_item_id = p_inventory_item_id
4699: and organization_id = l_organization_id;
4700:
4701: EXCEPTION