APPS.DPP_TRANSACTION_PVT dependencies on MTL_SYSTEM_ITEMS_KFV

Line 1145: FROM mtl_system_items_kfv msi

1141: msi.primary_uom_code
1142: INTO p_txn_lines_tbl_type(i).inventory_item_id
1143: ,p_txn_lines_tbl_type(i).item_number
1144: ,p_txn_lines_tbl_type(i).uom
1145: FROM mtl_system_items_kfv msi
1146: WHERE msi.purchasing_item_flag = 'Y'
1147: AND msi.shippable_item_flag = 'Y'
1148: AND msi.enabled_flag = 'Y'
1149: AND NVL(msi.consigned_flag,2) = 2 -- 2=unconsigned

Line 1163: FROM mtl_system_items_kfv msi

1159: msi.primary_uom_code
1160: INTO p_txn_lines_tbl_type(i).inventory_item_id
1161: ,p_txn_lines_tbl_type(i).item_number
1162: ,p_txn_lines_tbl_type(i).uom
1163: FROM mtl_system_items_kfv msi
1164: WHERE msi.purchasing_item_flag = 'Y'
1165: AND msi.shippable_item_flag = 'Y'
1166: AND msi.enabled_flag = 'Y'
1167: AND NVL(msi.consigned_flag,2) = 2 -- 2=unconsigned

Line 1180: FROM mtl_system_items_kfv msi

1176: msi.primary_uom_code
1177: INTO p_txn_lines_tbl_type(i).inventory_item_id
1178: ,p_txn_lines_tbl_type(i).item_number
1179: ,p_txn_lines_tbl_type(i).uom
1180: FROM mtl_system_items_kfv msi
1181: WHERE msi.purchasing_item_flag = 'Y'
1182: AND msi.shippable_item_flag = 'Y'
1183: AND msi.enabled_flag = 'Y'
1184: AND NVL(msi.consigned_flag,2) = 2 -- 2=unconsigned