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 1183: cursor partyinfo(p_site_org_id HZ_CUST_SITE_USES_ALL.SITE_USE_ID%type) is

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

Line 1189: HZ_CUST_SITE_USES_ALL site_use,

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

Line 1992: , HZ_CUST_SITE_USES_ALL SHIP

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

Line 2053: , HZ_CUST_SITE_USES_ALL DELI

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

Line 2172: , HZ_CUST_SITE_USES_ALL INV

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