APPS.FV_SF1081_TRANSACTION dependencies on HZ_CUST_ACCOUNTS

Line 411: vc_customer_id hz_cust_accounts.cust_Account_id%TYPE;

407: --
408: vc_trx_number ra_customer_trx.trx_number%TYPE;
409: vc_receipt_method_id ra_customer_trx.receipt_method_id%TYPE;
410: vc_customer_name hz_parties.party_name%TYPE;
411: vc_customer_id hz_cust_accounts.cust_Account_id%TYPE;
412: vc_cust_alc ce_bank_accounts.agency_location_code%TYPE;
413: vc_address_id hz_cust_acct_sites.cust_acct_site_id%type;
414: vc_address1 hz_locations.address1%TYPE;
415: vc_address2 hz_locations.address2%TYPE;

Line 456: HZ_CUST_ACCOUNTS HZCA,

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,
458: HZ_PARTIES HZP
459: WHERE
460: RCT.CUSTOMER_TRX_ID = RTL.CUSTOMER_TRX_ID

Line 479: FROM hz_cust_accounts hzca

475: AND HZPS.LOCATION_ID = HZL.LOCATION_ID
476: AND HZCAS.CUST_ACCOUNT_ID = HZCA.CUST_ACCOUNT_ID
477: AND hzca.cust_account_id IN
478: ((SELECT cust_account_id
479: FROM hz_cust_accounts hzca
480: WHERE NVL(customer_class_code,'XXX') LIKE
481: DECODE(parm_customer_class,null,
482: NVL(customer_class_code,'XXX'),parm_customer_class))
483: INTERSECT

Line 485: FROM hz_cust_accounts hzca

481: DECODE(parm_customer_class,null,
482: NVL(customer_class_code,'XXX'),parm_customer_class))
483: INTERSECT
484: (SELECT cust_account_id
485: FROM hz_cust_accounts hzca
486: WHERE cust_account_id LIKE NVL(parm_customer,'%')))
487: AND RCT.BILL_TO_CUSTOMER_ID IN
488: (SELECT HCP.CUST_ACCOUNT_ID
489: FROM HZ_CUSTOMER_PROFILES HCP

Line 552: hz_cust_accounts hzca,

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,
556: ra_cust_trx_line_gl_dist rld,

Line 604: FROM hz_cust_accounts hzca

600: AND rct.trx_date BETWEEN DECODE(parm_print_date_low,null,TO_DATE('1990/1/1', 'yyyy/mm/dd'), parm_print_date_low)
601: AND DECODE(parm_print_date_high,null,trunc(sysdate),parm_print_date_high )
602: AND hzca.cust_account_id IN
603: ((SELECT cust_account_id
604: FROM hz_cust_accounts hzca
605: WHERE NVL(customer_class_code,'XXX') LIKE DECODE(parm_customer_class,null,
606: NVL(customer_class_code,'XXX'),parm_customer_class))
607: INTERSECT
608: (SELECT cust_account_id

Line 609: FROM hz_cust_accounts hzca

605: WHERE NVL(customer_class_code,'XXX') LIKE DECODE(parm_customer_class,null,
606: NVL(customer_class_code,'XXX'),parm_customer_class))
607: INTERSECT
608: (SELECT cust_account_id
609: FROM hz_cust_accounts hzca
610: WHERE cust_account_id LIKE NVL(parm_customer,'%')))
611: AND rct.customer_trx_id IN
612: (SELECT customer_trx_id
613: FROM ra_customer_trx