DBA Data[Home] [Help]

APPS.FV_SF1081_TRANSACTION dependencies on HZ_CUST_SITE_USES

Line 453: HZ_CUST_SITE_USES HZCSU,

449: FROM
450: RA_CUSTOMER_TRX RCT,
451: RA_CUSTOMER_TRX_LINES RTL,
452: RA_CUST_TRX_LINE_GL_DIST RLD,
453: HZ_CUST_SITE_USES HZCSU,
454: HZ_LOCATIONS HZL,
455: HZ_CUST_ACCT_SITES HZCAS,
456: HZ_CUST_ACCOUNTS HZCA,
457: HZ_PARTY_SITES HZPS,

Line 551: HZ_CUST_SITE_USEs hzcsu,

547: FROM
548: hz_locations hzl,
549: hz_cust_acct_sites hzcas,
550: hz_party_sites hzps ,
551: HZ_CUST_SITE_USEs hzcsu,
552: hz_cust_accounts hzca,
553: hz_parties hzp,
554: ra_customer_trx rct,
555: ra_customer_trx_lines rtl,

Line 712: hz_cust_site_uses_all hzcsu,

708:
709: SELECT eb.agency_location_code
710: INTO vc_cust_alc
711: FROM hz_cust_acct_sites_all hzcas,
712: hz_cust_site_uses_all hzcsu,
713: iby_external_payers_all payer,
714: iby_pmt_instr_uses_all iby_ins,
715: iby_ext_bank_accounts_v eb
716: WHERE hzcas.cust_account_id = vc_customer_id