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 967: l_ship_to_cust_Acct_id hz_cust_Accounts.cust_Account_id%type;

963: l_old_header_rec OE_Order_PUB.Header_Rec_Type := p_old_header_rec;
964: /* Added the above 3 line to fix the bug 2824240 */
965:
966: -- eBTax Changes
967: l_ship_to_cust_Acct_id hz_cust_Accounts.cust_Account_id%type;
968: l_ship_to_party_id hz_cust_accounts.party_id%type;
969: l_ship_to_party_site_id hz_party_sites.party_site_id%type;
970: l_bill_to_cust_Acct_id hz_cust_Accounts.cust_Account_id%type;
971: l_bill_to_party_id hz_cust_accounts.party_id%type;

Line 968: l_ship_to_party_id hz_cust_accounts.party_id%type;

964: /* Added the above 3 line to fix the bug 2824240 */
965:
966: -- eBTax Changes
967: l_ship_to_cust_Acct_id hz_cust_Accounts.cust_Account_id%type;
968: l_ship_to_party_id hz_cust_accounts.party_id%type;
969: l_ship_to_party_site_id hz_party_sites.party_site_id%type;
970: l_bill_to_cust_Acct_id hz_cust_Accounts.cust_Account_id%type;
971: l_bill_to_party_id hz_cust_accounts.party_id%type;
972: l_bill_to_party_site_id hz_party_sites.party_site_id%type;

Line 970: l_bill_to_cust_Acct_id hz_cust_Accounts.cust_Account_id%type;

966: -- eBTax Changes
967: l_ship_to_cust_Acct_id hz_cust_Accounts.cust_Account_id%type;
968: l_ship_to_party_id hz_cust_accounts.party_id%type;
969: l_ship_to_party_site_id hz_party_sites.party_site_id%type;
970: l_bill_to_cust_Acct_id hz_cust_Accounts.cust_Account_id%type;
971: l_bill_to_party_id hz_cust_accounts.party_id%type;
972: l_bill_to_party_site_id hz_party_sites.party_site_id%type;
973: l_org_id NUMBER;
974:

Line 971: l_bill_to_party_id hz_cust_accounts.party_id%type;

967: l_ship_to_cust_Acct_id hz_cust_Accounts.cust_Account_id%type;
968: l_ship_to_party_id hz_cust_accounts.party_id%type;
969: l_ship_to_party_site_id hz_party_sites.party_site_id%type;
970: l_bill_to_cust_Acct_id hz_cust_Accounts.cust_Account_id%type;
971: l_bill_to_party_id hz_cust_accounts.party_id%type;
972: l_bill_to_party_site_id hz_party_sites.party_site_id%type;
973: l_org_id NUMBER;
974:
975: cursor partyinfo(p_site_org_id HZ_CUST_SITE_USES_ALL.SITE_USE_ID%type) is

Line 983: HZ_CUST_ACCOUNTS_ALL cust_Acct

979: site_use.org_id
980: FROM
981: HZ_CUST_SITE_USES_ALL site_use,
982: HZ_CUST_ACCT_SITES_ALL acct_site,
983: HZ_CUST_ACCOUNTS_ALL cust_Acct
984: WHERE site_use.site_use_id = p_site_org_id
985: AND site_use.cust_acct_site_id = acct_site.cust_acct_site_id
986: and acct_site.cust_account_id = cust_acct.cust_account_id;
987:

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

1692: RELATED_CUST_ACCOUNT_ID = p_header_rec.sold_to_org_id
1693: and h.org_id =acct_site.org_id
1694: and ship_to_flag = 'Y' and status = 'A')
1695: --bug 4205113
1696: AND EXISTS(SELECT 1 FROM HZ_CUST_ACCOUNTS WHERE CUST_ACCOUNT_ID = ACCT_SITE.CUST_ACCOUNT_ID AND STATUS='A')
1697: AND ROWNUM = 1;
1698: oe_debug_pub.add
1699: ('Cr: Yes- After the select',2);
1700: ELSIF lcustomer_relations = 'A' THEN

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

1788: RELATED_CUST_ACCOUNT_ID = p_header_rec.sold_to_org_id
1789: and h.org_id =acct_site.org_id
1790: and ship_to_flag = 'Y' and status='A')
1791: --bug 4205113
1792: AND EXISTS(SELECT 1 FROM HZ_CUST_ACCOUNTS WHERE CUST_ACCOUNT_ID = ACCT_SITE.CUST_ACCOUNT_ID AND STATUS='A')
1793: AND ROWNUM = 1;
1794: oe_debug_pub.add('Cr: Yes- After the select',2);
1795:
1796: ELSIF lcustomer_relations = 'A' THEN

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

1886: RELATED_CUST_ACCOUNT_ID = p_header_rec.sold_to_org_id
1887: and h.org_id =site.org_id
1888: and bill_to_flag = 'Y' and status='A' )
1889: --bug 4205113
1890: AND EXISTS(SELECT 1 FROM HZ_CUST_ACCOUNTS WHERE CUST_ACCOUNT_ID = ACCT_SITE.CUST_ACCOUNT_ID AND STATUS='A')
1891: AND ROWNUM = 1;
1892: END IF;
1893:
1894:

Line 2491: hz_cust_accounts cust_acct

2487: BEGIN
2488: SELECT party.party_name
2489: INTO l_customer_name
2490: FROM hz_parties party,
2491: hz_cust_accounts cust_acct
2492: WHERE cust_acct.cust_account_id = p_header_rec.sold_to_org_id
2493: AND cust_acct.party_id = party.party_id;
2494:
2495: EXCEPTION WHEN NO_DATA_FOUND THEN