APPS.FV_SF1081_TRANSACTION dependencies on HZ_PARTIES

Line 368: vc_customer_name hz_parties.party_name%TYPE;

364: l_ledger_name varchar2(200);
365: --
366: vc_trx_number ra_customer_trx.trx_number%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;

Line 416: HZ_PARTIES HZP

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
418: RCT.CUSTOMER_TRX_ID = RTL.CUSTOMER_TRX_ID
419: AND RTL.CUSTOMER_TRX_LINE_ID = RLD.CUSTOMER_TRX_LINE_ID
420: AND RCT.COMPLETE_FLAG = 'Y'

Line 503: hz_parties hzp,

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,
506: ra_cust_trx_line_gl_dist rld,
507: ce_bank_accounts cba,