DBA Data[Home] [Help]

APPS.FV_SF1081_TRANSACTION dependencies on HZ_CUST_SITE_USES

Line 411: HZ_CUST_SITE_USES HZCSU,

407: FROM
408: RA_CUSTOMER_TRX RCT,
409: RA_CUSTOMER_TRX_LINES RTL,
410: RA_CUST_TRX_LINE_GL_DIST RLD,
411: HZ_CUST_SITE_USES HZCSU,
412: HZ_LOCATIONS HZL,
413: HZ_CUST_ACCT_SITES HZCAS,
414: HZ_CUST_ACCOUNTS HZCA,
415: HZ_PARTY_SITES HZPS,

Line 501: HZ_CUST_SITE_USEs hzcsu,

497: FROM
498: hz_locations hzl,
499: hz_cust_acct_sites hzcas,
500: hz_party_sites hzps ,
501: HZ_CUST_SITE_USEs hzcsu,
502: hz_cust_accounts hzca,
503: hz_parties hzp,
504: ra_customer_trx rct,
505: ra_customer_trx_lines rtl,

Line 660: hz_cust_site_uses_all hzcsu,

656:
657: SELECT eb.agency_location_code
658: INTO vc_cust_alc
659: FROM hz_cust_acct_sites_all hzcas,
660: hz_cust_site_uses_all hzcsu,
661: iby_external_payers_all payer,
662: iby_pmt_instr_uses_all iby_ins,
663: iby_ext_bank_accounts_v eb
664: WHERE hzcas.cust_account_id = vc_customer_id