APPS.OE_VALIDATE_LINE dependencies on HZ_CUST_ACCT_SITES

Line 2431: HZ_CUST_ACCT_SITES ACCT_SITE

2427: l_site_use_code := 'SHIP_TO' ;
2428: SELECT /* MOAC_SQL_CHANGE */ 'VALID'
2429: Into l_dummy
2430: FROM HZ_CUST_SITE_USES_ALL SITE,
2431: HZ_CUST_ACCT_SITES ACCT_SITE
2432: WHERE SITE.SITE_USE_ID = p_ship_to_org_id
2433: AND SITE.SITE_USE_CODE = l_site_use_code
2434: AND SITE.CUST_ACCT_SITE_ID = ACCT_SITE.CUST_ACCT_SITE_ID
2435: AND SITE.STATUS = 'A'

Line 2513: HZ_CUST_ACCT_SITES ACCT_SITE

2509: l_site_use_code := 'DELIVER_TO' ;
2510: SELECT /* MOAC_SQL_CHANGE */ 'VALID'
2511: Into l_dummy
2512: FROM HZ_CUST_SITE_USES_ALL SITE,
2513: HZ_CUST_ACCT_SITES ACCT_SITE
2514: WHERE SITE.SITE_USE_ID = p_deliver_to_org_id
2515: AND SITE.SITE_USE_CODE = l_site_use_code
2516: AND SITE.CUST_ACCT_SITE_ID = ACCT_SITE.CUST_ACCT_SITE_ID
2517: AND SITE.STATUS = 'A'

Line 2650: hz_cust_acct_sites_all cas

2646: and h.org_id =ratrx.org_id
2647: union
2648: select cas.cust_account_id customer_id
2649: from hz_cust_site_uses_all su,
2650: hz_cust_acct_sites_all cas
2651: where cas.cust_acct_site_id = su.cust_acct_site_id
2652: and su.site_use_id = p_line_rec.invoice_to_org_id
2653: and cas.org_id=ratrx.org_id
2654: union

Line 2658: hz_cust_acct_sites_all cas

2654: union
2655: select c.cust_account_id customer_id
2656: from hz_cust_acct_relate_all c,
2657: hz_cust_site_uses_all su,
2658: hz_cust_acct_sites_all cas
2659: where cas.cust_acct_site_id = su.cust_acct_site_id
2660: and su.site_use_id = p_line_rec.invoice_to_org_id
2661: and c.related_cust_account_id = cas.cust_account_id
2662: and c.status = 'A'

Line 3927: HZ_CUST_ACCT_SITES_ALL acct_site,

3923: acct_site.party_site_id,
3924: site_use.org_id
3925: FROM
3926: HZ_CUST_SITE_USES_ALL site_use,
3927: HZ_CUST_ACCT_SITES_ALL acct_site,
3928: HZ_CUST_ACCOUNTS_ALL cust_Acct
3929: WHERE site_use.site_use_id = p_site_org_id
3930: AND site_use.cust_acct_site_id = acct_site.cust_acct_site_id
3931: and acct_site.cust_account_id = cust_acct.cust_account_id;

Line 5680: HZ_CUST_ACCT_SITES ADDR

5676: INTO l_dummy
5677: FROM
5678: HZ_CUST_ACCOUNT_ROLES ACCT_ROLE,
5679: HZ_CUST_SITE_USES_ALL SITE_USE, --changed SHIP to SITE_USE for bug 3739650
5680: HZ_CUST_ACCT_SITES ADDR
5681: WHERE
5682: ACCT_ROLE.CUST_ACCOUNT_ROLE_ID = p_line_rec.ship_to_contact_id
5683: AND ACCT_ROLE.CUST_ACCOUNT_ID = ADDR.CUST_ACCOUNT_ID
5684: AND ACCT_ROLE.ROLE_TYPE = 'CONTACT'

Line 5774: HZ_CUST_ACCT_SITES ADDR

5770: INTO l_dummy
5771: FROM
5772: HZ_CUST_ACCOUNT_ROLES ACCT_ROLE,
5773: HZ_CUST_SITE_USES_ALL SITE_USE, --changed INV to SITE_USE for bug 3739650
5774: HZ_CUST_ACCT_SITES ADDR
5775: WHERE
5776: ACCT_ROLE.CUST_ACCOUNT_ROLE_ID = p_line_rec.deliver_to_contact_id
5777: AND ACCT_ROLE.CUST_ACCOUNT_ID = ADDR.CUST_ACCOUNT_ID
5778: AND ACCT_ROLE.ROLE_TYPE = 'CONTACT'

Line 5849: HZ_CUST_ACCT_SITES ACCT_SITE

5845: l_site_use_code := 'BILL_TO' ;
5846: SELECT /* MOAC_SQL_CHANGE */ 'VALID'
5847: Into l_dummy
5848: FROM HZ_CUST_SITE_USES_ALL SITE,
5849: HZ_CUST_ACCT_SITES ACCT_SITE
5850: WHERE SITE.SITE_USE_ID = p_line_rec.invoice_to_org_id
5851: AND SITE.SITE_USE_CODE = l_site_use_code
5852: AND SITE.CUST_ACCT_SITE_ID = ACCT_SITE.CUST_ACCT_SITE_ID
5853: AND SITE.STATUS = 'A'

Line 5927: HZ_CUST_ACCT_SITES_ALL ADDR

5923: INTO l_dummy
5924: FROM
5925: HZ_CUST_ACCOUNT_ROLES ACCT_ROLE,
5926: HZ_CUST_SITE_USES_ALL SITE_USE, --changed INV to SITE_USE for bug 3739650
5927: HZ_CUST_ACCT_SITES_ALL ADDR
5928: WHERE
5929: ACCT_ROLE.CUST_ACCOUNT_ROLE_ID = p_line_rec.invoice_to_contact_id
5930: AND ACCT_ROLE.CUST_ACCOUNT_ID = ADDR.CUST_ACCOUNT_ID
5931: AND ACCT_ROLE.ROLE_TYPE = 'CONTACT'

Line 7718: hz_cust_acct_sites acct_site

7714: INTO
7715: l_dummy
7716: FROM
7717: hz_cust_site_uses_all site_use,
7718: hz_cust_acct_sites acct_site
7719: WHERE
7720: site_use.site_use_id=p_line_rec.end_customer_site_use_id
7721: and site_use.cust_acct_site_id=acct_site.cust_acct_site_id
7722: and acct_site.cust_account_id=p_line_rec.end_customer_id;