DBA Data[Home] [Help]

APPS.MSC_X_VMI_POREQ dependencies on HZ_CUST_SITE_USES_ALL

Line 685: hz_cust_site_uses_all hua

681: select nvl(hca.order_type_id, hua.order_type_id) order_type_id
682: into lv_order_type_id
683: from hz_cust_accounts hca,
684: hz_cust_acct_sites_all hsa,
685: hz_cust_site_uses_all hua
686: where hca.CUST_ACCOUNT_ID = p_cust_id
687: and hca.cust_account_id = hsa.CUST_ACCOUNT_ID
688: and hua.cust_acct_site_id = hsa.cust_acct_site_id
689: and hua.SITE_USE_ID = p_ship_to_id;

Line 876: HZ_CUST_SITE_USES_ALL SITE_USES_ALL,

872:
873: BEGIN
874: SELECT SITE_USES_ALL.ORG_ID INTO l_operating_unit FROM
875: HZ_CUST_ACCT_SITES_ALL ACCT_SITE,
876: HZ_CUST_SITE_USES_ALL SITE_USES_ALL,
877: HZ_CUST_ACCOUNTS CUST_ACCT,
878: HZ_PARTY_SITES PARTY_SITE,
879: HZ_LOCATIONS LOC,
880: HR_ORGANIZATION_INFORMATION O,