eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.DPP_TRANSACTION_PVT dependencies on OZF_SUPP_CODE_CONVERSIONS_ALL

Line 1039: ozf_supp_code_conversions_all occ

1035: dpp_utility_pvt.debug_message('Validate Supplier Part Number Case IV');
1036: SELECT occ.external_code
1037: INTO p_txn_lines_tbl_type(i).supplier_part_num
1038: FROM ozf_supp_trd_prfls_all ostpa,
1039: ozf_supp_code_conversions_all occ
1040: WHERE occ.internal_code = p_txn_lines_tbl_type(i).inventory_item_id
1041: AND occ.code_conversion_type = 'OZF_PRODUCT_CODES'
1042: AND occ.org_id = to_number(p_txn_header_rec_type.org_id)
1043: AND occ.supp_trade_profile_id = ostpa.supp_trade_profile_id

Line 1095: ozf_supp_code_conversions_all occ

1091: dpp_utility_pvt.debug_message('Validate Supplier Part Number Case V');
1092: SELECT occ.external_code
1093: INTO p_txn_lines_tbl_type(i).supplier_part_num
1094: FROM ozf_supp_trd_prfls_all ostpa,
1095: ozf_supp_code_conversions_all occ
1096: WHERE occ.internal_code = p_txn_lines_tbl_type(i).inventory_item_id
1097: AND occ.code_conversion_type = 'OZF_PRODUCT_CODES'
1098: AND occ.org_id = to_number(p_txn_header_rec_type.org_id)
1099: AND occ.supp_trade_profile_id = ostpa.supp_trade_profile_id

Line 1140: ozf_supp_code_conversions_all occ

1136: ,occ.internal_code
1137: INTO p_txn_lines_tbl_type(i).supplier_part_num
1138: ,p_txn_lines_tbl_type(i).inventory_item_id
1139: FROM ozf_supp_trd_prfls_all ostpa,
1140: ozf_supp_code_conversions_all occ
1141: WHERE occ.code_conversion_type = 'OZF_PRODUCT_CODES'
1142: AND occ.org_id = to_number(p_txn_header_rec_type.org_id)
1143: AND occ.supp_trade_profile_id = ostpa.supp_trade_profile_id
1144: AND ostpa.supplier_id = to_number(p_txn_header_rec_type.vendor_id)