APPS.FV_SF1081_TRANSACTION dependencies on HZ_CUST_ACCT_SITES

Line 371: vc_address_id hz_cust_acct_sites.cust_acct_site_id%type;

367: vc_receipt_method_id ra_customer_trx.receipt_method_id%TYPE;
368: vc_customer_name hz_parties.party_name%TYPE;
369: vc_customer_id hz_cust_accounts.cust_Account_id%TYPE;
370: vc_cust_alc ce_bank_accounts.agency_location_code%TYPE;
371: vc_address_id hz_cust_acct_sites.cust_acct_site_id%type;
372: vc_address1 hz_locations.address1%TYPE;
373: vc_address2 hz_locations.address2%TYPE;
374: vc_address3 hz_locations.address3%TYPE;
375: vc_city hz_locations.city%TYPE;

Line 413: HZ_CUST_ACCT_SITES HZCAS,

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,
416: HZ_PARTIES HZP
417: WHERE

Line 499: hz_cust_acct_sites hzcas,

495: rct.trx_date,
496: rld.code_combination_id
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,

Line 659: FROM hz_cust_acct_sites_all hzcas,

655: BEGIN
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