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_HEADER dependencies on HZ_CUST_ACCOUNTS

Line 936: l_ship_to_cust_Acct_id hz_cust_Accounts.cust_Account_id%type;

932: l_old_header_rec OE_Order_PUB.Header_Rec_Type := p_old_header_rec;
933: /* Added the above 3 line to fix the bug 2824240 */
934:
935: -- eBTax Changes
936: l_ship_to_cust_Acct_id hz_cust_Accounts.cust_Account_id%type;
937: l_ship_to_party_id hz_cust_accounts.party_id%type;
938: l_ship_to_party_site_id hz_party_sites.party_site_id%type;
939: l_bill_to_cust_Acct_id hz_cust_Accounts.cust_Account_id%type;
940: l_bill_to_party_id hz_cust_accounts.party_id%type;

Line 937: l_ship_to_party_id hz_cust_accounts.party_id%type;

933: /* Added the above 3 line to fix the bug 2824240 */
934:
935: -- eBTax Changes
936: l_ship_to_cust_Acct_id hz_cust_Accounts.cust_Account_id%type;
937: l_ship_to_party_id hz_cust_accounts.party_id%type;
938: l_ship_to_party_site_id hz_party_sites.party_site_id%type;
939: l_bill_to_cust_Acct_id hz_cust_Accounts.cust_Account_id%type;
940: l_bill_to_party_id hz_cust_accounts.party_id%type;
941: l_bill_to_party_site_id hz_party_sites.party_site_id%type;

Line 939: l_bill_to_cust_Acct_id hz_cust_Accounts.cust_Account_id%type;

935: -- eBTax Changes
936: l_ship_to_cust_Acct_id hz_cust_Accounts.cust_Account_id%type;
937: l_ship_to_party_id hz_cust_accounts.party_id%type;
938: l_ship_to_party_site_id hz_party_sites.party_site_id%type;
939: l_bill_to_cust_Acct_id hz_cust_Accounts.cust_Account_id%type;
940: l_bill_to_party_id hz_cust_accounts.party_id%type;
941: l_bill_to_party_site_id hz_party_sites.party_site_id%type;
942: l_org_id NUMBER;
943:

Line 940: l_bill_to_party_id hz_cust_accounts.party_id%type;

936: l_ship_to_cust_Acct_id hz_cust_Accounts.cust_Account_id%type;
937: l_ship_to_party_id hz_cust_accounts.party_id%type;
938: l_ship_to_party_site_id hz_party_sites.party_site_id%type;
939: l_bill_to_cust_Acct_id hz_cust_Accounts.cust_Account_id%type;
940: l_bill_to_party_id hz_cust_accounts.party_id%type;
941: l_bill_to_party_site_id hz_party_sites.party_site_id%type;
942: l_org_id NUMBER;
943:
944: cursor partyinfo(p_site_org_id HZ_CUST_SITE_USES_ALL.SITE_USE_ID%type) is

Line 952: HZ_CUST_ACCOUNTS_ALL cust_Acct

948: site_use.org_id
949: FROM
950: HZ_CUST_SITE_USES_ALL site_use,
951: HZ_CUST_ACCT_SITES_ALL acct_site,
952: HZ_CUST_ACCOUNTS_ALL cust_Acct
953: WHERE site_use.site_use_id = p_site_org_id
954: AND site_use.cust_acct_site_id = acct_site.cust_acct_site_id
955: and acct_site.cust_account_id = cust_acct.cust_account_id;
956:

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

1624: RELATED_CUST_ACCOUNT_ID = p_header_rec.sold_to_org_id
1625: and h.org_id =acct_site.org_id
1626: and ship_to_flag = 'Y' and status = 'A')
1627: --bug 4205113
1628: AND EXISTS(SELECT 1 FROM HZ_CUST_ACCOUNTS WHERE CUST_ACCOUNT_ID = ACCT_SITE.CUST_ACCOUNT_ID AND STATUS='A')
1629: AND ROWNUM = 1;
1630: oe_debug_pub.add
1631: ('Cr: Yes- After the select',2);
1632: ELSIF lcustomer_relations = 'A' THEN

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

1720: RELATED_CUST_ACCOUNT_ID = p_header_rec.sold_to_org_id
1721: and h.org_id =acct_site.org_id
1722: and ship_to_flag = 'Y' and status='A')
1723: --bug 4205113
1724: AND EXISTS(SELECT 1 FROM HZ_CUST_ACCOUNTS WHERE CUST_ACCOUNT_ID = ACCT_SITE.CUST_ACCOUNT_ID AND STATUS='A')
1725: AND ROWNUM = 1;
1726: oe_debug_pub.add('Cr: Yes- After the select',2);
1727:
1728: ELSIF lcustomer_relations = 'A' THEN

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

1818: RELATED_CUST_ACCOUNT_ID = p_header_rec.sold_to_org_id
1819: and h.org_id =site.org_id
1820: and bill_to_flag = 'Y' and status='A' )
1821: --bug 4205113
1822: AND EXISTS(SELECT 1 FROM HZ_CUST_ACCOUNTS WHERE CUST_ACCOUNT_ID = ACCT_SITE.CUST_ACCOUNT_ID AND STATUS='A')
1823: AND ROWNUM = 1;
1824: END IF;
1825:
1826:

Line 2422: hz_cust_accounts cust_acct

2418: BEGIN
2419: SELECT party.party_name
2420: INTO l_customer_name
2421: FROM hz_parties party,
2422: hz_cust_accounts cust_acct
2423: WHERE cust_acct.cust_account_id = p_header_rec.sold_to_org_id
2424: AND cust_acct.party_id = party.party_id;
2425:
2426: EXCEPTION WHEN NO_DATA_FOUND THEN