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.POS_EXCELASN_PVT dependencies on PO_VENDOR_SITES_ALL

Line 1071: po_vendor_sites_all pvs,

1067: po_headers_all pha,
1068: po_lines_all pla,
1069: po_line_locations_all plla,
1070: po_vendors pv,
1071: po_vendor_sites_all pvs,
1072: hr_locations_all_tl hrl,
1073: hz_locations hz
1074: where pha.segment1 = plnt.po_number
1075: and pha.org_id = plnt.org_id

Line 1175: po_vendor_sites_all pvs,

1171: po_releases_all pra,
1172: po_lines_all pla,
1173: po_line_locations_all plla,
1174: po_vendors pv,
1175: po_vendor_sites_all pvs,
1176: hr_locations_all_tl hrl,
1177: hz_locations hz
1178: where pha.segment1 = plnt.po_number
1179: and pha.org_id = plnt.org_id

Line 2946: po_vendor_sites_all pvsa

2942: l_error_ln number;
2943: cursor l_checkNotPaySite_csr is
2944: select peh.line_number
2945: from pos_exasn_headers peh,
2946: po_vendor_sites_all pvsa
2947: where pvsa.vendor_site_id = peh.vendor_site_id
2948: AND getvendorpaysiteid(peh.vendor_id,nvl(peh.vendor_site_id, -9999),peh.currency_code) IS null;
2949: --Refer the bug7338353 for more details
2950:

Line 4481: function getvendorpaysiteid(p_vendor_id in varchar2,p_vendor_site_id IN varchar2,p_currency_code IN varchar2) RETURN PO_VENDOR_SITES_ALL.vendor_site_id%type

4477: -- Bug 7338353
4478: --End of Comments
4479: ------------------------------------------------------------------------------
4480:
4481: function getvendorpaysiteid(p_vendor_id in varchar2,p_vendor_site_id IN varchar2,p_currency_code IN varchar2) RETURN PO_VENDOR_SITES_ALL.vendor_site_id%type
4482: IS
4483: --Local Variable Declaration
4484: l_vendor_site_id PO_VENDOR_SITES_ALL.vendor_site_id%type:=0;
4485: l_DEFAULT_PAY_SITE_ID PO_VENDOR_SITES_ALL.default_pay_site_id%type;

Line 4484: l_vendor_site_id PO_VENDOR_SITES_ALL.vendor_site_id%type:=0;

4480:
4481: function getvendorpaysiteid(p_vendor_id in varchar2,p_vendor_site_id IN varchar2,p_currency_code IN varchar2) RETURN PO_VENDOR_SITES_ALL.vendor_site_id%type
4482: IS
4483: --Local Variable Declaration
4484: l_vendor_site_id PO_VENDOR_SITES_ALL.vendor_site_id%type:=0;
4485: l_DEFAULT_PAY_SITE_ID PO_VENDOR_SITES_ALL.default_pay_site_id%type;
4486: l_org_id PO_VENDOR_SITES_ALL.default_pay_site_id%type;
4487:
4488: BEGIN

Line 4485: l_DEFAULT_PAY_SITE_ID PO_VENDOR_SITES_ALL.default_pay_site_id%type;

4481: function getvendorpaysiteid(p_vendor_id in varchar2,p_vendor_site_id IN varchar2,p_currency_code IN varchar2) RETURN PO_VENDOR_SITES_ALL.vendor_site_id%type
4482: IS
4483: --Local Variable Declaration
4484: l_vendor_site_id PO_VENDOR_SITES_ALL.vendor_site_id%type:=0;
4485: l_DEFAULT_PAY_SITE_ID PO_VENDOR_SITES_ALL.default_pay_site_id%type;
4486: l_org_id PO_VENDOR_SITES_ALL.default_pay_site_id%type;
4487:
4488: BEGIN
4489:

Line 4486: l_org_id PO_VENDOR_SITES_ALL.default_pay_site_id%type;

4482: IS
4483: --Local Variable Declaration
4484: l_vendor_site_id PO_VENDOR_SITES_ALL.vendor_site_id%type:=0;
4485: l_DEFAULT_PAY_SITE_ID PO_VENDOR_SITES_ALL.default_pay_site_id%type;
4486: l_org_id PO_VENDOR_SITES_ALL.default_pay_site_id%type;
4487:
4488: BEGIN
4489:
4490: -- Getting the org id of the vendor site

Line 4493: FROM po_vendor_sites_all

4489:
4490: -- Getting the org id of the vendor site
4491: SELECT org_id
4492: INTO l_org_id
4493: FROM po_vendor_sites_all
4494: WHERE vendor_site_id= p_vendor_site_id;
4495:
4496: -- Check for primary paysite exists
4497: BEGIN

Line 4500: from PO_VENDOR_SITES_ALL PVS

4496: -- Check for primary paysite exists
4497: BEGIN
4498: select vendor_site_id
4499: into l_vendor_site_id
4500: from PO_VENDOR_SITES_ALL PVS
4501: where
4502: SYSDATE < NVL(PVS.INACTIVE_DATE, SYSDATE+1)
4503: AND PVS.org_id = l_org_id
4504: AND PVS.vendor_id = p_vendor_id

Line 4515: from PO_VENDOR_SITES_ALL PVS

4511: BEGIN
4512:
4513: select vendor_site_id
4514: into l_vendor_site_id
4515: from PO_VENDOR_SITES_ALL PVS
4516: WHERE
4517: SYSDATE < NVL(PVS.INACTIVE_DATE, SYSDATE+1)
4518: AND PVS.org_id = l_org_id
4519: AND PVS.vendor_id = p_vendor_id

Line 4530: from PO_VENDOR_SITES_ALL PVS

4526: BEGIN
4527: --if the purchasing site is not a pay site, then check whether it has default pay site
4528: select default_pay_site_id
4529: into l_DEFAULT_PAY_SITE_ID
4530: from PO_VENDOR_SITES_ALL PVS
4531: where PVS.org_id = l_org_id
4532: AND PVS.vendor_id = p_vendor_id
4533: AND PVS.vendor_site_id = p_vendor_site_id
4534: AND ROWNUM=1;

Line 4546: from PO_VENDOR_SITES_ALL PVS

4542: BEGIN
4543: --If it has default paysite, then check default paysite id is paysite or not
4544: select vendor_site_id
4545: into l_vendor_site_id
4546: from PO_VENDOR_SITES_ALL PVS
4547: where org_id = l_org_id
4548: AND PVS.vendor_id = p_vendor_id
4549: AND PVS.vendor_site_id = l_DEFAULT_PAY_SITE_ID
4550: AND PVS.pay_site_flag = 'Y'

Line 4579: PO_VENDOR_SITES_ALL PVS

4575: FROM
4576: /* AP_BANK_ACCOUNT_USES_ALL ABAU,
4577: AP_BANK_ACCOUNTS_ALL ABA,
4578: AP_BANK_BRANCHES ABB,*/
4579: PO_VENDOR_SITES_ALL PVS
4580: /*Added for bug#13554162 */
4581: ,
4582: ap_suppliers sup,
4583: IBY_EXTERNAL_PAYEES_ALL PAYEE,

Line 4627: PO_VENDOR_SITES_ALL PVS ,

4623: /*PVS.PAYMENT_METHOD_LOOKUP_CODE,*/
4624: Nvl(PRT.PAYMENT_METHOD_CODE, PAYEE.DEFAULT_PAYMENT_METHOD_CODE) PAYMENT_METHOD_LOOKUP_CODE,
4625: NVL(PVS.ORG_ID, -99) ORG_ID
4626: FROM
4627: PO_VENDOR_SITES_ALL PVS ,
4628: ap_suppliers sup,
4629: IBY_EXTERNAL_PAYEES_ALL PAYEE,
4630: IBY_EXT_PARTY_PMT_MTHDS PRT
4631: WHERE