APPS.DPP_TRANSACTION_PVT dependencies on OZF_SUPP_CODE_CONVERSIONS_ALL

Line 1222: ozf_supp_code_conversions_all occ

1218: DPP_UTILITY_PVT.DEBUG_MESSAGE( FND_LOG.LEVEL_STATEMENT, 'dpp.plsql.' || L_FULL_NAME, 'Validate Supplier Part Number Case IV');
1219: SELECT occ.external_code
1220: INTO p_txn_lines_tbl_type(i).supplier_part_num
1221: FROM ozf_supp_trd_prfls_all ostpa,
1222: ozf_supp_code_conversions_all occ
1223: WHERE occ.internal_code = p_txn_lines_tbl_type(i).inventory_item_id
1224: AND occ.code_conversion_type = 'OZF_PRODUCT_CODES'
1225: AND occ.org_id = to_number(p_txn_header_rec_type.org_id)
1226: AND occ.supp_trade_profile_id = ostpa.supp_trade_profile_id

Line 1278: ozf_supp_code_conversions_all occ

1274: DPP_UTILITY_PVT.DEBUG_MESSAGE( FND_LOG.LEVEL_STATEMENT, 'dpp.plsql.' || L_FULL_NAME, 'Validate Supplier Part Number Case V');
1275: SELECT occ.external_code
1276: INTO p_txn_lines_tbl_type(i).supplier_part_num
1277: FROM ozf_supp_trd_prfls_all ostpa,
1278: ozf_supp_code_conversions_all occ
1279: WHERE occ.internal_code = p_txn_lines_tbl_type(i).inventory_item_id
1280: AND occ.code_conversion_type = 'OZF_PRODUCT_CODES'
1281: AND occ.org_id = to_number(p_txn_header_rec_type.org_id)
1282: AND occ.supp_trade_profile_id = ostpa.supp_trade_profile_id

Line 1323: ozf_supp_code_conversions_all occ

1319: ,occ.internal_code
1320: INTO p_txn_lines_tbl_type(i).supplier_part_num
1321: ,p_txn_lines_tbl_type(i).inventory_item_id
1322: FROM ozf_supp_trd_prfls_all ostpa,
1323: ozf_supp_code_conversions_all occ
1324: WHERE occ.code_conversion_type = 'OZF_PRODUCT_CODES'
1325: AND occ.org_id = to_number(p_txn_header_rec_type.org_id)
1326: AND occ.supp_trade_profile_id = ostpa.supp_trade_profile_id
1327: AND ostpa.supplier_id = to_number(p_txn_header_rec_type.vendor_id)