APPS.JA_JAINARDR_XMLP_PKG dependencies on AR_RECEIVABLE_APPLICATIONS_ALL

Line 92: CURSOR GET_DISCOUNT_CUR(CP_APP_TYPE IN AR_RECEIVABLE_APPLICATIONS_ALL.APPLICATION_TYPE%TYPE) IS

88: AND A.REVERSAL_DATE is not null
89: AND A.CURRENCY_CODE = CURR_CODE
90: AND B.STATUS = LV_REV_STATUS
91: AND A.ORG_ID = P_ORG_ID;
92: CURSOR GET_DISCOUNT_CUR(CP_APP_TYPE IN AR_RECEIVABLE_APPLICATIONS_ALL.APPLICATION_TYPE%TYPE) IS
93: SELECT
94: NVL(SUM(ABS(NVL(D.EARNED_DISCOUNT_TAKEN
95: ,0)))
96: ,0) SUM_AMOUNT,

Line 102: AR_RECEIVABLE_APPLICATIONS_ALL D

98: ,0)))
99: ,0) SUM_AMOUNT_EXCHANGE
100: FROM
101: RA_CUSTOMER_TRX_ALL B,
102: AR_RECEIVABLE_APPLICATIONS_ALL D
103: WHERE B.BILL_TO_CUSTOMER_ID = CUSTOMER_ID
104: AND B.COMPLETE_FLAG = 'Y'
105: AND TRUNC(D.GL_DATE) < TRUNC(P_START_DATE)
106: AND D.APPLIED_CUSTOMER_TRX_ID = B.CUSTOMER_TRX_ID

Line 120: AR_RECEIVABLE_APPLICATIONS_ALL D,

116: SUM(E.ACCTD_AMOUNT_CR) SUM_EXCHANGE_AMOUNT
117: FROM
118: RA_CUSTOMER_TRX_ALL B,
119: AR_CASH_RECEIPTS_ALL C,
120: AR_RECEIVABLE_APPLICATIONS_ALL D,
121: AR_DISTRIBUTIONS_ALL E
122: WHERE B.CUSTOMER_TRX_ID = D.APPLIED_CUSTOMER_TRX_ID
123: AND C.CASH_RECEIPT_ID = D.CASH_RECEIPT_ID
124: AND E.SOURCE_ID = D.RECEIVABLE_APPLICATION_ID

Line 137: AR_RECEIVABLE_APPLICATIONS_ALL D,

133: SUM(E.ACCTD_AMOUNT_DR) SUM_EXCHANGE_AMOUNT
134: FROM
135: RA_CUSTOMER_TRX_ALL B,
136: AR_CASH_RECEIPTS_ALL C,
137: AR_RECEIVABLE_APPLICATIONS_ALL D,
138: AR_DISTRIBUTIONS_ALL E
139: WHERE B.CUSTOMER_TRX_ID = D.APPLIED_CUSTOMER_TRX_ID
140: AND C.CASH_RECEIPT_ID = D.CASH_RECEIPT_ID
141: AND E.SOURCE_ID = D.RECEIVABLE_APPLICATION_ID

Line 155: AR_RECEIVABLE_APPLICATIONS_ALL C

151: ,1.00)) SUM_AMOUNT_EXCHANGE
152: FROM
153: AR_CASH_RECEIPTS_ALL A,
154: AR_CASH_RECEIPT_HISTORY_ALL B,
155: AR_RECEIVABLE_APPLICATIONS_ALL C
156: WHERE A.PAY_FROM_CUSTOMER = CUSTOMER_ID
157: AND TRUNC(B.GL_DATE) < TRUNC(P_START_DATE)
158: AND A.CASH_RECEIPT_ID = B.CASH_RECEIPT_ID
159: AND A.CASH_RECEIPT_ID = C.CASH_RECEIPT_ID

Line 378: CURSOR GET_DISCOUNT_CUR(CP_APP_TYPE IN AR_RECEIVABLE_APPLICATIONS_ALL.APPLICATION_TYPE%TYPE) IS

374: AND A.REVERSAL_DATE is not null
375: AND A.CURRENCY_CODE = CURR_CODE1
376: AND B.STATUS = LV_REV_STATUS
377: AND A.ORG_ID = P_ORG_ID;
378: CURSOR GET_DISCOUNT_CUR(CP_APP_TYPE IN AR_RECEIVABLE_APPLICATIONS_ALL.APPLICATION_TYPE%TYPE) IS
379: SELECT
380: NVL(SUM(ABS(NVL(D.EARNED_DISCOUNT_TAKEN
381: ,0)))
382: ,0) SUM_AMOUNT,

Line 388: AR_RECEIVABLE_APPLICATIONS_ALL D

384: ,0)))
385: ,0) SUM_AMOUNT_EXCHANGE
386: FROM
387: RA_CUSTOMER_TRX_ALL B,
388: AR_RECEIVABLE_APPLICATIONS_ALL D
389: WHERE B.BILL_TO_CUSTOMER_ID = CUSTOMER_ID2
390: AND B.COMPLETE_FLAG = 'Y'
391: AND TRUNC(D.GL_DATE) <= TRUNC(P_END_DATE)
392: AND D.APPLIED_CUSTOMER_TRX_ID = B.CUSTOMER_TRX_ID

Line 406: AR_RECEIVABLE_APPLICATIONS_ALL D,

402: SUM(E.ACCTD_AMOUNT_CR) SUM_EXCHANGE_AMOUNT
403: FROM
404: RA_CUSTOMER_TRX_ALL B,
405: AR_CASH_RECEIPTS_ALL C,
406: AR_RECEIVABLE_APPLICATIONS_ALL D,
407: AR_DISTRIBUTIONS_ALL E
408: WHERE B.CUSTOMER_TRX_ID = D.APPLIED_CUSTOMER_TRX_ID
409: AND C.CASH_RECEIPT_ID = D.CASH_RECEIPT_ID
410: AND E.SOURCE_ID = D.RECEIVABLE_APPLICATION_ID

Line 423: AR_RECEIVABLE_APPLICATIONS_ALL D,

419: SUM(E.ACCTD_AMOUNT_DR) SUM_EXCHANGE_AMOUNT
420: FROM
421: RA_CUSTOMER_TRX_ALL B,
422: AR_CASH_RECEIPTS_ALL C,
423: AR_RECEIVABLE_APPLICATIONS_ALL D,
424: AR_DISTRIBUTIONS_ALL E
425: WHERE B.CUSTOMER_TRX_ID = D.APPLIED_CUSTOMER_TRX_ID
426: AND C.CASH_RECEIPT_ID = D.CASH_RECEIPT_ID
427: AND E.SOURCE_ID = D.RECEIVABLE_APPLICATION_ID

Line 441: AR_RECEIVABLE_APPLICATIONS_ALL C

437: ,1.00)) SUM_AMOUNT_EXCHANGE
438: FROM
439: AR_CASH_RECEIPTS_ALL A,
440: AR_CASH_RECEIPT_HISTORY_ALL B,
441: AR_RECEIVABLE_APPLICATIONS_ALL C
442: WHERE A.PAY_FROM_CUSTOMER = CUSTOMER_ID2
443: AND TRUNC(B.GL_DATE) <= TRUNC(P_END_DATE)
444: AND A.CASH_RECEIPT_ID = B.CASH_RECEIPT_ID
445: AND A.CASH_RECEIPT_ID = C.CASH_RECEIPT_ID