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 1054: po_vendor_sites_all pvs,

1050: po_headers_all pha,
1051: po_lines_all pla,
1052: po_line_locations_all plla,
1053: po_vendors pv,
1054: po_vendor_sites_all pvs,
1055: hr_locations_all_tl hrl,
1056: hz_locations hz
1057: where pha.segment1 = plnt.po_number
1058: and pha.org_id = plnt.org_id

Line 1139: po_vendor_sites_all pvs,

1135: po_releases_all pra,
1136: po_lines_all pla,
1137: po_line_locations_all plla,
1138: po_vendors pv,
1139: po_vendor_sites_all pvs,
1140: hr_locations_all_tl hrl,
1141: hz_locations hz
1142: where pha.segment1 = plnt.po_number
1143: and pha.org_id = plnt.org_id

Line 2876: po_vendor_sites_all pvsa

2872: l_error_ln number;
2873: cursor l_checkNotPaySite_csr is
2874: select peh.line_number
2875: from pos_exasn_headers peh,
2876: po_vendor_sites_all pvsa
2877: where pvsa.vendor_site_id = peh.vendor_site_id
2878: AND getvendorpaysiteid(peh.vendor_id,nvl(peh.vendor_site_id, -9999),peh.currency_code) IS null;
2879: --Refer the bug7338353 for more details
2880:

Line 4407: 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

4403: -- Bug 7338353
4404: --End of Comments
4405: ------------------------------------------------------------------------------
4406:
4407: 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
4408: IS
4409: --Local Variable Declaration
4410: l_vendor_site_id PO_VENDOR_SITES_ALL.vendor_site_id%type:=0;
4411: l_DEFAULT_PAY_SITE_ID PO_VENDOR_SITES_ALL.default_pay_site_id%type;

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

4406:
4407: 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
4408: IS
4409: --Local Variable Declaration
4410: l_vendor_site_id PO_VENDOR_SITES_ALL.vendor_site_id%type:=0;
4411: l_DEFAULT_PAY_SITE_ID PO_VENDOR_SITES_ALL.default_pay_site_id%type;
4412: l_org_id PO_VENDOR_SITES_ALL.default_pay_site_id%type;
4413:
4414: BEGIN

Line 4411: l_DEFAULT_PAY_SITE_ID PO_VENDOR_SITES_ALL.default_pay_site_id%type;

4407: 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
4408: IS
4409: --Local Variable Declaration
4410: l_vendor_site_id PO_VENDOR_SITES_ALL.vendor_site_id%type:=0;
4411: l_DEFAULT_PAY_SITE_ID PO_VENDOR_SITES_ALL.default_pay_site_id%type;
4412: l_org_id PO_VENDOR_SITES_ALL.default_pay_site_id%type;
4413:
4414: BEGIN
4415:

Line 4412: l_org_id PO_VENDOR_SITES_ALL.default_pay_site_id%type;

4408: IS
4409: --Local Variable Declaration
4410: l_vendor_site_id PO_VENDOR_SITES_ALL.vendor_site_id%type:=0;
4411: l_DEFAULT_PAY_SITE_ID PO_VENDOR_SITES_ALL.default_pay_site_id%type;
4412: l_org_id PO_VENDOR_SITES_ALL.default_pay_site_id%type;
4413:
4414: BEGIN
4415:
4416: -- Getting the org id of the vendor site

Line 4419: FROM po_vendor_sites_all

4415:
4416: -- Getting the org id of the vendor site
4417: SELECT org_id
4418: INTO l_org_id
4419: FROM po_vendor_sites_all
4420: WHERE vendor_site_id= p_vendor_site_id;
4421:
4422: -- Check for primary paysite exists
4423: BEGIN

Line 4426: from PO_VENDOR_SITES_ALL PVS

4422: -- Check for primary paysite exists
4423: BEGIN
4424: select vendor_site_id
4425: into l_vendor_site_id
4426: from PO_VENDOR_SITES_ALL PVS
4427: where
4428: SYSDATE < NVL(PVS.INACTIVE_DATE, SYSDATE+1)
4429: AND PVS.org_id = l_org_id
4430: AND PVS.vendor_id = p_vendor_id

Line 4441: from PO_VENDOR_SITES_ALL PVS

4437: BEGIN
4438:
4439: select vendor_site_id
4440: into l_vendor_site_id
4441: from PO_VENDOR_SITES_ALL PVS
4442: WHERE
4443: SYSDATE < NVL(PVS.INACTIVE_DATE, SYSDATE+1)
4444: AND PVS.org_id = l_org_id
4445: AND PVS.vendor_id = p_vendor_id

Line 4456: from PO_VENDOR_SITES_ALL PVS

4452: BEGIN
4453: --if the purchasing site is not a pay site, then check whether it has default pay site
4454: select default_pay_site_id
4455: into l_DEFAULT_PAY_SITE_ID
4456: from PO_VENDOR_SITES_ALL PVS
4457: where PVS.org_id = l_org_id
4458: AND PVS.vendor_id = p_vendor_id
4459: AND PVS.vendor_site_id = p_vendor_site_id
4460: AND ROWNUM=1;

Line 4472: from PO_VENDOR_SITES_ALL PVS

4468: BEGIN
4469: --If it has default paysite, then check default paysite id is paysite or not
4470: select vendor_site_id
4471: into l_vendor_site_id
4472: from PO_VENDOR_SITES_ALL PVS
4473: where org_id = l_org_id
4474: AND PVS.vendor_id = p_vendor_id
4475: AND PVS.vendor_site_id = l_DEFAULT_PAY_SITE_ID
4476: AND PVS.pay_site_flag = 'Y'

Line 4504: PO_VENDOR_SITES_ALL PVS

4500: FROM
4501: AP_BANK_ACCOUNT_USES_ALL ABAU,
4502: AP_BANK_ACCOUNTS_ALL ABA,
4503: AP_BANK_BRANCHES ABB,
4504: PO_VENDOR_SITES_ALL PVS
4505: WHERE
4506: ABAU.EXTERNAL_BANK_ACCOUNT_ID = ABA.BANK_ACCOUNT_ID(+) AND
4507: ABA.BANK_BRANCH_ID = ABB.BANK_BRANCH_ID(+) AND
4508: ABAU.VENDOR_ID(+) = PVS.VENDOR_ID AND

Line 4524: PO_VENDOR_SITES_ALL PVS

4520: PVS.VENDOR_SITE_CODE,
4521: PVS.PAYMENT_METHOD_LOOKUP_CODE,
4522: NVL(PVS.ORG_ID, -99) ORG_ID
4523: FROM
4524: PO_VENDOR_SITES_ALL PVS
4525: WHERE
4526: SYSDATE < NVL(PVS.INACTIVE_DATE, SYSDATE+1)
4527: AND NVL(PVS.PAY_SITE_FLAG, 'N') = 'Y' AND
4528: PVS.PAYMENT_METHOD_LOOKUP_CODE <> 'EFT') QRSLT WHERE (ORG_ID = NVL(l_org_id, -99) AND VENDOR_ID = p_vendor_id AND