DBA Data[Home] [Help]

APPS.FV_SF1081_TRANSACTION dependencies on RA_CUST_TRX_LINE_GL_DIST

Line 421: vc_amount ra_cust_trx_line_gl_dist.amount%TYPE;

417: vc_city hz_locations.city%TYPE;
418: vc_state hz_locations.state%TYPE;
419: vc_postal_code hz_locations.postal_code%TYPE;
420: vc_customer_trx_id ra_customer_trx.customer_trx_id%TYPE;
421: vc_amount ra_cust_trx_line_gl_dist.amount%TYPE;
422: vc_bill_to_customer_id ra_customer_trx.bill_to_customer_id%TYPE;
423: vc_trx_date ra_customer_trx.trx_date%TYPE;
424: vc_code_combination_id number;
425:

Line 452: RA_CUST_TRX_LINE_GL_DIST RLD,

448: RLD.CODE_COMBINATION_ID
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,

Line 556: ra_cust_trx_line_gl_dist rld,

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,
557: ce_bank_accounts cba,
558: ce_bank_acct_uses_all cbau
559: WHERE
560: hzp.party_id = hzca.party_id