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_ACCT_RELATE

Line 563: FROM hz_cust_acct_relate_all hcar

559: select 'Y'
560: from ra_customer_trx ratrx
561: where ratrx.customer_trx_id = p_commitment_id
562: and exists (SELECT 1
563: FROM hz_cust_acct_relate_all hcar
564: WHERE hcar.cust_account_id = ratrx.bill_to_customer_id
565: and hcar.related_cust_account_id = p_sold_to_org_id
566: AND hcar.status = 'A'
567: and hcar.org_id = ratrx.org_id

Line 590: FROM hz_cust_acct_relate_all h

586: IN (SELECT p_sold_to_org_id
587: FROM sys.dual
588: UNION
589: SELECT cust_account_id customer_id
590: FROM hz_cust_acct_relate_all h
591: WHERE related_cust_account_id = p_sold_to_org_id
592: AND status = 'A'
593: and h.org_id = ratrx.org_id
594: AND bill_to_flag = 'Y')

Line 803: FROM HZ_CUST_ACCT_RELATE

799: if lcustomer_relations = 'Y' then
800: begin
801: SELECT 'Y'
802: INTO l_exists
803: FROM HZ_CUST_ACCT_RELATE
804: WHERE RELATED_CUST_ACCOUNT_ID = p_header_rec.sold_to_org_id
805: AND CUST_ACCOUNT_ID = l_sold_to_org_id
806: AND STATUS = 'A'
807: AND ROWNUM = 1;

Line 1582: hz_cust_acct_relate where

1578: INTO l_dummy
1579: FROM dual
1580: WHERE exists(
1581: select 'x' from
1582: hz_cust_acct_relate where
1583: related_cust_account_id = p_header_rec.sold_to_org_id
1584: and status = 'A'
1585: AND cust_account_id = l_sold_to_org
1586: );

Line 1691: HZ_CUST_ACCT_RELATE_ALL h WHERE

1687: ACCT_SITE.CUST_ACCOUNT_ID in (
1688: SELECT p_header_rec.sold_to_org_id FROM DUAL
1689: UNION
1690: SELECT CUST_ACCOUNT_ID FROM
1691: HZ_CUST_ACCT_RELATE_ALL h WHERE
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

Line 1787: HZ_CUST_ACCT_RELATE_ALL h WHERE

1783: ACCT_SITE.CUST_ACCOUNT_ID in (
1784: SELECT p_header_rec.sold_to_org_id FROM DUAL
1785: UNION
1786: SELECT CUST_ACCOUNT_ID FROM
1787: HZ_CUST_ACCT_RELATE_ALL h WHERE
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

Line 1885: HZ_CUST_ACCT_RELATE_ALL h WHERE

1881: ACCT_SITE.CUST_ACCOUNT_ID in (
1882: SELECT p_header_rec.sold_to_org_id FROM DUAL
1883: UNION
1884: SELECT CUST_ACCOUNT_ID FROM
1885: HZ_CUST_ACCT_RELATE_ALL h WHERE
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