APPS.ARRX_BRS dependencies on RA_CUSTOMER_TRX_LINES

Line 101: v_assigned_entered_amount RA_CUSTOMER_TRX_LINES.extended_amount%TYPE;

97: v_magnetic_format_code RA_CUST_TRX_TYPES.magnetic_format_code%TYPE;
98: v_original_entered_amount AR_PAYMENT_SCHEDULES.amount_due_original%TYPE;
99: v_open_entered_amount AR_PAYMENT_SCHEDULES.amount_due_remaining%TYPE;
100: v_open_functional_amount AR_PAYMENT_SCHEDULES.acctd_amount_due_remaining%TYPE;
101: v_assigned_entered_amount RA_CUSTOMER_TRX_LINES.extended_amount%TYPE;
102: v_assigned_functional_amount RA_CUSTOMER_TRX_LINES.extended_acctd_amount%TYPE;
103: v_drawee_name hz_parties.party_name%TYPE;
104: v_drawee_number hz_cust_accounts.account_number%TYPE;
105: v_drawee_taxpayer_id hz_parties.jgzz_fiscal_code%TYPE;

Line 102: v_assigned_functional_amount RA_CUSTOMER_TRX_LINES.extended_acctd_amount%TYPE;

98: v_original_entered_amount AR_PAYMENT_SCHEDULES.amount_due_original%TYPE;
99: v_open_entered_amount AR_PAYMENT_SCHEDULES.amount_due_remaining%TYPE;
100: v_open_functional_amount AR_PAYMENT_SCHEDULES.acctd_amount_due_remaining%TYPE;
101: v_assigned_entered_amount RA_CUSTOMER_TRX_LINES.extended_amount%TYPE;
102: v_assigned_functional_amount RA_CUSTOMER_TRX_LINES.extended_acctd_amount%TYPE;
103: v_drawee_name hz_parties.party_name%TYPE;
104: v_drawee_number hz_cust_accounts.account_number%TYPE;
105: v_drawee_taxpayer_id hz_parties.jgzz_fiscal_code%TYPE;
106: v_drawee_vat_reg_number HZ_CUST_SITE_USES.tax_reference%TYPE;

Line 322: FROM ra_customer_trx_lines_all trl

318:
319: -- Assigned Amounts Cursor
320: l_assigned_amount := 'SELECT nvl(sum(trl.extended_amount),0),
321: nvl(sum(trl.extended_acctd_amount),0)
322: FROM ra_customer_trx_lines_all trl
323: WHERE trl.customer_trx_id = :b_trx_id '||
324: l_org_where_trl;
325:
326: