APPS.OZF_SD_BATCH_PVT dependencies on OZF_SUPP_TRD_PRFLS_ALL

Line 278: FROM OZF_SUPP_CODE_CONVERSIONS_ALL code, OZF_SUPP_TRD_PRFLS_ALL prf

274: l_internal_code := p_product_id;
275:
276: SELECT code.external_code
277: INTO l_vendor_product_id
278: FROM OZF_SUPP_CODE_CONVERSIONS_ALL code, OZF_SUPP_TRD_PRFLS_ALL prf
279: WHERE internal_code = l_internal_code and
280: code.supp_trade_profile_id = prf.supp_trade_profile_id and
281: prf.supplier_site_id = p_supplier_site_id and
282: trunc(sysdate) between code.start_date_active and

Line 610: ozf_supp_trd_prfls_all trprf

606: --org id Code added for bug#6867618
607: CURSOR get_sites(c_vendor_id NUMBER,c_org_id NUMBER) IS
608: SELECT sites.vendor_site_id
609: FROM ap_supplier_sites_all sites,
610: ozf_supp_trd_prfls_all trprf
611: WHERE sites.vendor_id = c_vendor_id AND
612: sites.org_id = c_org_id AND
613: nvl(sites.inactive_date, sysdate) >= trunc(sysdate) AND
614: trprf.cust_account_id is not null AND

Line 620: FROM ozf_supp_trd_prfls_all

616: sites.vendor_site_id=trprf.supplier_site_id;
617:
618: CURSOR trade_profile_values(c_supplier_site_id NUMBER,c_org_id NUMBER) IS
619: SELECT claim_currency_code
620: FROM ozf_supp_trd_prfls_all
621: WHERE supplier_site_id = c_supplier_site_id AND
622: org_id = c_org_id;
623:
624: CURSOR get_freq_and_date(c_supplier_site_id NUMBER,c_org_id NUMBER) IS

Line 626: FROM ozf_supp_trd_prfls_all

622: org_id = c_org_id;
623:
624: CURSOR get_freq_and_date(c_supplier_site_id NUMBER,c_org_id NUMBER) IS
625: SELECT claim_frequency, claim_frequency_unit, last_paid_date
626: FROM ozf_supp_trd_prfls_all
627: WHERE supplier_site_id = c_supplier_site_id AND
628: org_id = c_org_id;
629:
630: BEGIN

Line 690: l_query := 'SELECT claim_currency_code FROM OZF_SUPP_TRD_PRFLS_ALL ' ||

686: l_query := 'SELECT distinct request_currency_code FROM OZF_SD_REQUEST_HEADERS_ALL_B ' ||
687: ' WHERE supplier_id=' || p_supplier_id ||
688: ' AND supplier_site_id=' || p_supplier_site_id;
689: ELSE
690: l_query := 'SELECT claim_currency_code FROM OZF_SUPP_TRD_PRFLS_ALL ' ||
691: ' WHERE supplier_site_id =' || p_supplier_site_id;
692:
693: END IF;
694:

Line 796: UPDATE ozf_supp_trd_prfls_all

792: CLOSE c_currency;
793: -- after currency loop
794: -- IF l_empty_batch = 'N' THEN
795:
796: UPDATE ozf_supp_trd_prfls_all
797: SET last_paid_date = sysdate
798: WHERE supplier_site_id = l_supplier_site_id;
799:
800: IF fnd_api.To_Boolean(p_commit) THEN

Line 844: l_query := 'SELECT claim_currency_code FROM OZF_SUPP_TRD_PRFLS_ALL ' ||

840: --Code added for bug#6867618
841: l_query := 'SELECT distinct request_currency_code FROM OZF_SD_REQUEST_HEADERS_ALL_B ' ||
842: ' WHERE supplier_site_id=' || site_rec.vendor_site_id;
843: ELSE
844: l_query := 'SELECT claim_currency_code FROM OZF_SUPP_TRD_PRFLS_ALL ' ||
845: ' WHERE supplier_site_id =' || site_rec.vendor_site_id;
846:
847: END IF;
848:

Line 936: UPDATE ozf_supp_trd_prfls_all

932: END IF;
933:
934: END LOOP;
935:
936: UPDATE ozf_supp_trd_prfls_all
937: SET last_paid_date = sysdate
938: WHERE supplier_site_id = l_supplier_site_id;
939:
940: IF fnd_api.To_Boolean(p_commit) THEN

Line 1025: FROM ozf_supp_trd_prfls_all

1021: p_batch_type IN VARCHAR2) is
1022:
1023: CURSOR trade_profile_values(c_supplier_site_id NUMBER) IS
1024: SELECT min_claim_amt, min_claim_amt_line_lvl, auto_debit
1025: FROM ozf_supp_trd_prfls_all
1026: WHERE supplier_site_id = c_supplier_site_id;
1027:
1028: l_batch_id NUMBER;
1029: l_empty_batch VARCHAR2(15) := 'Y';

Line 1469: from OZF_SUPP_TRD_PRFLS_ALL

1465:
1466: -- added for ER 13245462
1467: CURSOR stp_partial_appr_flag (c_supplier_site_id NUMBER,c_org_id NUMBER) IS
1468: select SSD_IMD_CLAIM_FLAG
1469: from OZF_SUPP_TRD_PRFLS_ALL
1470: where supplier_site_id = c_supplier_site_id
1471: and org_id = c_org_id;
1472:
1473: -- added for ER 13245462

Line 3411: FROM ozf_supp_trd_prfls_all

3407: p_vendor_site_id NUMBER) is
3408:
3409: CURSOR get_freq_and_date(c_supplier_site_id NUMBER) IS
3410: SELECT days_before_claiming_debit
3411: FROM ozf_supp_trd_prfls_all
3412: WHERE supplier_site_id = c_supplier_site_id;
3413:
3414: l_claim_id NUMBER := NULL; -- Incase auto claim is run
3415: l_claim_ret_status VARCHAR2(15) := NULL;

Line 3695: ozf_supp_trd_prfls_all trprf

3691:
3692: CURSOR get_supplier_sites(c_org_id NUMBER,c_vendor_id NUMBER,c_vendor_site_id NUMBER) IS
3693: SELECT sites.vendor_id, sites.vendor_site_id
3694: FROM ap_supplier_sites_all sites,
3695: ozf_supp_trd_prfls_all trprf
3696: WHERE sites.org_id = NVL(c_org_id,sites.org_id) AND
3697: sites.vendor_id = NVL(c_vendor_id,sites.vendor_id) AND
3698: sites.vendor_site_id = NVL(c_vendor_site_id,sites.vendor_site_id) AND
3699: nvl(sites.inactive_date, sysdate) >= trunc(sysdate) AND