APPS.JA_JAINDTBR_XMLP_PKG dependencies on RA_CUST_TRX_LINE_GL_DIST_ALL

Line 15: LV_REC_ACCOUNT_CLASS CONSTANT RA_CUST_TRX_LINE_GL_DIST_ALL.ACCOUNT_CLASS%TYPE DEFAULT 'REC';

11: LV_INV_CLASS CONSTANT AR_PAYMENT_SCHEDULES_ALL.CLASS%TYPE DEFAULT 'INV';
12: LV_DM_CLASS CONSTANT AR_PAYMENT_SCHEDULES_ALL.CLASS%TYPE DEFAULT 'DM';
13: LV_CM_CLASS CONSTANT AR_PAYMENT_SCHEDULES_ALL.CLASS%TYPE DEFAULT 'CM';
14: LV_DEP_CLASS CONSTANT AR_PAYMENT_SCHEDULES_ALL.CLASS%TYPE DEFAULT 'DEP';
15: LV_REC_ACCOUNT_CLASS CONSTANT RA_CUST_TRX_LINE_GL_DIST_ALL.ACCOUNT_CLASS%TYPE DEFAULT 'REC';
16: LV_REV_STATUS CONSTANT AR_CASH_RECEIPT_HISTORY_ALL.STATUS%TYPE DEFAULT 'REVERSED';
17: LV_ACT_STATUS CONSTANT AR_CASH_RECEIPT_HISTORY_ALL.STATUS%TYPE DEFAULT 'ACTIVITY';
18: LV_LOSS_SOURCE_TYPE CONSTANT AR_DISTRIBUTIONS_ALL.SOURCE_TYPE%TYPE DEFAULT 'EXCH_LOSS';
19: LV_GAIN_SOURCE_TYPE CONSTANT AR_DISTRIBUTIONS_ALL.SOURCE_TYPE%TYPE DEFAULT 'EXCH_GAIN';

Line 28: RA_CUST_TRX_LINE_GL_DIST_ALL B

24: ,1))
25: FROM
26: RA_CUSTOMER_TRX_ALL A,
27: AR_PAYMENT_SCHEDULES_ALL C,
28: RA_CUST_TRX_LINE_GL_DIST_ALL B
29: WHERE A.BILL_TO_CUSTOMER_ID = CUSTOMER_ID
30: AND A.CUSTOMER_TRX_ID = C.CUSTOMER_TRX_ID
31: AND C.CLASS In ( LV_INV_CLASS , LV_DM_CLASS , LV_DEP_CLASS )
32: AND C.GL_DATE <= TRUNC(P_START_DATE)

Line 233: RA_CUST_TRX_LINE_GL_DIST_ALL B

229: INTO V_CRE_MEMO_AMT,V_CRE_MEMO_FUNC_AMT
230: FROM
231: RA_CUSTOMER_TRX_ALL A,
232: AR_PAYMENT_SCHEDULES_ALL C,
233: RA_CUST_TRX_LINE_GL_DIST_ALL B
234: WHERE A.BILL_TO_CUSTOMER_ID = CUSTOMER_ID
235: AND A.CUSTOMER_TRX_ID = C.CUSTOMER_TRX_ID
236: AND C.CLASS In ( LV_CM_CLASS )
237: AND C.GL_DATE <= TRUNC(P_START_DATE)

Line 315: lv_rec_account_class CONSTANT ra_cust_trx_line_gl_dist_all.account_class%TYPE := 'REC'; --rchandan for bug#4428980

311: lv_inv_class constant ar_payment_schedules_all.class%type:= 'INV'; --rchandan for bug#4428980
312: lv_dm_class constant ar_payment_schedules_all.class%type:= 'DM'; --rchandan for bug#4428980
313: lv_cm_class constant ar_payment_schedules_all.class%type:= 'CM'; --rchandan for bug#4428980
314: lv_dep_class constant ar_payment_schedules_all.class%type:= 'DEP'; --rchandan for bug#4428980
315: lv_rec_account_class CONSTANT ra_cust_trx_line_gl_dist_all.account_class%TYPE := 'REC'; --rchandan for bug#4428980
316: lv_rev_status CONSTANT ar_cash_receipt_history_all.status%TYPE := 'REVERSED'; --rchandan for bug#4428980
317: lv_act_status CONSTANT ar_cash_receipt_history_all.status%TYPE := 'ACTIVITY'; --rchandan for bug#4428980
318: lv_loss_source_Type CONSTANT ar_distributions_all.source_Type%TYPE := 'EXCH_LOSS'; --rchandan for bug#4428980
319: lv_gain_source_Type CONSTANT ar_distributions_all.source_Type%TYPE := 'EXCH_GAIN' ; --rchandan for bug#4428980

Line 328: ra_cust_trx_line_gl_dist_all B

324: sum((b.amount) * NVL(a.exchange_rate,1))
325: From
326: ra_customer_trx_all A,
327: ar_payment_schedules_all C,
328: ra_cust_trx_line_gl_dist_all B
329: Where
330: a.bill_to_customer_id = P_CUSTOMER_ID
331: AND a.customer_trx_id = c.customer_trx_id
332: AND c.class In(lv_inv_class,lv_dm_class,lv_dep_class)--rchandan for bug#4428980

Line 541: ra_cust_trx_line_gl_dist_all B

537: v_cre_memo_func_amt
538: From
539: ra_customer_trx_all A,
540: ar_payment_schedules_all C,
541: ra_cust_trx_line_gl_dist_all B
542: Where
543: a.bill_to_customer_id = P_CUSTOMER_ID
544: AND a.customer_trx_id = c.customer_trx_id
545: AND c.class In(lv_cm_class)--rchandan for bug#4428980