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.OE_VALIDATE_LINE dependencies on HZ_CUST_ACCOUNTS

Line 2321: AND EXISTS(SELECT 1 FROM HZ_CUST_ACCOUNTS WHERE CUST_ACCOUNT_ID = ACCT_SITE.CUST_ACCOUNT_ID AND STATUS='A')

2317: RELATED_CUST_ACCOUNT_ID = p_sold_to_org_id
2318: and h.org_id=acct_site.org_id
2319: and ship_to_flag = 'Y' and status = 'A')
2320: --bug 4205113
2321: AND EXISTS(SELECT 1 FROM HZ_CUST_ACCOUNTS WHERE CUST_ACCOUNT_ID = ACCT_SITE.CUST_ACCOUNT_ID AND STATUS='A')
2322: AND ROWNUM = 1;
2323: RETURN TRUE;
2324: ELSIF lcustomer_relations = 'A' THEN
2325: SELECT 'VALID'

Line 2403: AND EXISTS(SELECT 1 FROM HZ_CUST_ACCOUNTS WHERE CUST_ACCOUNT_ID = ACCT_SITE.CUST_ACCOUNT_ID AND STATUS='A')

2399: RELATED_CUST_ACCOUNT_ID = p_sold_to_org_id
2400: and h.org_id=acct_site.org_id
2401: and ship_to_flag = 'Y' and status='A')
2402: -- bug 4205113
2403: AND EXISTS(SELECT 1 FROM HZ_CUST_ACCOUNTS WHERE CUST_ACCOUNT_ID = ACCT_SITE.CUST_ACCOUNT_ID AND STATUS='A')
2404: AND ROWNUM = 1;
2405: IF l_debug_level > 0 then
2406: oe_debug_pub.add('Exiting OE_VALIDATE_LINE.Validate_Deliver_To_Org',1);
2407: END IF;

Line 3779: l_ship_to_cust_Acct_id hz_cust_Accounts.cust_Account_id%type;

3775: l_ordered_quantity NUMBER;
3776: l_cancelled_quantity NUMBER;
3777:
3778: -- eBTax Changes
3779: l_ship_to_cust_Acct_id hz_cust_Accounts.cust_Account_id%type;
3780: l_ship_to_party_id hz_cust_accounts.party_id%type;
3781: l_ship_to_party_site_id hz_party_sites.party_site_id%type;
3782: l_bill_to_cust_Acct_id hz_cust_Accounts.cust_Account_id%type;
3783: l_bill_to_party_id hz_cust_accounts.party_id%type;

Line 3780: l_ship_to_party_id hz_cust_accounts.party_id%type;

3776: l_cancelled_quantity NUMBER;
3777:
3778: -- eBTax Changes
3779: l_ship_to_cust_Acct_id hz_cust_Accounts.cust_Account_id%type;
3780: l_ship_to_party_id hz_cust_accounts.party_id%type;
3781: l_ship_to_party_site_id hz_party_sites.party_site_id%type;
3782: l_bill_to_cust_Acct_id hz_cust_Accounts.cust_Account_id%type;
3783: l_bill_to_party_id hz_cust_accounts.party_id%type;
3784: l_bill_to_party_site_id hz_party_sites.party_site_id%type;

Line 3782: l_bill_to_cust_Acct_id hz_cust_Accounts.cust_Account_id%type;

3778: -- eBTax Changes
3779: l_ship_to_cust_Acct_id hz_cust_Accounts.cust_Account_id%type;
3780: l_ship_to_party_id hz_cust_accounts.party_id%type;
3781: l_ship_to_party_site_id hz_party_sites.party_site_id%type;
3782: l_bill_to_cust_Acct_id hz_cust_Accounts.cust_Account_id%type;
3783: l_bill_to_party_id hz_cust_accounts.party_id%type;
3784: l_bill_to_party_site_id hz_party_sites.party_site_id%type;
3785: l_org_id NUMBER;
3786: -- l_legal_entity_id NUMBER;

Line 3783: l_bill_to_party_id hz_cust_accounts.party_id%type;

3779: l_ship_to_cust_Acct_id hz_cust_Accounts.cust_Account_id%type;
3780: l_ship_to_party_id hz_cust_accounts.party_id%type;
3781: l_ship_to_party_site_id hz_party_sites.party_site_id%type;
3782: l_bill_to_cust_Acct_id hz_cust_Accounts.cust_Account_id%type;
3783: l_bill_to_party_id hz_cust_accounts.party_id%type;
3784: l_bill_to_party_site_id hz_party_sites.party_site_id%type;
3785: l_org_id NUMBER;
3786: -- l_legal_entity_id NUMBER;
3787:

Line 3796: HZ_CUST_ACCOUNTS_ALL cust_Acct

3792: site_use.org_id
3793: FROM
3794: HZ_CUST_SITE_USES_ALL site_use,
3795: HZ_CUST_ACCT_SITES_ALL acct_site,
3796: HZ_CUST_ACCOUNTS_ALL cust_Acct
3797: WHERE site_use.site_use_id = p_site_org_id
3798: AND site_use.cust_acct_site_id = acct_site.cust_acct_site_id
3799: and acct_site.cust_account_id = cust_acct.cust_account_id;
3800:

Line 5523: AND EXISTS(SELECT 1 FROM HZ_CUST_ACCOUNTS WHERE CUST_ACCOUNT_ID = ACCT_SITE.CUST_ACCOUNT_ID AND STATUS='A')

5519: RELATED_CUST_ACCOUNT_ID = p_line_rec.sold_to_org_id
5520: and h.org_id=acct_site.org_id
5521: and bill_to_flag = 'Y' and status='A')
5522: --bug 4205113
5523: AND EXISTS(SELECT 1 FROM HZ_CUST_ACCOUNTS WHERE CUST_ACCOUNT_ID = ACCT_SITE.CUST_ACCOUNT_ID AND STATUS='A')
5524: AND ROWNUM = 1;
5525: END IF;
5526:
5527: EXCEPTION