APPS.DPP_TRANSACTION_PVT dependencies on OZF_SUPP_TRD_PRFLS_ALL

Line 289: ozf_supp_trd_prfls_all ostp

285: ,apssa.vendor_site_code
286: INTO p_txn_header_rec_type.vendor_site_id
287: ,p_txn_header_rec_type.vendor_site_code
288: FROM ap_supplier_sites_all apssa,
289: ozf_supp_trd_prfls_all ostp
290: WHERE apssa.vendor_id = to_number(p_txn_header_rec_type.vendor_id)
291: AND ostp.supplier_id = apssa.vendor_id
292: AND ostp.supplier_site_id = apssa.vendor_site_id
293: AND ostp.org_id = apssa.org_id

Line 482: FROM ozf_supp_trd_prfls_all ostpa

478: -- Initialize API return status to sucess
479: x_return_status := fnd_api.g_ret_sts_success;
480: SELECT default_days_covered
481: INTO p_txn_header_rec_type.days_covered
482: FROM ozf_supp_trd_prfls_all ostpa
483: WHERE ostpa.supplier_id =to_number(p_txn_header_rec_type.vendor_id)
484: AND ostpa.supplier_site_id =to_number(p_txn_header_rec_type.vendor_site_id);
485:
486: IF DPP_DEBUG_HIGH_ON THEN

Line 1038: FROM ozf_supp_trd_prfls_all ostpa,

1034: BEGIN
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)

Line 1094: FROM ozf_supp_trd_prfls_all ostpa,

1090: ELSE
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)

Line 1139: FROM ozf_supp_trd_prfls_all ostpa,

1135: SELECT occ.external_code
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

Line 1846: FROM ozf_supp_trd_prfls_all ostp,

1842: --Get the supplier trade profile value to include price increase value for claim or not
1843: BEGIN
1844: SELECT nvl(create_claim_price_increase,'N')
1845: INTO l_price_change_flag
1846: FROM ozf_supp_trd_prfls_all ostp,
1847: dpp_transaction_headers_all dtha
1848: WHERE ostp.supplier_id = to_number(dtha.vendor_id)
1849: AND ostp.supplier_site_id = to_number(dtha.vendor_site_id)
1850: AND ostp.org_id = to_number(dtha.org_id)