[Home] [Help]
583: INTO l_exists
584: FROM ra_customer_trx ratrx
585: WHERE ratrx.bill_to_customer_id
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
656: if l_check_duplicate='Y' then
657: --Added for ER 4760436 end
658: SELECT /* MOAC_SQL_NO_CHANGE */ 'Y'
659: INTO l_duplicate_exists
660: FROM DUAL
661: WHERE EXISTS (SELECT 'Y'
662: FROM OE_ORDER_HEADERS
663: WHERE HEADER_ID <> p_header_id
664: AND SOLD_TO_ORG_ID = p_sold_to_org_id
1507:
1508: BEGIN
1509: SELECT 'VALID'
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
1616: AND SITE.CUST_ACCT_SITE_ID = ACCT_SITE.CUST_ACCT_SITE_ID
1617: AND SITE.STATUS = 'A'
1618: AND ACCT_SITE.STATUS ='A' AND --bug 2752321
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
1712: AND SITE.CUST_ACCT_SITE_ID = ACCT_SITE.CUST_ACCT_SITE_ID
1713: AND SITE.STATUS = 'A'
1714: AND ACCT_SITE.STATUS = 'A' AND --bug 2752321
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
1810: AND SITE.STATUS = 'A'
1811: AND ACCT_SITE.ORG_ID=SITE.ORG_ID
1812: AND ACCT_SITE.STATUS = 'A' AND
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