APPS.DPP_TRANSACTION_PVT dependencies on MTL_SYSTEM_ITEMS

Line 962: FROM mtl_system_items_kfv msi

958: msi.primary_uom_code
959: INTO p_txn_lines_tbl_type(i).inventory_item_id
960: ,p_txn_lines_tbl_type(i).item_number
961: ,p_txn_lines_tbl_type(i).uom
962: FROM mtl_system_items_kfv msi
963: WHERE msi.purchasing_item_flag = 'Y'
964: AND msi.shippable_item_flag = 'Y'
965: AND msi.enabled_flag = 'Y'
966: AND NVL(msi.consigned_flag,2) = 2 -- 2=unconsigned

Line 980: FROM mtl_system_items_kfv msi

976: msi.primary_uom_code
977: INTO p_txn_lines_tbl_type(i).inventory_item_id
978: ,p_txn_lines_tbl_type(i).item_number
979: ,p_txn_lines_tbl_type(i).uom
980: FROM mtl_system_items_kfv msi
981: WHERE msi.purchasing_item_flag = 'Y'
982: AND msi.shippable_item_flag = 'Y'
983: AND msi.enabled_flag = 'Y'
984: AND NVL(msi.consigned_flag,2) = 2 -- 2=unconsigned

Line 997: FROM mtl_system_items_kfv msi

993: msi.primary_uom_code
994: INTO p_txn_lines_tbl_type(i).inventory_item_id
995: ,p_txn_lines_tbl_type(i).item_number
996: ,p_txn_lines_tbl_type(i).uom
997: FROM mtl_system_items_kfv msi
998: WHERE msi.purchasing_item_flag = 'Y'
999: AND msi.shippable_item_flag = 'Y'
1000: AND msi.enabled_flag = 'Y'
1001: AND NVL(msi.consigned_flag,2) = 2 -- 2=unconsigned

Line 1206: FROM mtl_system_items msi

1202: IF p_txn_lines_tbl_type(i).prior_price IS NULL THEN
1203: --get list price for the selected inventory organization id
1204: SELECT msi.LIST_PRICE_PER_UNIT list_price
1205: INTO p_txn_lines_tbl_type(i).list_price
1206: FROM mtl_system_items msi
1207: WHERE msi.inventory_item_id = to_number(p_txn_lines_tbl_type(i).inventory_item_id) and
1208: msi.organization_id = p_txn_header_rec_type.inventory_organization_id;
1209:
1210: p_txn_lines_tbl_type(i).prior_price := p_txn_lines_tbl_type(i).list_price;