DBA Data[Home] [Help]

APPS.INV_TRANSACTION_FLOW_PUB dependencies on MTL_SYSTEM_ITEMS

Line 3937: QP_PRICING_ATTRIBUTES QPA, MTL_SYSTEM_ITEMS_B MSI

3933: /*Bug: 5054047 Modified the SQL*/
3934: SELECT SPLL.operand, substr(SPL.currency_code, 1, 15), msi.primary_uom_code
3935: INTO l_transfer_price, l_invoice_currency_code, l_primary_uom
3936: FROM QP_LIST_HEADERS_B SPL, QP_LIST_LINES SPLL,
3937: QP_PRICING_ATTRIBUTES QPA, MTL_SYSTEM_ITEMS_B MSI
3938: WHERE MSI.organization_id = l_organization_id
3939: AND MSI.inventory_item_id = p_inventory_item_id
3940: AND SPL.list_header_id = p_price_list_id
3941: AND SPLL.list_header_id = SPL.list_header_id

Line 3965: FROM mtl_system_items_kfv

3961: l_transfer_price := -99;
3962: l_return_status := G_RET_STS_ERROR;
3963: SELECT concatenated_segments, primary_uom_code
3964: INTO l_item_description, l_primary_uom
3965: FROM mtl_system_items_kfv
3966: WHERE organization_id = l_organization_id
3967: AND inventory_item_id = p_inventory_item_id;
3968:
3969: SELECT name

Line 4188: FROM mtl_system_items

4184:
4185: IF( l_transfer_price is NULL or l_transfer_price = -99 ) then
4186: SELECT description
4187: into l_item_description
4188: FROM mtl_system_items
4189: WHERE organization_id = l_organization_id
4190: AND inventory_item_id = p_inventory_item_id;
4191: END IF;
4192:

Line 4224: FROM mtl_system_items

4220:
4221: IF l_primary_uom IS NULL THEN
4222: SELECT primary_uom_code
4223: INTO l_primary_uom
4224: FROM mtl_system_items
4225: WHERE organization_id = l_organization_id
4226: AND inventory_item_id = p_inventory_item_id;
4227: END IF;
4228:

Line 4528: from mtl_system_items_b

4524: print_Debug('Get the base_item_id for the inventory_item_id ' || p_inventory_item_id, 'GET_TRANSFER_PRICE');
4525: BEGIN
4526: select nvl(base_item_id, 0)
4527: into l_base_item
4528: from mtl_system_items_b
4529: where inventory_item_id = p_inventory_item_id
4530: and organization_id = l_organization_id;
4531:
4532: EXCEPTION