APPS.OZF_SD_REQUEST_PUB dependencies on OZF_SUPP_TRD_PRFLS_ALL

Line 623: FROM ozf_supp_trd_prfls_all

619: CURSOR c_chk_stp_exists(p_supplier_id IN NUMBER,
620: p_supplier_site_id IN NUMBER,
621: p_org_id IN NUMBER) IS
622: SELECT COUNT(1)
623: FROM ozf_supp_trd_prfls_all
624: WHERE supplier_id = p_supplier_id
625: AND supplier_site_id = p_supplier_site_id
626: AND org_id = p_org_id;
627:

Line 665: FROM ozf_supp_trd_prfls_all

661: CURSOR c_authorization_period(p_supplier_id IN NUMBER,
662: p_supplier_site_id IN NUMBER,
663: p_org_id IN NUMBER)IS
664: SELECT NVL(authorization_period,-1)
665: FROM ozf_supp_trd_prfls_all
666: WHERE supplier_id = p_supplier_id
667: AND supplier_site_id = p_supplier_site_id
668: AND org_id = p_org_id;
669:

Line 1322: FROM ozf_supp_trd_prfls_all otrpf

1318: CURSOR c_cost_basis(p_supplier_id IN NUMBER
1319: ,p_supplier_site_id IN NUMBER
1320: ,p_org_id IN NUMBER)IS
1321: SELECT claim_computation_basis
1322: FROM ozf_supp_trd_prfls_all otrpf
1323: WHERE supplier_id = p_supplier_id
1324: AND supplier_site_id = p_supplier_site_id
1325: AND org_id = p_org_id;
1326:

Line 1331: FROM ozf_supp_trd_prfls_all

1327: CURSOR c_qty_increase_tolerance(p_supplier_id IN NUMBER
1328: ,p_supplier_site_id IN NUMBER
1329: ,p_org_id IN NUMBER)IS
1330: SELECT NVL(qty_increase_tolerance,0)
1331: FROM ozf_supp_trd_prfls_all
1332: WHERE supplier_id = p_supplier_id
1333: AND supplier_site_id = p_supplier_site_id
1334: AND org_id = p_org_id;
1335:

Line 1347: ozf_supp_trd_prfls_all trd_profile

1343: ,p_org_id IN NUMBER
1344: ,p_inventory_item_id IN NUMBER)IS
1345: SELECT external_code
1346: FROM ozf_supp_code_conversions_all code,
1347: ozf_supp_trd_prfls_all trd_profile
1348: WHERE code.code_conversion_type = 'OZF_PRODUCT_CODES'
1349: AND code.supp_trade_profile_id = trd_profile.supp_trade_profile_id
1350: AND trd_profile.supplier_id = p_supplier_id
1351: AND trd_profile.supplier_site_id = p_supplier_site_id

Line 1362: ozf_supp_trd_prfls_all trd_profile

1358: ,p_org_id IN NUMBER) IS
1359: SELECT external_code, --Vendor Item Code
1360: internal_code --Inventory Item ID
1361: FROM ozf_supp_code_conversions_all code,
1362: ozf_supp_trd_prfls_all trd_profile
1363: WHERE code.code_conversion_type = 'OZF_PRODUCT_CODES'
1364: AND code.supp_trade_profile_id = trd_profile.supp_trade_profile_id
1365: AND trd_profile.supplier_id = p_supplier_id
1366: AND trd_profile.supplier_site_id = p_supplier_site_id

Line 4000: FROM ozf_supp_trd_prfls_all

3996: WHERE user_status_id = p_user_status_id;
3997:
3998: CURSOR c_communication(p_supplier_id IN NUMBER,p_supplier_site_id IN NUMBER)IS
3999: SELECT request_communication
4000: FROM ozf_supp_trd_prfls_all
4001: WHERE supplier_id =p_supplier_id
4002: AND supplier_site_id =p_supplier_site_id;
4003:
4004: CURSOR c_qp_list_header_id(p_request_header_id IN NUMBER)IS

Line 5159: FROM ozf_supp_trd_prfls_all

5155: CURSOR c_authorization_period(p_supplier_id IN NUMBER,
5156: p_supplier_site_id IN NUMBER,
5157: p_org_id IN NUMBER)IS
5158: SELECT NVL(authorization_period,-1)
5159: FROM ozf_supp_trd_prfls_all
5160: WHERE supplier_id = p_supplier_id
5161: AND supplier_site_id = p_supplier_site_id
5162: AND org_id = p_org_id;
5163: