APPS.DPP_TRANSACTION_PVT dependencies on OZF_SUPP_TRD_PRFLS_ALL

Line 294: ozf_supp_trd_prfls_all ostp

290: ,apssa.vendor_site_code
291: INTO p_txn_header_rec_type.vendor_site_id
292: ,p_txn_header_rec_type.vendor_site_code
293: FROM ap_supplier_sites_all apssa,
294: ozf_supp_trd_prfls_all ostp
295: WHERE apssa.vendor_id = to_number(p_txn_header_rec_type.vendor_id)
296: AND ostp.supplier_id = apssa.vendor_id
297: AND ostp.supplier_site_id = apssa.vendor_site_id
298: AND ostp.org_id = apssa.org_id

Line 349: FROM ozf_supp_trd_prfls_all

345: --Cursor to retrieve the supplier trade profile id
346: CURSOR get_supp_trd_prfl_csr (p_vendor_id NUMBER, p_vendor_site_id NUMBER, p_org_id NUMBER)
347: IS
348: SELECT supp_trade_profile_id
349: FROM ozf_supp_trd_prfls_all
350: WHERE supplier_id = p_vendor_id
351: AND supplier_site_id = p_vendor_site_id
352: AND org_id = p_org_id;
353:

Line 631: FROM ozf_supp_trd_prfls_all ostpa

627: -- Initialize API return status to sucess
628: x_return_status := fnd_api.g_ret_sts_success;
629: SELECT default_days_covered
630: INTO p_txn_header_rec_type.days_covered
631: FROM ozf_supp_trd_prfls_all ostpa
632: WHERE ostpa.supplier_id =to_number(p_txn_header_rec_type.vendor_id)
633: AND ostpa.supplier_site_id =to_number(p_txn_header_rec_type.vendor_site_id);
634:
635: IF DPP_DEBUG_HIGH_ON THEN

Line 1221: FROM ozf_supp_trd_prfls_all ostpa,

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

Line 1277: FROM ozf_supp_trd_prfls_all ostpa,

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

Line 1322: FROM ozf_supp_trd_prfls_all ostpa,

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

Line 2055: FROM ozf_supp_trd_prfls_all ostp,

2051: --Get the supplier trade profile value to include price increase value for claim or not
2052: BEGIN
2053: SELECT nvl(create_claim_price_increase,'N')
2054: INTO l_price_change_flag
2055: FROM ozf_supp_trd_prfls_all ostp,
2056: dpp_transaction_headers_all dtha
2057: WHERE ostp.supplier_id = to_number(dtha.vendor_id)
2058: AND ostp.supplier_site_id = to_number(dtha.vendor_site_id)
2059: AND ostp.org_id = to_number(dtha.org_id)