[Home] [Help]
12: SUM((B.AMOUNT)) SUM_EXT_AMOUNT,
13: SUM((B.AMOUNT) * NVL(A.EXCHANGE_RATE
14: ,1))
15: FROM
16: RA_CUSTOMER_TRX_ALL A,
17: AR_PAYMENT_SCHEDULES_ALL C,
18: RA_CUST_TRX_LINE_GL_DIST_ALL B
19: WHERE A.BILL_TO_CUSTOMER_ID = CUSTOMER_ID
20: AND TRUNC(C.GL_DATE) < TRUNC(P_START_DATE)
38: SUM((B.AMOUNT) * NVL(C.EXCHANGE_RATE
39: ,1))
40: FROM
41: AR_ADJUSTMENTS_ALL B,
42: RA_CUSTOMER_TRX_ALL C,
43: AR_PAYMENT_SCHEDULES_ALL D,
44: GL_CODE_COMBINATIONS E
45: WHERE B.CUSTOMER_TRX_ID = C.CUSTOMER_TRX_ID
46: AND C.BILL_TO_CUSTOMER_ID = CUSTOMER_ID
97: NVL(SUM(ABS(NVL(D.ACCTD_EARNED_DISCOUNT_TAKEN
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)
114: SELECT
115: SUM(E.AMOUNT_CR) SUM_AMOUNT,
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
131: SELECT
132: SUM(E.AMOUNT_DR) SUM_AMOUNT,
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
198: SUM((B.AMOUNT) * NVL(A.EXCHANGE_RATE
199: ,1))
200: INTO V_CRE_MEMO_AMT,V_CRE_MEMO_FUNC_AMT
201: FROM
202: RA_CUSTOMER_TRX_ALL A,
203: AR_PAYMENT_SCHEDULES_ALL C,
204: RA_CUST_TRX_LINE_GL_DIST_ALL B
205: WHERE A.BILL_TO_CUSTOMER_ID = CUSTOMER_ID
206: AND TRUNC(C.GL_DATE) < TRUNC(P_START_DATE)
298: SUM((B.AMOUNT)) SUM_EXT_AMOUNT,
299: SUM((B.AMOUNT) * NVL(A.EXCHANGE_RATE
300: ,1))
301: FROM
302: RA_CUSTOMER_TRX_ALL A,
303: AR_PAYMENT_SCHEDULES_ALL C,
304: RA_CUST_TRX_LINE_GL_DIST_ALL B
305: WHERE A.BILL_TO_CUSTOMER_ID = CUSTOMER_ID2
306: AND TRUNC(C.GL_DATE) <= TRUNC(P_END_DATE)
324: SUM((B.AMOUNT) * NVL(C.EXCHANGE_RATE
325: ,1))
326: FROM
327: AR_ADJUSTMENTS_ALL B,
328: RA_CUSTOMER_TRX_ALL C,
329: AR_PAYMENT_SCHEDULES_ALL D,
330: GL_CODE_COMBINATIONS E
331: WHERE B.CUSTOMER_TRX_ID = C.CUSTOMER_TRX_ID
332: AND E.CODE_COMBINATION_ID = B.CODE_COMBINATION_ID
383: NVL(SUM(ABS(NVL(D.ACCTD_EARNED_DISCOUNT_TAKEN
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)
400: SELECT
401: SUM(E.AMOUNT_CR) SUM_AMOUNT,
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
417: SELECT
418: SUM(E.AMOUNT_DR) SUM_AMOUNT,
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
484: SUM((B.AMOUNT) * NVL(A.EXCHANGE_RATE
485: ,1))
486: INTO V_CRE_MEMO_AMT,V_CRE_MEMO_FUNC_AMT
487: FROM
488: RA_CUSTOMER_TRX_ALL A,
489: AR_PAYMENT_SCHEDULES_ALL C,
490: RA_CUST_TRX_LINE_GL_DIST_ALL B
491: WHERE A.BILL_TO_CUSTOMER_ID = CUSTOMER_ID2
492: AND TRUNC(C.GL_DATE) <= TRUNC(P_END_DATE)
577: CURSOR GET_ORDER_DETAILS IS
578: SELECT
579: INTERFACE_HEADER_ATTRIBUTE1
580: FROM
581: RA_CUSTOMER_TRX_ALL
582: WHERE CUSTOMER_TRX_ID = CUSTOMER_TRX_ID_1
583: AND NVL(CREATED_FROM
584: ,'###') = 'RAXTRX';
585: V_ORDER_NUMBER VARCHAR2(30);