APPS.OE_CNCL_VALIDATE_LINE dependencies on HZ_CUST_SITE_USES_ALL

Line 978: FROM HZ_CUST_SITE_USES_ALL SITE,

974: oe_debug_pub.add('Cr: Yes Line Deliver',2);
975:
976: SELECT /* MOAC_SQL_CHANGE */ 'VALID'
977: Into l_dummy
978: FROM HZ_CUST_SITE_USES_ALL SITE,
979: HZ_CUST_ACCT_SITES ACCT_SITE
980: WHERE SITE.SITE_USE_ID = p_deliver_to_org_id
981: AND SITE.SITE_USE_CODE ='DELIVER_TO'
982: AND SITE.CUST_ACCT_SITE_ID = ACCT_SITE.CUST_ACCT_SITE_ID

Line 1184: cursor partyinfo(p_site_org_id HZ_CUST_SITE_USES_ALL.SITE_USE_ID%type) is

1180: l_bill_to_party_site_id hz_party_sites.party_site_id%type;
1181: l_org_id NUMBER;
1182: -- l_legal_entity_id NUMBER;
1183:
1184: cursor partyinfo(p_site_org_id HZ_CUST_SITE_USES_ALL.SITE_USE_ID%type) is
1185: SELECT cust_acct.cust_account_id,
1186: cust_Acct.party_id,
1187: acct_site.party_site_id,
1188: site_use.org_id

Line 1190: HZ_CUST_SITE_USES_ALL site_use,

1186: cust_Acct.party_id,
1187: acct_site.party_site_id,
1188: site_use.org_id
1189: FROM
1190: HZ_CUST_SITE_USES_ALL site_use,
1191: HZ_CUST_ACCT_SITES_ALL acct_site,
1192: HZ_CUST_ACCOUNTS_ALL cust_Acct
1193: WHERE site_use.site_use_id = p_site_org_id
1194: AND site_use.cust_acct_site_id = acct_site.cust_acct_site_id

Line 1993: , HZ_CUST_SITE_USES_ALL SHIP

1989: SELECT /* MOAC_SQL_CHANGE */ 'VALID'
1990: INTO l_dummy
1991: FROM HZ_CUST_ACCOUNT_ROLES ACCT_ROLE
1992: , HZ_CUST_ACCT_SITES ACCT_SITE
1993: , HZ_CUST_SITE_USES_ALL SHIP
1994: WHERE ACCT_ROLE.CUST_ACCOUNT_ROLE_ID = p_line_rec.ship_to_contact_id
1995: AND ACCT_ROLE.CUST_ACCOUNT_ID = ACCT_SITE.CUST_ACCOUNT_ID
1996: AND ACCT_SITE.CUST_ACCT_SITE_ID = SHIP.CUST_ACCT_SITE_ID
1997: AND ACCT_ROLE.ROLE_TYPE = 'CONTACT'

Line 2054: , HZ_CUST_SITE_USES_ALL DELI

2050: SELECT /* MOAC_SQL_CHANGE */ 'VALID'
2051: INTO l_dummy
2052: FROM HZ_CUST_ACCOUNT_ROLES ACCT_ROLE
2053: , HZ_CUST_ACCT_SITES ACCT_SITE
2054: , HZ_CUST_SITE_USES_ALL DELI
2055: WHERE ACCT_ROLE.CUST_ACCOUNT_ROLE_ID = p_line_rec.deliver_to_contact_id
2056: AND ACCT_ROLE.CUST_ACCOUNT_ID = ACCT_SITE.CUST_ACCOUNT_ID
2057: AND ACCT_ROLE.ROLE_TYPE = 'CONTACT'
2058: AND ACCT_SITE.CUST_ACCT_SITE_ID = DELI.CUST_ACCT_SITE_ID

Line 2173: , HZ_CUST_SITE_USES_ALL INV

2169: SELECT /* MOAC_SQL_CHANGE */ 'VALID'
2170: INTO l_dummy
2171: FROM HZ_CUST_ACCOUNT_ROLES ACCT_ROLE
2172: , HZ_CUST_ACCT_SITES ACCT_SITE
2173: , HZ_CUST_SITE_USES_ALL INV
2174: WHERE ACCT_ROLE.CUST_ACCOUNT_ROLE_ID = p_line_rec.invoice_to_contact_id
2175: AND ACCT_ROLE.CUST_ACCOUNT_ID = ACCT_SITE.CUST_ACCOUNT_ID
2176: AND ACCT_ROLE.ROLE_TYPE = 'CONTACT'
2177: AND ACCT_SITE.CUST_ACCT_SITE_ID = INV.CUST_ACCT_SITE_ID