eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.JA_JAINDTBR_XMLP_PKG dependencies on AR_PAYMENT_SCHEDULES_ALL

Line 11: LV_INV_CLASS CONSTANT AR_PAYMENT_SCHEDULES_ALL.CLASS%TYPE DEFAULT 'INV';

7: END BEFOREPFORM;
8:
9: /* FUNCTION OPEN_BAL_TRFORMULA(CUSTOMER_ID IN NUMBER
10: ,CURR_CODE IN VARCHAR2) RETURN NUMBER IS
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';

Line 12: LV_DM_CLASS CONSTANT AR_PAYMENT_SCHEDULES_ALL.CLASS%TYPE DEFAULT 'DM';

8:
9: /* FUNCTION OPEN_BAL_TRFORMULA(CUSTOMER_ID IN NUMBER
10: ,CURR_CODE IN VARCHAR2) RETURN NUMBER IS
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';

Line 13: LV_CM_CLASS CONSTANT AR_PAYMENT_SCHEDULES_ALL.CLASS%TYPE DEFAULT 'CM';

9: /* FUNCTION OPEN_BAL_TRFORMULA(CUSTOMER_ID IN NUMBER
10: ,CURR_CODE IN VARCHAR2) RETURN NUMBER IS
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';

Line 14: LV_DEP_CLASS CONSTANT AR_PAYMENT_SCHEDULES_ALL.CLASS%TYPE DEFAULT 'DEP';

10: ,CURR_CODE IN VARCHAR2) RETURN NUMBER IS
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';

Line 27: AR_PAYMENT_SCHEDULES_ALL C,

23: SUM((B.AMOUNT) * NVL(A.EXCHANGE_RATE
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 )

Line 44: AR_PAYMENT_SCHEDULES_ALL

40: AND C.PAYMENT_SCHEDULE_ID IN (
41: SELECT
42: MIN(PAYMENT_SCHEDULE_ID)
43: FROM
44: AR_PAYMENT_SCHEDULES_ALL
45: WHERE CUSTOMER_TRX_ID = C.CUSTOMER_TRX_ID );
46: CURSOR GET_CREDIT_AMOUNT IS
47: SELECT
48: SUM(A.AMOUNT) SUM_AMOUNT,

Line 126: AR_PAYMENT_SCHEDULES_ALL D,

122: ,1.00)) SUM_AMOUNT_EXCHANGE
123: FROM
124: AR_ADJUSTMENTS_ALL B,
125: RA_CUSTOMER_TRX_ALL C,
126: AR_PAYMENT_SCHEDULES_ALL D,
127: GL_CODE_COMBINATIONS E
128: WHERE B.CUSTOMER_TRX_ID = C.CUSTOMER_TRX_ID
129: AND C.BILL_TO_CUSTOMER_ID = CUSTOMER_ID
130: AND B.GL_DATE <= TRUNC(P_START_DATE)

Line 232: AR_PAYMENT_SCHEDULES_ALL C,

228: ,1))
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 )

Line 248: AR_PAYMENT_SCHEDULES_ALL

244: AND C.PAYMENT_SCHEDULE_ID in (
245: SELECT
246: MIN(PAYMENT_SCHEDULE_ID)
247: FROM
248: AR_PAYMENT_SCHEDULES_ALL
249: WHERE CUSTOMER_TRX_ID = C.CUSTOMER_TRX_ID );
250: OPEN GET_DEBIT_AMOUNT;
251: FETCH GET_DEBIT_AMOUNT
252: INTO V_TR_DR_AMT,V_FUNC_DR_AMT;

Line 311: lv_inv_class constant ar_payment_schedules_all.class%type:= 'INV'; --rchandan for bug#4428980

307: */
308: function open_bal_trFormula (P_CUSTOMER_ID IN NUMBER
309: ,P_CURR_CODE IN VARCHAR2) RETURN NUMBER IS
310:
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

Line 312: lv_dm_class constant ar_payment_schedules_all.class%type:= 'DM'; --rchandan for bug#4428980

308: function open_bal_trFormula (P_CUSTOMER_ID IN NUMBER
309: ,P_CURR_CODE IN VARCHAR2) RETURN NUMBER IS
310:
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

Line 313: lv_cm_class constant ar_payment_schedules_all.class%type:= 'CM'; --rchandan for bug#4428980

309: ,P_CURR_CODE IN VARCHAR2) RETURN NUMBER IS
310:
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

Line 314: lv_dep_class constant ar_payment_schedules_all.class%type:= 'DEP'; --rchandan for bug#4428980

310:
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

Line 327: ar_payment_schedules_all C,

323: sum((b.amount)) sum_ext_amount,
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

Line 343: FROM AR_PAYMENT_SCHEDULES_ALL

339: AND b.account_class = lv_rec_account_class--rchandan for bug#4428980
340: and b.latest_rec_flag = 'Y'
341: AND c.Payment_schedule_id
342: IN (SELECT MIN(PAYMENT_SCHEDULE_ID)
343: FROM AR_PAYMENT_SCHEDULES_ALL
344: WHERE CUSTOMER_TRX_ID = C.CUSTOMER_TRX_ID
345: )
346: ;
347:

Line 422: ar_payment_schedules_all d,

418: select sum(b.amount),
419: sum(b.amount * NVL(c.exchange_rate,1.00)) sum_amount_exchange
420: FROM ar_adjustments_all b,
421: ra_customer_trx_all c,
422: ar_payment_schedules_all d,
423: gl_code_combinations e
424: WHERE
425: b.customer_trx_id = c.customer_trx_id
426: and c.bill_to_customer_id = P_CUSTOMER_ID

Line 540: ar_payment_schedules_all C,

536: Into v_cre_memo_amt,
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

Line 555: from ar_payment_schedules_all

551: AND a.org_id = NVL( P_ORGANIZATION_ID, a.org_id) -- added by sriram
552: AND b.account_class = lv_rec_account_class--rchandan for bug#4428980
553: AND c.payment_schedule_id in
554: ( select min(payment_schedule_id)
555: from ar_payment_schedules_all
556: where customer_trx_id = c.customer_trx_id
557: );
558:
559: OPEN get_debit_amount;