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 772: FROM HZ_CUST_ACCT_RELATE

768: if lcustomer_relations = 'Y' then
769: begin
770: SELECT 'Y'
771: INTO l_exists
772: FROM HZ_CUST_ACCT_RELATE
773: WHERE RELATED_CUST_ACCOUNT_ID = p_header_rec.sold_to_org_id
774: AND CUST_ACCOUNT_ID = l_sold_to_org_id
775: AND STATUS = 'A'
776: AND ROWNUM = 1;

Line 1514: hz_cust_acct_relate where

1510: INTO l_dummy
1511: FROM dual
1512: WHERE exists(
1513: select 'x' from
1514: hz_cust_acct_relate where
1515: related_cust_account_id = p_header_rec.sold_to_org_id
1516: and status = 'A'
1517: AND cust_account_id = l_sold_to_org
1518: );

Line 1623: HZ_CUST_ACCT_RELATE_ALL h WHERE

1619: ACCT_SITE.CUST_ACCOUNT_ID in (
1620: SELECT p_header_rec.sold_to_org_id FROM DUAL
1621: UNION
1622: SELECT CUST_ACCOUNT_ID FROM
1623: HZ_CUST_ACCT_RELATE_ALL h WHERE
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

Line 1719: HZ_CUST_ACCT_RELATE_ALL h WHERE

1715: ACCT_SITE.CUST_ACCOUNT_ID in (
1716: SELECT p_header_rec.sold_to_org_id FROM DUAL
1717: UNION
1718: SELECT CUST_ACCOUNT_ID FROM
1719: HZ_CUST_ACCT_RELATE_ALL h WHERE
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

Line 1817: HZ_CUST_ACCT_RELATE_ALL h WHERE

1813: ACCT_SITE.CUST_ACCOUNT_ID in (
1814: SELECT p_header_rec.sold_to_org_id FROM DUAL
1815: UNION
1816: SELECT CUST_ACCOUNT_ID FROM
1817: HZ_CUST_ACCT_RELATE_ALL h WHERE
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