APPS.DPP_TRANSACTION_PVT dependencies on MTL_SYSTEM_ITEMS_KFV

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