DBA Data[Home] [Help]

APPS.GMD_COA_DATA_OM dependencies on HZ_CUST_ACCT_SITES_ALL

Line 843: hz_cust_acct_sites_all a,

839: mtl_system_items msi,
840: ic_item_mst ic,
841: hz_cust_accounts c,
842: hz_cust_site_uses_all s,
843: hz_cust_acct_sites_all a,
844: hz_parties pr
845: where h.header_id = l.header_id
846: and l.header_id = wdd.source_header_id
847: and l.line_id = wdd.source_line_id

Line 957: HZ_CUST_ACCT_SITES_ALL A,

953: PR.PARTY_NAME cust_name
954: from
955: HZ_CUST_ACCOUNTS C,
956: HZ_CUST_SITE_USES_ALL S,
957: HZ_CUST_ACCT_SITES_ALL A,
958: HZ_PARTIES PR
959: where C.CUST_ACCOUNT_ID = A.CUST_ACCOUNT_ID
960: AND S.CUST_ACCT_SITE_ID = A.CUST_ACCT_SITE_ID
961: AND S.SITE_USE_CODE IN ('SHIP_TO')