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.AP_VENDOR_PUB_PKG dependencies on FINANCIALS_SYSTEM_PARAMS_ALL

Line 1949: l_rfq_only_site FINANCIALS_SYSTEM_PARAMS_ALL.rfq_only_site_flag%TYPE;

1945: p_country_code IN OUT NOCOPY VARCHAR2,
1946: p_ship_via_lookup_code IN OUT NOCOPY VARCHAR2
1947: ) IS
1948:
1949: l_rfq_only_site FINANCIALS_SYSTEM_PARAMS_ALL.rfq_only_site_flag%TYPE;
1950: l_accts_pay_ccid FINANCIALS_SYSTEM_PARAMS_ALL.accts_pay_code_combination_id%TYPE;
1951: l_prepay_ccid FINANCIALS_SYSTEM_PARAMS_ALL.prepay_code_combination_id%TYPE;
1952: l_future_pay_ccid FINANCIALS_SYSTEM_PARAMS_ALL.future_dated_payment_ccid%TYPE;
1953: l_home_country_code FINANCIALS_SYSTEM_PARAMS_ALL.vat_country_code%TYPE;

Line 1950: l_accts_pay_ccid FINANCIALS_SYSTEM_PARAMS_ALL.accts_pay_code_combination_id%TYPE;

1946: p_ship_via_lookup_code IN OUT NOCOPY VARCHAR2
1947: ) IS
1948:
1949: l_rfq_only_site FINANCIALS_SYSTEM_PARAMS_ALL.rfq_only_site_flag%TYPE;
1950: l_accts_pay_ccid FINANCIALS_SYSTEM_PARAMS_ALL.accts_pay_code_combination_id%TYPE;
1951: l_prepay_ccid FINANCIALS_SYSTEM_PARAMS_ALL.prepay_code_combination_id%TYPE;
1952: l_future_pay_ccid FINANCIALS_SYSTEM_PARAMS_ALL.future_dated_payment_ccid%TYPE;
1953: l_home_country_code FINANCIALS_SYSTEM_PARAMS_ALL.vat_country_code%TYPE;
1954: l_default_country_code FINANCIALS_SYSTEM_PARAMS_ALL.vat_country_code%TYPE;

Line 1951: l_prepay_ccid FINANCIALS_SYSTEM_PARAMS_ALL.prepay_code_combination_id%TYPE;

1947: ) IS
1948:
1949: l_rfq_only_site FINANCIALS_SYSTEM_PARAMS_ALL.rfq_only_site_flag%TYPE;
1950: l_accts_pay_ccid FINANCIALS_SYSTEM_PARAMS_ALL.accts_pay_code_combination_id%TYPE;
1951: l_prepay_ccid FINANCIALS_SYSTEM_PARAMS_ALL.prepay_code_combination_id%TYPE;
1952: l_future_pay_ccid FINANCIALS_SYSTEM_PARAMS_ALL.future_dated_payment_ccid%TYPE;
1953: l_home_country_code FINANCIALS_SYSTEM_PARAMS_ALL.vat_country_code%TYPE;
1954: l_default_country_code FINANCIALS_SYSTEM_PARAMS_ALL.vat_country_code%TYPE;
1955:

Line 1952: l_future_pay_ccid FINANCIALS_SYSTEM_PARAMS_ALL.future_dated_payment_ccid%TYPE;

1948:
1949: l_rfq_only_site FINANCIALS_SYSTEM_PARAMS_ALL.rfq_only_site_flag%TYPE;
1950: l_accts_pay_ccid FINANCIALS_SYSTEM_PARAMS_ALL.accts_pay_code_combination_id%TYPE;
1951: l_prepay_ccid FINANCIALS_SYSTEM_PARAMS_ALL.prepay_code_combination_id%TYPE;
1952: l_future_pay_ccid FINANCIALS_SYSTEM_PARAMS_ALL.future_dated_payment_ccid%TYPE;
1953: l_home_country_code FINANCIALS_SYSTEM_PARAMS_ALL.vat_country_code%TYPE;
1954: l_default_country_code FINANCIALS_SYSTEM_PARAMS_ALL.vat_country_code%TYPE;
1955:
1956: BEGIN

Line 1953: l_home_country_code FINANCIALS_SYSTEM_PARAMS_ALL.vat_country_code%TYPE;

1949: l_rfq_only_site FINANCIALS_SYSTEM_PARAMS_ALL.rfq_only_site_flag%TYPE;
1950: l_accts_pay_ccid FINANCIALS_SYSTEM_PARAMS_ALL.accts_pay_code_combination_id%TYPE;
1951: l_prepay_ccid FINANCIALS_SYSTEM_PARAMS_ALL.prepay_code_combination_id%TYPE;
1952: l_future_pay_ccid FINANCIALS_SYSTEM_PARAMS_ALL.future_dated_payment_ccid%TYPE;
1953: l_home_country_code FINANCIALS_SYSTEM_PARAMS_ALL.vat_country_code%TYPE;
1954: l_default_country_code FINANCIALS_SYSTEM_PARAMS_ALL.vat_country_code%TYPE;
1955:
1956: BEGIN
1957:

Line 1954: l_default_country_code FINANCIALS_SYSTEM_PARAMS_ALL.vat_country_code%TYPE;

1950: l_accts_pay_ccid FINANCIALS_SYSTEM_PARAMS_ALL.accts_pay_code_combination_id%TYPE;
1951: l_prepay_ccid FINANCIALS_SYSTEM_PARAMS_ALL.prepay_code_combination_id%TYPE;
1952: l_future_pay_ccid FINANCIALS_SYSTEM_PARAMS_ALL.future_dated_payment_ccid%TYPE;
1953: l_home_country_code FINANCIALS_SYSTEM_PARAMS_ALL.vat_country_code%TYPE;
1954: l_default_country_code FINANCIALS_SYSTEM_PARAMS_ALL.vat_country_code%TYPE;
1955:
1956: BEGIN
1957:
1958: SELECT FIN.rfq_only_site_flag,

Line 1970: FROM FINANCIALS_SYSTEM_PARAMS_ALL FIN,

1966: l_prepay_ccid,
1967: l_future_pay_ccid,
1968: l_home_country_code,
1969: p_ship_via_lookup_code
1970: FROM FINANCIALS_SYSTEM_PARAMS_ALL FIN,
1971: HR_OPERATING_UNITS HR
1972: WHERE HR.organization_id = FIN.org_id
1973: AND ( HR.name = p_org_name OR
1974: HR.organization_id = p_org_id);

Line 2335: FROM org_freight FRT, financials_system_params_all FIN

2331: x_valid := TRUE;
2332:
2333: SELECT FRT.freight_code
2334: INTO l_dummy
2335: FROM org_freight FRT, financials_system_params_all FIN
2336: WHERE FRT.organization_id = FIN.inventory_organization_id
2337: AND FIN.org_id = p_org_id
2338: AND nvl(FRT.disable_date, sysdate +1 ) > sysdate
2339: AND FRT.freight_code = p_ship_via_lookup_code;

Line 4459: FROM FINANCIALS_SYSTEM_PARAMS_ALL FIN,

4455:
4456: /*
4457: SELECT FIN.vat_country_code
4458: INTO l_default_country_code
4459: FROM FINANCIALS_SYSTEM_PARAMS_ALL FIN,
4460: AP_SYSTEM_PARAMETERS_ALL ASP
4461: WHERE ASP.set_of_books_id=p_vendor_rec.set_of_books_id
4462: AND FIN.org_id = ASP.org_id;
4463: */