131: tag number; /* bug 5724171*/
132:
133:
134: begin
135: fa_rx_util_pkg.debug('arrx_rc.before_report()+');
136:
137: -- define common lexical params and assign_column
138:
139: fa_rx_util_pkg.debug('Get SOB ID'||var.books_id);
135: fa_rx_util_pkg.debug('arrx_rc.before_report()+');
136:
137: -- define common lexical params and assign_column
138:
139: fa_rx_util_pkg.debug('Get SOB ID'||var.books_id);
140:
141: /*Bug 5244313
142: IF var.ca_sob_type = 'P'
143: THEN
149: */
150: --
151: -- Get CHART_OF_ACCOUNTS_ID
152: --
153: fa_rx_util_pkg.debug('Get COA ID');
154:
155: select CHART_OF_ACCOUNTS_ID,CURRENCY_CODE,NAME
156: into var.chart_of_accounts_id,var.currency_code,var.org_name
157: from GL_SETS_OF_BOOKS
159:
160: --
161: -- Figure out NOCOPY the where clause for the parameters
162: --
163: fa_rx_util_pkg.debug('Build Where clauses based on parameters');
164:
165: IF var.p_batch_name_low IS NULL AND var.p_batch_name_high IS NULL THEN
166: BATCH_NAME_WHERE := NULL;
167: ELSIF var.p_batch_name_low IS NULL THEN
200: CUSTOMER_NAME_WHERE := ' AND substrb(PARTY.PARTY_NAME,1,:len1) >= :p_customer_name_low ' ||
201: ' AND substrb(PARTY.PARTY_NAME,1,:len2) <= :p_customer_name_high';
202: END IF;
203:
204: fa_rx_util_pkg.debug('CUSTOMER_NAME_WHERE = ' || CUSTOMER_NAME_WHERE);
205:
206: IF var.p_deposit_date_low IS NULL AND var.p_deposit_date_high IS NULL THEN
207: DEPOSIT_DATE_WHERE := NULL;
208: ELSIF var.p_deposit_date_low IS NULL THEN
342: DOC_SEQUENCE_NUMBER_WHERE := ' AND CR.DOC_SEQUENCE_VALUE between '''|| var.p_doc_sequence_number_from ||
343: ''' AND '''|| var.p_doc_sequence_number_to ||'''';
344: END IF;
345:
346: fa_rx_util_pkg.debug('Define DECODE strings');
347:
348: DECODE_CR_TYPE := 'DECODE(CR.TYPE,''CASH'',:L_CASH,''MISC'',:L_MISC)';
349: DECODE_CR_STATUS := 'DECODE(CR.STATUS,''APP'',:L_APP,''NSF'',:L_NSF,''REV'',:L_REV,''STOP'',:L_STOP, ' ||
350: ' ''UNAPP'',:L_UNAPP,''UNID'',:L_UNID)';
374: DECODE_CRH_FD_AMOUNT := 'DECODE(CRH.STATUS,''REVERSED'',CRH.FACTOR_DISCOUNT_AMOUNT*-1,CRH.FACTOR_DISCOUNT_AMOUNT)';
375: DECODE_CRH_AFD_AMOUNT := 'DECODE(CRH.STATUS,''REVERSED'',CRH.ACCTD_FACTOR_DISCOUNT_AMOUNT*-1,CRH.ACCTD_FACTOR_DISCOUNT_AMOUNT)';
376: END IF;
377:
378: fa_rx_util_pkg.debug('Start Assign_columns');
379: -- fa_rx_util_pkg.assign_column(unique seq#, select field, field in itf, into variable, type, len);
380:
381: fa_rx_util_pkg.assign_column('10 ',null ,'ORGANIZATION_NAME' ,
382: 'arrx_rc.var.organization_name' ,'VARCHAR2', 50);
375: DECODE_CRH_AFD_AMOUNT := 'DECODE(CRH.STATUS,''REVERSED'',CRH.ACCTD_FACTOR_DISCOUNT_AMOUNT*-1,CRH.ACCTD_FACTOR_DISCOUNT_AMOUNT)';
376: END IF;
377:
378: fa_rx_util_pkg.debug('Start Assign_columns');
379: -- fa_rx_util_pkg.assign_column(unique seq#, select field, field in itf, into variable, type, len);
380:
381: fa_rx_util_pkg.assign_column('10 ',null ,'ORGANIZATION_NAME' ,
382: 'arrx_rc.var.organization_name' ,'VARCHAR2', 50);
383: fa_rx_util_pkg.assign_column('20 ',null ,'FUNCTIONAL_CURRENCY_CODE' ,
377:
378: fa_rx_util_pkg.debug('Start Assign_columns');
379: -- fa_rx_util_pkg.assign_column(unique seq#, select field, field in itf, into variable, type, len);
380:
381: fa_rx_util_pkg.assign_column('10 ',null ,'ORGANIZATION_NAME' ,
382: 'arrx_rc.var.organization_name' ,'VARCHAR2', 50);
383: fa_rx_util_pkg.assign_column('20 ',null ,'FUNCTIONAL_CURRENCY_CODE' ,
384: 'arrx_rc.var.functional_currency_code' ,'VARCHAR2', 15);
385: fa_rx_util_pkg.assign_column('30 ','CR.STATUS' ,null ,
379: -- fa_rx_util_pkg.assign_column(unique seq#, select field, field in itf, into variable, type, len);
380:
381: fa_rx_util_pkg.assign_column('10 ',null ,'ORGANIZATION_NAME' ,
382: 'arrx_rc.var.organization_name' ,'VARCHAR2', 50);
383: fa_rx_util_pkg.assign_column('20 ',null ,'FUNCTIONAL_CURRENCY_CODE' ,
384: 'arrx_rc.var.functional_currency_code' ,'VARCHAR2', 15);
385: fa_rx_util_pkg.assign_column('30 ','CR.STATUS' ,null ,
386: 'arrx_rc.var.cr_status' ,'VARCHAR2', 40);
387: fa_rx_util_pkg.assign_column('40 ','CRH.STATUS' ,null ,
381: fa_rx_util_pkg.assign_column('10 ',null ,'ORGANIZATION_NAME' ,
382: 'arrx_rc.var.organization_name' ,'VARCHAR2', 50);
383: fa_rx_util_pkg.assign_column('20 ',null ,'FUNCTIONAL_CURRENCY_CODE' ,
384: 'arrx_rc.var.functional_currency_code' ,'VARCHAR2', 15);
385: fa_rx_util_pkg.assign_column('30 ','CR.STATUS' ,null ,
386: 'arrx_rc.var.cr_status' ,'VARCHAR2', 40);
387: fa_rx_util_pkg.assign_column('40 ','CRH.STATUS' ,null ,
388: 'arrx_rc.var.crh_status' ,'VARCHAR2', 40);
389: fa_rx_util_pkg.assign_column('50 ','DECODE(CRH.STATUS, ''REVERSED'', BATCHFIRST.BATCH_ID, BATCH.BATCH_ID)','BATCH_ID' ,
383: fa_rx_util_pkg.assign_column('20 ',null ,'FUNCTIONAL_CURRENCY_CODE' ,
384: 'arrx_rc.var.functional_currency_code' ,'VARCHAR2', 15);
385: fa_rx_util_pkg.assign_column('30 ','CR.STATUS' ,null ,
386: 'arrx_rc.var.cr_status' ,'VARCHAR2', 40);
387: fa_rx_util_pkg.assign_column('40 ','CRH.STATUS' ,null ,
388: 'arrx_rc.var.crh_status' ,'VARCHAR2', 40);
389: fa_rx_util_pkg.assign_column('50 ','DECODE(CRH.STATUS, ''REVERSED'', BATCHFIRST.BATCH_ID, BATCH.BATCH_ID)','BATCH_ID' ,
390: 'arrx_rc.var.batch_id' ,'NUMBER');
391: fa_rx_util_pkg.assign_column('60 ','DECODE(CRH.STATUS, ''REVERSED'', BATCHFIRST.NAME, BATCH.NAME)','BATCH_NAME' ,
385: fa_rx_util_pkg.assign_column('30 ','CR.STATUS' ,null ,
386: 'arrx_rc.var.cr_status' ,'VARCHAR2', 40);
387: fa_rx_util_pkg.assign_column('40 ','CRH.STATUS' ,null ,
388: 'arrx_rc.var.crh_status' ,'VARCHAR2', 40);
389: fa_rx_util_pkg.assign_column('50 ','DECODE(CRH.STATUS, ''REVERSED'', BATCHFIRST.BATCH_ID, BATCH.BATCH_ID)','BATCH_ID' ,
390: 'arrx_rc.var.batch_id' ,'NUMBER');
391: fa_rx_util_pkg.assign_column('60 ','DECODE(CRH.STATUS, ''REVERSED'', BATCHFIRST.NAME, BATCH.NAME)','BATCH_NAME' ,
392: 'arrx_rc.var.batch_name' ,'VARCHAR2', 20);
393: fa_rx_util_pkg.assign_column('70 ','CR.CASH_RECEIPT_ID' ,'CASH_RECEIPT_ID' ,
387: fa_rx_util_pkg.assign_column('40 ','CRH.STATUS' ,null ,
388: 'arrx_rc.var.crh_status' ,'VARCHAR2', 40);
389: fa_rx_util_pkg.assign_column('50 ','DECODE(CRH.STATUS, ''REVERSED'', BATCHFIRST.BATCH_ID, BATCH.BATCH_ID)','BATCH_ID' ,
390: 'arrx_rc.var.batch_id' ,'NUMBER');
391: fa_rx_util_pkg.assign_column('60 ','DECODE(CRH.STATUS, ''REVERSED'', BATCHFIRST.NAME, BATCH.NAME)','BATCH_NAME' ,
392: 'arrx_rc.var.batch_name' ,'VARCHAR2', 20);
393: fa_rx_util_pkg.assign_column('70 ','CR.CASH_RECEIPT_ID' ,'CASH_RECEIPT_ID' ,
394: 'arrx_rc.var.cash_receipt_id' ,'NUMBER');
395: fa_rx_util_pkg.assign_column('80 ','CR.RECEIPT_NUMBER' ,'RECEIPT_NUMBER' ,
389: fa_rx_util_pkg.assign_column('50 ','DECODE(CRH.STATUS, ''REVERSED'', BATCHFIRST.BATCH_ID, BATCH.BATCH_ID)','BATCH_ID' ,
390: 'arrx_rc.var.batch_id' ,'NUMBER');
391: fa_rx_util_pkg.assign_column('60 ','DECODE(CRH.STATUS, ''REVERSED'', BATCHFIRST.NAME, BATCH.NAME)','BATCH_NAME' ,
392: 'arrx_rc.var.batch_name' ,'VARCHAR2', 20);
393: fa_rx_util_pkg.assign_column('70 ','CR.CASH_RECEIPT_ID' ,'CASH_RECEIPT_ID' ,
394: 'arrx_rc.var.cash_receipt_id' ,'NUMBER');
395: fa_rx_util_pkg.assign_column('80 ','CR.RECEIPT_NUMBER' ,'RECEIPT_NUMBER' ,
396: 'arrx_rc.var.receipt_number' ,'VARCHAR2', 30);
397: fa_rx_util_pkg.assign_column('90 ','CR.CURRENCY_CODE' ,'RECEIPT_CURRENCY_CODE' ,
391: fa_rx_util_pkg.assign_column('60 ','DECODE(CRH.STATUS, ''REVERSED'', BATCHFIRST.NAME, BATCH.NAME)','BATCH_NAME' ,
392: 'arrx_rc.var.batch_name' ,'VARCHAR2', 20);
393: fa_rx_util_pkg.assign_column('70 ','CR.CASH_RECEIPT_ID' ,'CASH_RECEIPT_ID' ,
394: 'arrx_rc.var.cash_receipt_id' ,'NUMBER');
395: fa_rx_util_pkg.assign_column('80 ','CR.RECEIPT_NUMBER' ,'RECEIPT_NUMBER' ,
396: 'arrx_rc.var.receipt_number' ,'VARCHAR2', 30);
397: fa_rx_util_pkg.assign_column('90 ','CR.CURRENCY_CODE' ,'RECEIPT_CURRENCY_CODE' ,
398: 'arrx_rc.var.receipt_currency_code' ,'VARCHAR2', 15);
399: fa_rx_util_pkg.assign_column('100','CR.EXCHANGE_RATE' ,'EXCHANGE_RATE' ,
393: fa_rx_util_pkg.assign_column('70 ','CR.CASH_RECEIPT_ID' ,'CASH_RECEIPT_ID' ,
394: 'arrx_rc.var.cash_receipt_id' ,'NUMBER');
395: fa_rx_util_pkg.assign_column('80 ','CR.RECEIPT_NUMBER' ,'RECEIPT_NUMBER' ,
396: 'arrx_rc.var.receipt_number' ,'VARCHAR2', 30);
397: fa_rx_util_pkg.assign_column('90 ','CR.CURRENCY_CODE' ,'RECEIPT_CURRENCY_CODE' ,
398: 'arrx_rc.var.receipt_currency_code' ,'VARCHAR2', 15);
399: fa_rx_util_pkg.assign_column('100','CR.EXCHANGE_RATE' ,'EXCHANGE_RATE' ,
400: 'arrx_rc.var.exchange_rate' ,'NUMBER');
401: fa_rx_util_pkg.assign_column('110','CR.EXCHANGE_DATE' ,'EXCHANGE_DATE' ,
395: fa_rx_util_pkg.assign_column('80 ','CR.RECEIPT_NUMBER' ,'RECEIPT_NUMBER' ,
396: 'arrx_rc.var.receipt_number' ,'VARCHAR2', 30);
397: fa_rx_util_pkg.assign_column('90 ','CR.CURRENCY_CODE' ,'RECEIPT_CURRENCY_CODE' ,
398: 'arrx_rc.var.receipt_currency_code' ,'VARCHAR2', 15);
399: fa_rx_util_pkg.assign_column('100','CR.EXCHANGE_RATE' ,'EXCHANGE_RATE' ,
400: 'arrx_rc.var.exchange_rate' ,'NUMBER');
401: fa_rx_util_pkg.assign_column('110','CR.EXCHANGE_DATE' ,'EXCHANGE_DATE' ,
402: 'arrx_rc.var.exchange_date' ,'DATE');
403: fa_rx_util_pkg.assign_column('120','CR.EXCHANGE_RATE_TYPE' ,'EXCHANGE_TYPE' ,
397: fa_rx_util_pkg.assign_column('90 ','CR.CURRENCY_CODE' ,'RECEIPT_CURRENCY_CODE' ,
398: 'arrx_rc.var.receipt_currency_code' ,'VARCHAR2', 15);
399: fa_rx_util_pkg.assign_column('100','CR.EXCHANGE_RATE' ,'EXCHANGE_RATE' ,
400: 'arrx_rc.var.exchange_rate' ,'NUMBER');
401: fa_rx_util_pkg.assign_column('110','CR.EXCHANGE_DATE' ,'EXCHANGE_DATE' ,
402: 'arrx_rc.var.exchange_date' ,'DATE');
403: fa_rx_util_pkg.assign_column('120','CR.EXCHANGE_RATE_TYPE' ,'EXCHANGE_TYPE' ,
404: 'arrx_rc.var.exchange_type' ,'VARCHAR2', 30);
405: fa_rx_util_pkg.assign_column('130','DOCSEQ.NAME' ,'DOC_SEQUENCE_NAME' ,
399: fa_rx_util_pkg.assign_column('100','CR.EXCHANGE_RATE' ,'EXCHANGE_RATE' ,
400: 'arrx_rc.var.exchange_rate' ,'NUMBER');
401: fa_rx_util_pkg.assign_column('110','CR.EXCHANGE_DATE' ,'EXCHANGE_DATE' ,
402: 'arrx_rc.var.exchange_date' ,'DATE');
403: fa_rx_util_pkg.assign_column('120','CR.EXCHANGE_RATE_TYPE' ,'EXCHANGE_TYPE' ,
404: 'arrx_rc.var.exchange_type' ,'VARCHAR2', 30);
405: fa_rx_util_pkg.assign_column('130','DOCSEQ.NAME' ,'DOC_SEQUENCE_NAME' ,
406: 'arrx_rc.var.doc_sequence_name' ,'VARCHAR2', 30);
407: fa_rx_util_pkg.assign_column('140','CR.DOC_SEQUENCE_VALUE' ,'DOC_SEQUENCE_VALUE' ,
401: fa_rx_util_pkg.assign_column('110','CR.EXCHANGE_DATE' ,'EXCHANGE_DATE' ,
402: 'arrx_rc.var.exchange_date' ,'DATE');
403: fa_rx_util_pkg.assign_column('120','CR.EXCHANGE_RATE_TYPE' ,'EXCHANGE_TYPE' ,
404: 'arrx_rc.var.exchange_type' ,'VARCHAR2', 30);
405: fa_rx_util_pkg.assign_column('130','DOCSEQ.NAME' ,'DOC_SEQUENCE_NAME' ,
406: 'arrx_rc.var.doc_sequence_name' ,'VARCHAR2', 30);
407: fa_rx_util_pkg.assign_column('140','CR.DOC_SEQUENCE_VALUE' ,'DOC_SEQUENCE_VALUE' ,
408: 'arrx_rc.var.doc_sequence_value' ,'NUMBER');
409: fa_rx_util_pkg.assign_column('150','CR.DEPOSIT_DATE' ,'DEPOSIT_DATE' ,
403: fa_rx_util_pkg.assign_column('120','CR.EXCHANGE_RATE_TYPE' ,'EXCHANGE_TYPE' ,
404: 'arrx_rc.var.exchange_type' ,'VARCHAR2', 30);
405: fa_rx_util_pkg.assign_column('130','DOCSEQ.NAME' ,'DOC_SEQUENCE_NAME' ,
406: 'arrx_rc.var.doc_sequence_name' ,'VARCHAR2', 30);
407: fa_rx_util_pkg.assign_column('140','CR.DOC_SEQUENCE_VALUE' ,'DOC_SEQUENCE_VALUE' ,
408: 'arrx_rc.var.doc_sequence_value' ,'NUMBER');
409: fa_rx_util_pkg.assign_column('150','CR.DEPOSIT_DATE' ,'DEPOSIT_DATE' ,
410: 'arrx_rc.var.deposit_date' ,'DATE');
411: fa_rx_util_pkg.assign_column('160','CR.RECEIPT_DATE' ,'RECEIPT_DATE' ,
405: fa_rx_util_pkg.assign_column('130','DOCSEQ.NAME' ,'DOC_SEQUENCE_NAME' ,
406: 'arrx_rc.var.doc_sequence_name' ,'VARCHAR2', 30);
407: fa_rx_util_pkg.assign_column('140','CR.DOC_SEQUENCE_VALUE' ,'DOC_SEQUENCE_VALUE' ,
408: 'arrx_rc.var.doc_sequence_value' ,'NUMBER');
409: fa_rx_util_pkg.assign_column('150','CR.DEPOSIT_DATE' ,'DEPOSIT_DATE' ,
410: 'arrx_rc.var.deposit_date' ,'DATE');
411: fa_rx_util_pkg.assign_column('160','CR.RECEIPT_DATE' ,'RECEIPT_DATE' ,
412: 'arrx_rc.var.receipt_date' ,'DATE');
413: fa_rx_util_pkg.assign_column('170',DECODE_CR_TYPE ,'RECEIPT_TYPE' ,
407: fa_rx_util_pkg.assign_column('140','CR.DOC_SEQUENCE_VALUE' ,'DOC_SEQUENCE_VALUE' ,
408: 'arrx_rc.var.doc_sequence_value' ,'NUMBER');
409: fa_rx_util_pkg.assign_column('150','CR.DEPOSIT_DATE' ,'DEPOSIT_DATE' ,
410: 'arrx_rc.var.deposit_date' ,'DATE');
411: fa_rx_util_pkg.assign_column('160','CR.RECEIPT_DATE' ,'RECEIPT_DATE' ,
412: 'arrx_rc.var.receipt_date' ,'DATE');
413: fa_rx_util_pkg.assign_column('170',DECODE_CR_TYPE ,'RECEIPT_TYPE' ,
414: 'arrx_rc.var.receipt_type' ,'VARCHAR2', 30);
415: fa_rx_util_pkg.assign_column('180',DECODE_CR_STATUS ,'RECEIPT_STATUS' ,
409: fa_rx_util_pkg.assign_column('150','CR.DEPOSIT_DATE' ,'DEPOSIT_DATE' ,
410: 'arrx_rc.var.deposit_date' ,'DATE');
411: fa_rx_util_pkg.assign_column('160','CR.RECEIPT_DATE' ,'RECEIPT_DATE' ,
412: 'arrx_rc.var.receipt_date' ,'DATE');
413: fa_rx_util_pkg.assign_column('170',DECODE_CR_TYPE ,'RECEIPT_TYPE' ,
414: 'arrx_rc.var.receipt_type' ,'VARCHAR2', 30);
415: fa_rx_util_pkg.assign_column('180',DECODE_CR_STATUS ,'RECEIPT_STATUS' ,
416: 'arrx_rc.var.receipt_status' ,'VARCHAR2', 40);
417: fa_rx_util_pkg.assign_column('190','CR.MISC_PAYMENT_SOURCE' ,'MISC_PAYMENT_SOURCE' ,
411: fa_rx_util_pkg.assign_column('160','CR.RECEIPT_DATE' ,'RECEIPT_DATE' ,
412: 'arrx_rc.var.receipt_date' ,'DATE');
413: fa_rx_util_pkg.assign_column('170',DECODE_CR_TYPE ,'RECEIPT_TYPE' ,
414: 'arrx_rc.var.receipt_type' ,'VARCHAR2', 30);
415: fa_rx_util_pkg.assign_column('180',DECODE_CR_STATUS ,'RECEIPT_STATUS' ,
416: 'arrx_rc.var.receipt_status' ,'VARCHAR2', 40);
417: fa_rx_util_pkg.assign_column('190','CR.MISC_PAYMENT_SOURCE' ,'MISC_PAYMENT_SOURCE' ,
418: 'arrx_rc.var.misc_payment_source' ,'VARCHAR2', 30);
419: fa_rx_util_pkg.assign_column('200','TAX.TAX_CODE' ,'TAX_CODE' ,
413: fa_rx_util_pkg.assign_column('170',DECODE_CR_TYPE ,'RECEIPT_TYPE' ,
414: 'arrx_rc.var.receipt_type' ,'VARCHAR2', 30);
415: fa_rx_util_pkg.assign_column('180',DECODE_CR_STATUS ,'RECEIPT_STATUS' ,
416: 'arrx_rc.var.receipt_status' ,'VARCHAR2', 40);
417: fa_rx_util_pkg.assign_column('190','CR.MISC_PAYMENT_SOURCE' ,'MISC_PAYMENT_SOURCE' ,
418: 'arrx_rc.var.misc_payment_source' ,'VARCHAR2', 30);
419: fa_rx_util_pkg.assign_column('200','TAX.TAX_CODE' ,'TAX_CODE' ,
420: 'arrx_rc.var.tax_code' ,'VARCHAR2', 50);
421: fa_rx_util_pkg.assign_column('210',DECODE_CR_REFERENCE_TYPE ,'REFERENCE_TYPE' ,
415: fa_rx_util_pkg.assign_column('180',DECODE_CR_STATUS ,'RECEIPT_STATUS' ,
416: 'arrx_rc.var.receipt_status' ,'VARCHAR2', 40);
417: fa_rx_util_pkg.assign_column('190','CR.MISC_PAYMENT_SOURCE' ,'MISC_PAYMENT_SOURCE' ,
418: 'arrx_rc.var.misc_payment_source' ,'VARCHAR2', 30);
419: fa_rx_util_pkg.assign_column('200','TAX.TAX_CODE' ,'TAX_CODE' ,
420: 'arrx_rc.var.tax_code' ,'VARCHAR2', 50);
421: fa_rx_util_pkg.assign_column('210',DECODE_CR_REFERENCE_TYPE ,'REFERENCE_TYPE' ,
422: 'arrx_rc.var.reference_type' ,'VARCHAR2', 30);
423: fa_rx_util_pkg.assign_column('220','CR.ANTICIPATED_CLEARING_DATE' ,'ANTICIPATED_CLEARING_DATE' ,
417: fa_rx_util_pkg.assign_column('190','CR.MISC_PAYMENT_SOURCE' ,'MISC_PAYMENT_SOURCE' ,
418: 'arrx_rc.var.misc_payment_source' ,'VARCHAR2', 30);
419: fa_rx_util_pkg.assign_column('200','TAX.TAX_CODE' ,'TAX_CODE' ,
420: 'arrx_rc.var.tax_code' ,'VARCHAR2', 50);
421: fa_rx_util_pkg.assign_column('210',DECODE_CR_REFERENCE_TYPE ,'REFERENCE_TYPE' ,
422: 'arrx_rc.var.reference_type' ,'VARCHAR2', 30);
423: fa_rx_util_pkg.assign_column('220','CR.ANTICIPATED_CLEARING_DATE' ,'ANTICIPATED_CLEARING_DATE' ,
424: 'arrx_rc.var.anticipated_clearing_date' ,'DATE');
425: fa_rx_util_pkg.assign_column('230','ABB.BANK_NAME' ,'BANK_NAME' ,
419: fa_rx_util_pkg.assign_column('200','TAX.TAX_CODE' ,'TAX_CODE' ,
420: 'arrx_rc.var.tax_code' ,'VARCHAR2', 50);
421: fa_rx_util_pkg.assign_column('210',DECODE_CR_REFERENCE_TYPE ,'REFERENCE_TYPE' ,
422: 'arrx_rc.var.reference_type' ,'VARCHAR2', 30);
423: fa_rx_util_pkg.assign_column('220','CR.ANTICIPATED_CLEARING_DATE' ,'ANTICIPATED_CLEARING_DATE' ,
424: 'arrx_rc.var.anticipated_clearing_date' ,'DATE');
425: fa_rx_util_pkg.assign_column('230','ABB.BANK_NAME' ,'BANK_NAME' ,
426: 'arrx_rc.var.bank_name' ,'VARCHAR2', 60);
427: fa_rx_util_pkg.assign_column('240','ABB.BANK_NAME_ALT' ,'BANK_NAME_ALT' ,
421: fa_rx_util_pkg.assign_column('210',DECODE_CR_REFERENCE_TYPE ,'REFERENCE_TYPE' ,
422: 'arrx_rc.var.reference_type' ,'VARCHAR2', 30);
423: fa_rx_util_pkg.assign_column('220','CR.ANTICIPATED_CLEARING_DATE' ,'ANTICIPATED_CLEARING_DATE' ,
424: 'arrx_rc.var.anticipated_clearing_date' ,'DATE');
425: fa_rx_util_pkg.assign_column('230','ABB.BANK_NAME' ,'BANK_NAME' ,
426: 'arrx_rc.var.bank_name' ,'VARCHAR2', 60);
427: fa_rx_util_pkg.assign_column('240','ABB.BANK_NAME_ALT' ,'BANK_NAME_ALT' ,
428: 'arrx_rc.var.bank_name_alt' ,'VARCHAR2',320);
429: fa_rx_util_pkg.assign_column('250','ABB.BANK_BRANCH_NAME' ,'BANK_BRANCH_NAME' ,
423: fa_rx_util_pkg.assign_column('220','CR.ANTICIPATED_CLEARING_DATE' ,'ANTICIPATED_CLEARING_DATE' ,
424: 'arrx_rc.var.anticipated_clearing_date' ,'DATE');
425: fa_rx_util_pkg.assign_column('230','ABB.BANK_NAME' ,'BANK_NAME' ,
426: 'arrx_rc.var.bank_name' ,'VARCHAR2', 60);
427: fa_rx_util_pkg.assign_column('240','ABB.BANK_NAME_ALT' ,'BANK_NAME_ALT' ,
428: 'arrx_rc.var.bank_name_alt' ,'VARCHAR2',320);
429: fa_rx_util_pkg.assign_column('250','ABB.BANK_BRANCH_NAME' ,'BANK_BRANCH_NAME' ,
430: 'arrx_rc.var.bank_branch_name' ,'VARCHAR2', 60);
431: fa_rx_util_pkg.assign_column('260','ABB.BANK_BRANCH_NAME_ALT' ,'BANK_BRANCH_NAME_ALT' ,
425: fa_rx_util_pkg.assign_column('230','ABB.BANK_NAME' ,'BANK_NAME' ,
426: 'arrx_rc.var.bank_name' ,'VARCHAR2', 60);
427: fa_rx_util_pkg.assign_column('240','ABB.BANK_NAME_ALT' ,'BANK_NAME_ALT' ,
428: 'arrx_rc.var.bank_name_alt' ,'VARCHAR2',320);
429: fa_rx_util_pkg.assign_column('250','ABB.BANK_BRANCH_NAME' ,'BANK_BRANCH_NAME' ,
430: 'arrx_rc.var.bank_branch_name' ,'VARCHAR2', 60);
431: fa_rx_util_pkg.assign_column('260','ABB.BANK_BRANCH_NAME_ALT' ,'BANK_BRANCH_NAME_ALT' ,
432: 'arrx_rc.var.bank_branch_name_alt' ,'VARCHAR2',320);
433: fa_rx_util_pkg.assign_column('270','ABB.BANK_NUMBER' ,'BANK_NUMBER' ,
427: fa_rx_util_pkg.assign_column('240','ABB.BANK_NAME_ALT' ,'BANK_NAME_ALT' ,
428: 'arrx_rc.var.bank_name_alt' ,'VARCHAR2',320);
429: fa_rx_util_pkg.assign_column('250','ABB.BANK_BRANCH_NAME' ,'BANK_BRANCH_NAME' ,
430: 'arrx_rc.var.bank_branch_name' ,'VARCHAR2', 60);
431: fa_rx_util_pkg.assign_column('260','ABB.BANK_BRANCH_NAME_ALT' ,'BANK_BRANCH_NAME_ALT' ,
432: 'arrx_rc.var.bank_branch_name_alt' ,'VARCHAR2',320);
433: fa_rx_util_pkg.assign_column('270','ABB.BANK_NUMBER' ,'BANK_NUMBER' ,
434: 'arrx_rc.var.bank_number' ,'VARCHAR2', 30);
435: fa_rx_util_pkg.assign_column('280','ABB.BRANCH_NUMBER' ,'BANK_BRANCH_NUMBER' ,
429: fa_rx_util_pkg.assign_column('250','ABB.BANK_BRANCH_NAME' ,'BANK_BRANCH_NAME' ,
430: 'arrx_rc.var.bank_branch_name' ,'VARCHAR2', 60);
431: fa_rx_util_pkg.assign_column('260','ABB.BANK_BRANCH_NAME_ALT' ,'BANK_BRANCH_NAME_ALT' ,
432: 'arrx_rc.var.bank_branch_name_alt' ,'VARCHAR2',320);
433: fa_rx_util_pkg.assign_column('270','ABB.BANK_NUMBER' ,'BANK_NUMBER' ,
434: 'arrx_rc.var.bank_number' ,'VARCHAR2', 30);
435: fa_rx_util_pkg.assign_column('280','ABB.BRANCH_NUMBER' ,'BANK_BRANCH_NUMBER' ,
436: 'arrx_rc.var.bank_branch_number' ,'VARCHAR2', 25);
437: fa_rx_util_pkg.assign_column('290','CBA.BANK_ACCOUNT_NAME' ,'BANK_ACCOUNT_NAME' ,
431: fa_rx_util_pkg.assign_column('260','ABB.BANK_BRANCH_NAME_ALT' ,'BANK_BRANCH_NAME_ALT' ,
432: 'arrx_rc.var.bank_branch_name_alt' ,'VARCHAR2',320);
433: fa_rx_util_pkg.assign_column('270','ABB.BANK_NUMBER' ,'BANK_NUMBER' ,
434: 'arrx_rc.var.bank_number' ,'VARCHAR2', 30);
435: fa_rx_util_pkg.assign_column('280','ABB.BRANCH_NUMBER' ,'BANK_BRANCH_NUMBER' ,
436: 'arrx_rc.var.bank_branch_number' ,'VARCHAR2', 25);
437: fa_rx_util_pkg.assign_column('290','CBA.BANK_ACCOUNT_NAME' ,'BANK_ACCOUNT_NAME' ,
438: 'arrx_rc.var.bank_account_name' ,'VARCHAR2', 80);
439: fa_rx_util_pkg.assign_column('300','CBA.BANK_ACCOUNT_NAME_ALT' ,'BANK_ACCOUNT_NAME_ALT' ,
433: fa_rx_util_pkg.assign_column('270','ABB.BANK_NUMBER' ,'BANK_NUMBER' ,
434: 'arrx_rc.var.bank_number' ,'VARCHAR2', 30);
435: fa_rx_util_pkg.assign_column('280','ABB.BRANCH_NUMBER' ,'BANK_BRANCH_NUMBER' ,
436: 'arrx_rc.var.bank_branch_number' ,'VARCHAR2', 25);
437: fa_rx_util_pkg.assign_column('290','CBA.BANK_ACCOUNT_NAME' ,'BANK_ACCOUNT_NAME' ,
438: 'arrx_rc.var.bank_account_name' ,'VARCHAR2', 80);
439: fa_rx_util_pkg.assign_column('300','CBA.BANK_ACCOUNT_NAME_ALT' ,'BANK_ACCOUNT_NAME_ALT' ,
440: 'arrx_rc.var.bank_account_name_alt' ,'VARCHAR2',320);
441: fa_rx_util_pkg.assign_column('310','CBA.CURRENCY_CODE' ,'BANK_ACCOUNT_CURRENCY' ,
435: fa_rx_util_pkg.assign_column('280','ABB.BRANCH_NUMBER' ,'BANK_BRANCH_NUMBER' ,
436: 'arrx_rc.var.bank_branch_number' ,'VARCHAR2', 25);
437: fa_rx_util_pkg.assign_column('290','CBA.BANK_ACCOUNT_NAME' ,'BANK_ACCOUNT_NAME' ,
438: 'arrx_rc.var.bank_account_name' ,'VARCHAR2', 80);
439: fa_rx_util_pkg.assign_column('300','CBA.BANK_ACCOUNT_NAME_ALT' ,'BANK_ACCOUNT_NAME_ALT' ,
440: 'arrx_rc.var.bank_account_name_alt' ,'VARCHAR2',320);
441: fa_rx_util_pkg.assign_column('310','CBA.CURRENCY_CODE' ,'BANK_ACCOUNT_CURRENCY' ,
442: 'arrx_rc.var.bank_account_currency' ,'VARCHAR2', 15);
443: fa_rx_util_pkg.assign_column('320','ARM.NAME' ,'RECEIPT_METHOD' ,
437: fa_rx_util_pkg.assign_column('290','CBA.BANK_ACCOUNT_NAME' ,'BANK_ACCOUNT_NAME' ,
438: 'arrx_rc.var.bank_account_name' ,'VARCHAR2', 80);
439: fa_rx_util_pkg.assign_column('300','CBA.BANK_ACCOUNT_NAME_ALT' ,'BANK_ACCOUNT_NAME_ALT' ,
440: 'arrx_rc.var.bank_account_name_alt' ,'VARCHAR2',320);
441: fa_rx_util_pkg.assign_column('310','CBA.CURRENCY_CODE' ,'BANK_ACCOUNT_CURRENCY' ,
442: 'arrx_rc.var.bank_account_currency' ,'VARCHAR2', 15);
443: fa_rx_util_pkg.assign_column('320','ARM.NAME' ,'RECEIPT_METHOD' ,
444: 'arrx_rc.var.receipt_method' ,'VARCHAR2', 30);
445: fa_rx_util_pkg.assign_column('330','CRH.CASH_RECEIPT_HISTORY_ID' ,'CASH_RECEIPT_HISTORY_ID' ,
439: fa_rx_util_pkg.assign_column('300','CBA.BANK_ACCOUNT_NAME_ALT' ,'BANK_ACCOUNT_NAME_ALT' ,
440: 'arrx_rc.var.bank_account_name_alt' ,'VARCHAR2',320);
441: fa_rx_util_pkg.assign_column('310','CBA.CURRENCY_CODE' ,'BANK_ACCOUNT_CURRENCY' ,
442: 'arrx_rc.var.bank_account_currency' ,'VARCHAR2', 15);
443: fa_rx_util_pkg.assign_column('320','ARM.NAME' ,'RECEIPT_METHOD' ,
444: 'arrx_rc.var.receipt_method' ,'VARCHAR2', 30);
445: fa_rx_util_pkg.assign_column('330','CRH.CASH_RECEIPT_HISTORY_ID' ,'CASH_RECEIPT_HISTORY_ID' ,
446: 'arrx_rc.var.cash_receipt_history_id' ,'NUMBER');
447: fa_rx_util_pkg.assign_column('340','CRH.GL_DATE' ,'GL_DATE' ,
441: fa_rx_util_pkg.assign_column('310','CBA.CURRENCY_CODE' ,'BANK_ACCOUNT_CURRENCY' ,
442: 'arrx_rc.var.bank_account_currency' ,'VARCHAR2', 15);
443: fa_rx_util_pkg.assign_column('320','ARM.NAME' ,'RECEIPT_METHOD' ,
444: 'arrx_rc.var.receipt_method' ,'VARCHAR2', 30);
445: fa_rx_util_pkg.assign_column('330','CRH.CASH_RECEIPT_HISTORY_ID' ,'CASH_RECEIPT_HISTORY_ID' ,
446: 'arrx_rc.var.cash_receipt_history_id' ,'NUMBER');
447: fa_rx_util_pkg.assign_column('340','CRH.GL_DATE' ,'GL_DATE' ,
448: 'arrx_rc.var.gl_date' ,'DATE');
449: fa_rx_util_pkg.assign_column('350',DECODE_CRH_AMOUNT ,'RECEIPT_AMOUNT' ,
443: fa_rx_util_pkg.assign_column('320','ARM.NAME' ,'RECEIPT_METHOD' ,
444: 'arrx_rc.var.receipt_method' ,'VARCHAR2', 30);
445: fa_rx_util_pkg.assign_column('330','CRH.CASH_RECEIPT_HISTORY_ID' ,'CASH_RECEIPT_HISTORY_ID' ,
446: 'arrx_rc.var.cash_receipt_history_id' ,'NUMBER');
447: fa_rx_util_pkg.assign_column('340','CRH.GL_DATE' ,'GL_DATE' ,
448: 'arrx_rc.var.gl_date' ,'DATE');
449: fa_rx_util_pkg.assign_column('350',DECODE_CRH_AMOUNT ,'RECEIPT_AMOUNT' ,
450: 'arrx_rc.var.receipt_amount' ,'NUMBER');
451: fa_rx_util_pkg.assign_column('360',DECODE_CRH_STATUS ,'RECEIPT_HISTORY_STATUS' ,
445: fa_rx_util_pkg.assign_column('330','CRH.CASH_RECEIPT_HISTORY_ID' ,'CASH_RECEIPT_HISTORY_ID' ,
446: 'arrx_rc.var.cash_receipt_history_id' ,'NUMBER');
447: fa_rx_util_pkg.assign_column('340','CRH.GL_DATE' ,'GL_DATE' ,
448: 'arrx_rc.var.gl_date' ,'DATE');
449: fa_rx_util_pkg.assign_column('350',DECODE_CRH_AMOUNT ,'RECEIPT_AMOUNT' ,
450: 'arrx_rc.var.receipt_amount' ,'NUMBER');
451: fa_rx_util_pkg.assign_column('360',DECODE_CRH_STATUS ,'RECEIPT_HISTORY_STATUS' ,
452: 'arrx_rc.var.receipt_history_status' ,'VARCHAR2', 40);
453: fa_rx_util_pkg.assign_column('370',DECODE_CRH_ACCTD_AMOUNT ,'ACCTD_RECEIPT_AMOUNT' ,
447: fa_rx_util_pkg.assign_column('340','CRH.GL_DATE' ,'GL_DATE' ,
448: 'arrx_rc.var.gl_date' ,'DATE');
449: fa_rx_util_pkg.assign_column('350',DECODE_CRH_AMOUNT ,'RECEIPT_AMOUNT' ,
450: 'arrx_rc.var.receipt_amount' ,'NUMBER');
451: fa_rx_util_pkg.assign_column('360',DECODE_CRH_STATUS ,'RECEIPT_HISTORY_STATUS' ,
452: 'arrx_rc.var.receipt_history_status' ,'VARCHAR2', 40);
453: fa_rx_util_pkg.assign_column('370',DECODE_CRH_ACCTD_AMOUNT ,'ACCTD_RECEIPT_AMOUNT' ,
454: 'arrx_rc.var.acctd_receipt_amount' ,'NUMBER');
455: fa_rx_util_pkg.assign_column('380',DECODE_CRH_FD_AMOUNT ,'FACTOR_DISCOUNT_AMOUNT' ,
449: fa_rx_util_pkg.assign_column('350',DECODE_CRH_AMOUNT ,'RECEIPT_AMOUNT' ,
450: 'arrx_rc.var.receipt_amount' ,'NUMBER');
451: fa_rx_util_pkg.assign_column('360',DECODE_CRH_STATUS ,'RECEIPT_HISTORY_STATUS' ,
452: 'arrx_rc.var.receipt_history_status' ,'VARCHAR2', 40);
453: fa_rx_util_pkg.assign_column('370',DECODE_CRH_ACCTD_AMOUNT ,'ACCTD_RECEIPT_AMOUNT' ,
454: 'arrx_rc.var.acctd_receipt_amount' ,'NUMBER');
455: fa_rx_util_pkg.assign_column('380',DECODE_CRH_FD_AMOUNT ,'FACTOR_DISCOUNT_AMOUNT' ,
456: 'arrx_rc.var.factor_discount_amount' ,'NUMBER');
457: fa_rx_util_pkg.assign_column('390',DECODE_CRH_AFD_AMOUNT ,'ACCTD_FACTOR_DISCOUNT_AMOUNT' ,
451: fa_rx_util_pkg.assign_column('360',DECODE_CRH_STATUS ,'RECEIPT_HISTORY_STATUS' ,
452: 'arrx_rc.var.receipt_history_status' ,'VARCHAR2', 40);
453: fa_rx_util_pkg.assign_column('370',DECODE_CRH_ACCTD_AMOUNT ,'ACCTD_RECEIPT_AMOUNT' ,
454: 'arrx_rc.var.acctd_receipt_amount' ,'NUMBER');
455: fa_rx_util_pkg.assign_column('380',DECODE_CRH_FD_AMOUNT ,'FACTOR_DISCOUNT_AMOUNT' ,
456: 'arrx_rc.var.factor_discount_amount' ,'NUMBER');
457: fa_rx_util_pkg.assign_column('390',DECODE_CRH_AFD_AMOUNT ,'ACCTD_FACTOR_DISCOUNT_AMOUNT' ,
458: 'arrx_rc.var.acctd_factor_discount_amount' ,'NUMBER');
459: fa_rx_util_pkg.assign_column('400','CC.CODE_COMBINATION_ID' ,'ACCOUNT_CODE_COMBINATION_ID' ,
453: fa_rx_util_pkg.assign_column('370',DECODE_CRH_ACCTD_AMOUNT ,'ACCTD_RECEIPT_AMOUNT' ,
454: 'arrx_rc.var.acctd_receipt_amount' ,'NUMBER');
455: fa_rx_util_pkg.assign_column('380',DECODE_CRH_FD_AMOUNT ,'FACTOR_DISCOUNT_AMOUNT' ,
456: 'arrx_rc.var.factor_discount_amount' ,'NUMBER');
457: fa_rx_util_pkg.assign_column('390',DECODE_CRH_AFD_AMOUNT ,'ACCTD_FACTOR_DISCOUNT_AMOUNT' ,
458: 'arrx_rc.var.acctd_factor_discount_amount' ,'NUMBER');
459: fa_rx_util_pkg.assign_column('400','CC.CODE_COMBINATION_ID' ,'ACCOUNT_CODE_COMBINATION_ID' ,
460: 'arrx_rc.var.account_code_combination_id' ,'NUMBER');
461: fa_rx_util_pkg.assign_column('410',null ,'DEBIT_ACCOUNT' ,
455: fa_rx_util_pkg.assign_column('380',DECODE_CRH_FD_AMOUNT ,'FACTOR_DISCOUNT_AMOUNT' ,
456: 'arrx_rc.var.factor_discount_amount' ,'NUMBER');
457: fa_rx_util_pkg.assign_column('390',DECODE_CRH_AFD_AMOUNT ,'ACCTD_FACTOR_DISCOUNT_AMOUNT' ,
458: 'arrx_rc.var.acctd_factor_discount_amount' ,'NUMBER');
459: fa_rx_util_pkg.assign_column('400','CC.CODE_COMBINATION_ID' ,'ACCOUNT_CODE_COMBINATION_ID' ,
460: 'arrx_rc.var.account_code_combination_id' ,'NUMBER');
461: fa_rx_util_pkg.assign_column('410',null ,'DEBIT_ACCOUNT' ,
462: 'arrx_rc.var.debit_account' ,'VARCHAR2',240);
463: fa_rx_util_pkg.assign_column('420',null ,'DEBIT_ACCOUNT_DESC' ,
457: fa_rx_util_pkg.assign_column('390',DECODE_CRH_AFD_AMOUNT ,'ACCTD_FACTOR_DISCOUNT_AMOUNT' ,
458: 'arrx_rc.var.acctd_factor_discount_amount' ,'NUMBER');
459: fa_rx_util_pkg.assign_column('400','CC.CODE_COMBINATION_ID' ,'ACCOUNT_CODE_COMBINATION_ID' ,
460: 'arrx_rc.var.account_code_combination_id' ,'NUMBER');
461: fa_rx_util_pkg.assign_column('410',null ,'DEBIT_ACCOUNT' ,
462: 'arrx_rc.var.debit_account' ,'VARCHAR2',240);
463: fa_rx_util_pkg.assign_column('420',null ,'DEBIT_ACCOUNT_DESC' ,
464: 'arrx_rc.var.debit_account_desc' ,'VARCHAR2',240);
465: fa_rx_util_pkg.assign_column('430',null ,'DEBIT_BALANCING' ,
459: fa_rx_util_pkg.assign_column('400','CC.CODE_COMBINATION_ID' ,'ACCOUNT_CODE_COMBINATION_ID' ,
460: 'arrx_rc.var.account_code_combination_id' ,'NUMBER');
461: fa_rx_util_pkg.assign_column('410',null ,'DEBIT_ACCOUNT' ,
462: 'arrx_rc.var.debit_account' ,'VARCHAR2',240);
463: fa_rx_util_pkg.assign_column('420',null ,'DEBIT_ACCOUNT_DESC' ,
464: 'arrx_rc.var.debit_account_desc' ,'VARCHAR2',240);
465: fa_rx_util_pkg.assign_column('430',null ,'DEBIT_BALANCING' ,
466: 'arrx_rc.var.debit_balancing' ,'VARCHAR2',240);
467: fa_rx_util_pkg.assign_column('440',null ,'DEBIT_BALANCING_DESC' ,
461: fa_rx_util_pkg.assign_column('410',null ,'DEBIT_ACCOUNT' ,
462: 'arrx_rc.var.debit_account' ,'VARCHAR2',240);
463: fa_rx_util_pkg.assign_column('420',null ,'DEBIT_ACCOUNT_DESC' ,
464: 'arrx_rc.var.debit_account_desc' ,'VARCHAR2',240);
465: fa_rx_util_pkg.assign_column('430',null ,'DEBIT_BALANCING' ,
466: 'arrx_rc.var.debit_balancing' ,'VARCHAR2',240);
467: fa_rx_util_pkg.assign_column('440',null ,'DEBIT_BALANCING_DESC' ,
468: 'arrx_rc.var.debit_balancing_desc' ,'VARCHAR2',240);
469: fa_rx_util_pkg.assign_column('450',null ,'DEBIT_NATACCT' ,
463: fa_rx_util_pkg.assign_column('420',null ,'DEBIT_ACCOUNT_DESC' ,
464: 'arrx_rc.var.debit_account_desc' ,'VARCHAR2',240);
465: fa_rx_util_pkg.assign_column('430',null ,'DEBIT_BALANCING' ,
466: 'arrx_rc.var.debit_balancing' ,'VARCHAR2',240);
467: fa_rx_util_pkg.assign_column('440',null ,'DEBIT_BALANCING_DESC' ,
468: 'arrx_rc.var.debit_balancing_desc' ,'VARCHAR2',240);
469: fa_rx_util_pkg.assign_column('450',null ,'DEBIT_NATACCT' ,
470: 'arrx_rc.var.debit_natacct' ,'VARCHAR2',240);
471: fa_rx_util_pkg.assign_column('460',null ,'DEBIT_NATACCT_DESC' ,
465: fa_rx_util_pkg.assign_column('430',null ,'DEBIT_BALANCING' ,
466: 'arrx_rc.var.debit_balancing' ,'VARCHAR2',240);
467: fa_rx_util_pkg.assign_column('440',null ,'DEBIT_BALANCING_DESC' ,
468: 'arrx_rc.var.debit_balancing_desc' ,'VARCHAR2',240);
469: fa_rx_util_pkg.assign_column('450',null ,'DEBIT_NATACCT' ,
470: 'arrx_rc.var.debit_natacct' ,'VARCHAR2',240);
471: fa_rx_util_pkg.assign_column('460',null ,'DEBIT_NATACCT_DESC' ,
472: 'arrx_rc.var.debit_natacct_desc' ,'VARCHAR2',240);
473: fa_rx_util_pkg.assign_column('470','CUST.CUST_ACCOUNT_ID' ,'CUSTOMER_ID' ,
467: fa_rx_util_pkg.assign_column('440',null ,'DEBIT_BALANCING_DESC' ,
468: 'arrx_rc.var.debit_balancing_desc' ,'VARCHAR2',240);
469: fa_rx_util_pkg.assign_column('450',null ,'DEBIT_NATACCT' ,
470: 'arrx_rc.var.debit_natacct' ,'VARCHAR2',240);
471: fa_rx_util_pkg.assign_column('460',null ,'DEBIT_NATACCT_DESC' ,
472: 'arrx_rc.var.debit_natacct_desc' ,'VARCHAR2',240);
473: fa_rx_util_pkg.assign_column('470','CUST.CUST_ACCOUNT_ID' ,'CUSTOMER_ID' ,
474: 'arrx_rc.var.customer_id' ,'NUMBER');
475: /* bug 5724171*/
469: fa_rx_util_pkg.assign_column('450',null ,'DEBIT_NATACCT' ,
470: 'arrx_rc.var.debit_natacct' ,'VARCHAR2',240);
471: fa_rx_util_pkg.assign_column('460',null ,'DEBIT_NATACCT_DESC' ,
472: 'arrx_rc.var.debit_natacct_desc' ,'VARCHAR2',240);
473: fa_rx_util_pkg.assign_column('470','CUST.CUST_ACCOUNT_ID' ,'CUSTOMER_ID' ,
474: 'arrx_rc.var.customer_id' ,'NUMBER');
475: /* bug 5724171*/
476: fa_rx_util_pkg.assign_column('480','SUBSTRB(PARTY.PARTY_NAME,1,240)' ,'CUSTOMER_NAME' ,
477: 'arrx_rc.var.customer_name' ,'VARCHAR2', 240);
472: 'arrx_rc.var.debit_natacct_desc' ,'VARCHAR2',240);
473: fa_rx_util_pkg.assign_column('470','CUST.CUST_ACCOUNT_ID' ,'CUSTOMER_ID' ,
474: 'arrx_rc.var.customer_id' ,'NUMBER');
475: /* bug 5724171*/
476: fa_rx_util_pkg.assign_column('480','SUBSTRB(PARTY.PARTY_NAME,1,240)' ,'CUSTOMER_NAME' ,
477: 'arrx_rc.var.customer_name' ,'VARCHAR2', 240);
478: fa_rx_util_pkg.assign_column('490','DECODE(PARTY.PARTY_TYPE, ''ORGANIZATION'',PARTY.ORGANIZATION_NAME_PHONETIC, NULL)','CUSTOMER_NAME_ALT',
479: 'arrx_rc.var.customer_name_alt' ,'VARCHAR2',320);
480: fa_rx_util_pkg.assign_column('500','CUST.ACCOUNT_NUMBER' ,'CUSTOMER_NUMBER' ,
474: 'arrx_rc.var.customer_id' ,'NUMBER');
475: /* bug 5724171*/
476: fa_rx_util_pkg.assign_column('480','SUBSTRB(PARTY.PARTY_NAME,1,240)' ,'CUSTOMER_NAME' ,
477: 'arrx_rc.var.customer_name' ,'VARCHAR2', 240);
478: fa_rx_util_pkg.assign_column('490','DECODE(PARTY.PARTY_TYPE, ''ORGANIZATION'',PARTY.ORGANIZATION_NAME_PHONETIC, NULL)','CUSTOMER_NAME_ALT',
479: 'arrx_rc.var.customer_name_alt' ,'VARCHAR2',320);
480: fa_rx_util_pkg.assign_column('500','CUST.ACCOUNT_NUMBER' ,'CUSTOMER_NUMBER' ,
481: 'arrx_rc.var.customer_number' ,'VARCHAR2', 30);
482:
476: fa_rx_util_pkg.assign_column('480','SUBSTRB(PARTY.PARTY_NAME,1,240)' ,'CUSTOMER_NAME' ,
477: 'arrx_rc.var.customer_name' ,'VARCHAR2', 240);
478: fa_rx_util_pkg.assign_column('490','DECODE(PARTY.PARTY_TYPE, ''ORGANIZATION'',PARTY.ORGANIZATION_NAME_PHONETIC, NULL)','CUSTOMER_NAME_ALT',
479: 'arrx_rc.var.customer_name_alt' ,'VARCHAR2',320);
480: fa_rx_util_pkg.assign_column('500','CUST.ACCOUNT_NUMBER' ,'CUSTOMER_NUMBER' ,
481: 'arrx_rc.var.customer_number' ,'VARCHAR2', 30);
482:
483:
484:
484:
485: -- define FROM_CLAUSE
486: IF var.calling_program in ('RECEIPT','APPLIED','MISC','ACTUAL') then
487:
488: fa_rx_util_pkg.debug('Define FROM_CLAUSE using _ALL tables');
489:
490: IF NVL(var.ca_sob_type,'P') = 'P' THEN
491: fa_rx_util_pkg.From_Clause :=
492: 'AR_CASH_RECEIPTS CR,
487:
488: fa_rx_util_pkg.debug('Define FROM_CLAUSE using _ALL tables');
489:
490: IF NVL(var.ca_sob_type,'P') = 'P' THEN
491: fa_rx_util_pkg.From_Clause :=
492: 'AR_CASH_RECEIPTS CR,
493: FND_DOCUMENT_SEQUENCES DOCSEQ,
494: AR_VAT_TAX TAX,
495: CE_BANK_ACCOUNTS CBA,
503: AR_BATCHES BATCH,
504: AR_CASH_RECEIPT_HISTORY CRHFIRST,
505: AR_BATCHES BATCHFIRST';
506: ELSE
507: fa_rx_util_pkg.From_Clause :=
508: 'AR_CASH_RECEIPTS_ALL_MRC_V CR,
509: FND_DOCUMENT_SEQUENCES DOCSEQ,
510: AR_VAT_TAX_ALL TAX,
511: CE_BANK_ACCOUNTS CBA,
522: END IF;
523:
524: ELSE
525:
526: fa_rx_util_pkg.debug('Define FROM_CLAUSE using org-striped views');
527:
528: IF NVL(var.ca_sob_type,'P') = 'P' THEN
529: fa_rx_util_pkg.From_Clause :=
530: 'AR_CASH_RECEIPTS CR,
525:
526: fa_rx_util_pkg.debug('Define FROM_CLAUSE using org-striped views');
527:
528: IF NVL(var.ca_sob_type,'P') = 'P' THEN
529: fa_rx_util_pkg.From_Clause :=
530: 'AR_CASH_RECEIPTS CR,
531: FND_DOCUMENT_SEQUENCES DOCSEQ,
532: AR_VAT_TAX TAX,
533: -- AP_BANK_ACCOUNTS ABA,
543: AR_BATCHES BATCH,
544: AR_CASH_RECEIPT_HISTORY CRHFIRST,
545: AR_BATCHES BATCHFIRST';
546: ELSE
547: fa_rx_util_pkg.From_Clause :=
548: 'AR_CASH_RECEIPTS_MRC_V CR,
549: FND_DOCUMENT_SEQUENCES DOCSEQ,
550: AR_VAT_TAX TAX,
551: -- AP_BANK_ACCOUNTS ABA,
566: END IF;
567:
568: IF nvl(var.calling_program,'not receipt') = 'RECEIPT'
569: THEN
570: fa_rx_util_pkg.debug('Define FROM_CLAUSE using _ALL tables for RECEIPT');
571:
572: IF NVL(var.ca_sob_type,'P') = 'P' THEN
573: fa_rx_util_pkg.From_Clause :=
574: fa_rx_util_pkg.From_Clause ||
569: THEN
570: fa_rx_util_pkg.debug('Define FROM_CLAUSE using _ALL tables for RECEIPT');
571:
572: IF NVL(var.ca_sob_type,'P') = 'P' THEN
573: fa_rx_util_pkg.From_Clause :=
574: fa_rx_util_pkg.From_Clause ||
575: ',AR_CASH_RECEIPT_HISTORY CRHLAST';
576: ELSE
577: fa_rx_util_pkg.From_Clause :=
570: fa_rx_util_pkg.debug('Define FROM_CLAUSE using _ALL tables for RECEIPT');
571:
572: IF NVL(var.ca_sob_type,'P') = 'P' THEN
573: fa_rx_util_pkg.From_Clause :=
574: fa_rx_util_pkg.From_Clause ||
575: ',AR_CASH_RECEIPT_HISTORY CRHLAST';
576: ELSE
577: fa_rx_util_pkg.From_Clause :=
578: fa_rx_util_pkg.From_Clause ||
573: fa_rx_util_pkg.From_Clause :=
574: fa_rx_util_pkg.From_Clause ||
575: ',AR_CASH_RECEIPT_HISTORY CRHLAST';
576: ELSE
577: fa_rx_util_pkg.From_Clause :=
578: fa_rx_util_pkg.From_Clause ||
579: ',AR_CASH_RECEIPT_HIST_MRC_V CRHLAST';
580: END IF;
581:
574: fa_rx_util_pkg.From_Clause ||
575: ',AR_CASH_RECEIPT_HISTORY CRHLAST';
576: ELSE
577: fa_rx_util_pkg.From_Clause :=
578: fa_rx_util_pkg.From_Clause ||
579: ',AR_CASH_RECEIPT_HIST_MRC_V CRHLAST';
580: END IF;
581:
582: END IF;
581:
582: END IF;
583:
584:
585: fa_rx_util_pkg.debug('Define WHERE_CLAUSE');
586:
587: fa_rx_util_pkg.Where_Clause := '
588: CR.CASH_RECEIPT_ID = CRHFIRST.CASH_RECEIPT_ID
589: AND CRHFIRST.FIRST_POSTED_RECORD_FLAG = ''Y''
583:
584:
585: fa_rx_util_pkg.debug('Define WHERE_CLAUSE');
586:
587: fa_rx_util_pkg.Where_Clause := '
588: CR.CASH_RECEIPT_ID = CRHFIRST.CASH_RECEIPT_ID
589: AND CRHFIRST.FIRST_POSTED_RECORD_FLAG = ''Y''
590: AND CRHFIRST.BATCH_ID = BATCHFIRST.BATCH_ID(+)
591: AND CRH.BATCH_ID = BATCH.BATCH_ID(+)
615: CRH_GL_DATE_WHERE;
616:
617: if var.calling_program in ('RECEIPT','APPLIED','MISC','ACTUAL') THEN
618:
619: fa_rx_util_pkg.debug('Define Multi-org logic');
620:
621: --Bug 5244313 added the var.books_id in the where clause to pickup the sob based on the reporting context
622: -- if p_sob_id is null
623: select CHART_OF_ACCOUNTS_ID,CURRENCY_CODE,NAME
624: into var.p_coa_id,var.functional_currency_code,var.organization_name
625: from GL_SETS_OF_BOOKS
626: where SET_OF_BOOKS_ID =nvl( var.p_sob_id,var.books_id);
627:
628: fa_rx_util_pkg.debug('Set of Books ID : '||var.p_sob_id);
629: fa_rx_util_pkg.debug('Chart of Accounts ID : '||var.p_coa_id);
630: fa_rx_util_pkg.debug('Functional Currency : '||var.functional_currency_code);
631: fa_rx_util_pkg.debug('Organization Name : '||var.organization_name);
632:
625: from GL_SETS_OF_BOOKS
626: where SET_OF_BOOKS_ID =nvl( var.p_sob_id,var.books_id);
627:
628: fa_rx_util_pkg.debug('Set of Books ID : '||var.p_sob_id);
629: fa_rx_util_pkg.debug('Chart of Accounts ID : '||var.p_coa_id);
630: fa_rx_util_pkg.debug('Functional Currency : '||var.functional_currency_code);
631: fa_rx_util_pkg.debug('Organization Name : '||var.organization_name);
632:
633: XLA_MO_REPORTING_API.Initialize(var.p_reporting_level, var.p_reporting_entity_id, 'AUTO');
626: where SET_OF_BOOKS_ID =nvl( var.p_sob_id,var.books_id);
627:
628: fa_rx_util_pkg.debug('Set of Books ID : '||var.p_sob_id);
629: fa_rx_util_pkg.debug('Chart of Accounts ID : '||var.p_coa_id);
630: fa_rx_util_pkg.debug('Functional Currency : '||var.functional_currency_code);
631: fa_rx_util_pkg.debug('Organization Name : '||var.organization_name);
632:
633: XLA_MO_REPORTING_API.Initialize(var.p_reporting_level, var.p_reporting_entity_id, 'AUTO');
634:
627:
628: fa_rx_util_pkg.debug('Set of Books ID : '||var.p_sob_id);
629: fa_rx_util_pkg.debug('Chart of Accounts ID : '||var.p_coa_id);
630: fa_rx_util_pkg.debug('Functional Currency : '||var.functional_currency_code);
631: fa_rx_util_pkg.debug('Organization Name : '||var.organization_name);
632:
633: XLA_MO_REPORTING_API.Initialize(var.p_reporting_level, var.p_reporting_entity_id, 'AUTO');
634:
635: L_CR_ORG_WHERE := XLA_MO_REPORTING_API.Get_Predicate('CR','push_subq');
693: end if;
694:
695: if var.calling_program = 'RECEIPT' then
696:
697: fa_rx_util_pkg.debug('Define additional WHERE_CLAUSE for Receipts Register');
698:
699:
700: IF NVL(var.ca_sob_type,'P') = 'P' THEN
701:
698:
699:
700: IF NVL(var.ca_sob_type,'P') = 'P' THEN
701:
702: fa_rx_util_pkg.Where_Clause :=
703: fa_rx_util_pkg.Where_Clause ||
704: ' AND CRH.CASH_RECEIPT_HISTORY_ID IN (
705: SELECT NVL(MAX(CRHNEW.CASH_RECEIPT_HISTORY_ID ), MAX(INCRH.CASH_RECEIPT_HISTORY_ID))
706: FROM AR_CASH_RECEIPT_HISTORY INCRH ,
699:
700: IF NVL(var.ca_sob_type,'P') = 'P' THEN
701:
702: fa_rx_util_pkg.Where_Clause :=
703: fa_rx_util_pkg.Where_Clause ||
704: ' AND CRH.CASH_RECEIPT_HISTORY_ID IN (
705: SELECT NVL(MAX(CRHNEW.CASH_RECEIPT_HISTORY_ID ), MAX(INCRH.CASH_RECEIPT_HISTORY_ID))
706: FROM AR_CASH_RECEIPT_HISTORY INCRH ,
707: AR_CASH_RECEIPT_HISTORY CRHNEW
722: ,nvl(CRHLAST.ACCTD_FACTOR_DISCOUNT_AMOUNT,0)) <>nvl( CRH.ACCTD_FACTOR_DISCOUNT_AMOUNT,0)
723: OR CRH.STATUS=''REVERSED'')' || CO_SEG_WHERE;
724: ELSE
725:
726: fa_rx_util_pkg.Where_Clause :=
727: fa_rx_util_pkg.Where_Clause ||
728: ' AND CRH.CASH_RECEIPT_HISTORY_ID IN (
729: SELECT MAX(INCRH.CASH_RECEIPT_HISTORY_ID)
730: FROM AR_CASH_RECEIPT_HIST_ALL_MRC_V INCRH
723: OR CRH.STATUS=''REVERSED'')' || CO_SEG_WHERE;
724: ELSE
725:
726: fa_rx_util_pkg.Where_Clause :=
727: fa_rx_util_pkg.Where_Clause ||
728: ' AND CRH.CASH_RECEIPT_HISTORY_ID IN (
729: SELECT MAX(INCRH.CASH_RECEIPT_HISTORY_ID)
730: FROM AR_CASH_RECEIPT_HIST_ALL_MRC_V INCRH
731: WHERE INCRH.CASH_RECEIPT_ID = CRH.CASH_RECEIPT_ID
742: ,nvl(CRHLAST.ACCTD_FACTOR_DISCOUNT_AMOUNT,0)) <>nvl( CRH.ACCTD_FACTOR_DISCOUNT_AMOUNT,0)
743: OR CRH.STATUS=''REVERSED'')' || CO_SEG_WHERE;
744: END IF;
745: /*
746: fa_rx_util_pkg.Where_Clause :=
747: fa_rx_util_pkg.Where_Clause || ' ' ||
748: L_CR_ORG_WHERE || ' ' ||
749: L_TAX_ORG_WHERE || ' ' ||
750: L_ABA_ORG_WHERE || ' ' ||
743: OR CRH.STATUS=''REVERSED'')' || CO_SEG_WHERE;
744: END IF;
745: /*
746: fa_rx_util_pkg.Where_Clause :=
747: fa_rx_util_pkg.Where_Clause || ' ' ||
748: L_CR_ORG_WHERE || ' ' ||
749: L_TAX_ORG_WHERE || ' ' ||
750: L_ABA_ORG_WHERE || ' ' ||
751: L_CRH_ORG_WHERE || ' ' ||
758: -----------------------------------------
759: ELSIF var.calling_program = 'ACTUAL' then
760: -----------------------------------------
761:
762: fa_rx_util_pkg.debug('Define additional ASSIGN_COLUMN for Actual Receipts Register');
763:
764: DECODE_RA_STATUS := 'DECODE(RA.STATUS,''ACC'',:L_ACCO,''APP'',:L_APPL,''UNAPP'',:L_UNAPPL,''UNID'',:L_UNIDE)';
765:
766: fa_rx_util_pkg.assign_column('A1 ','RA.RECEIVABLE_APPLICATION_ID' ,'RECEIVABLE_APPLICATION_ID',
762: fa_rx_util_pkg.debug('Define additional ASSIGN_COLUMN for Actual Receipts Register');
763:
764: DECODE_RA_STATUS := 'DECODE(RA.STATUS,''ACC'',:L_ACCO,''APP'',:L_APPL,''UNAPP'',:L_UNAPPL,''UNID'',:L_UNIDE)';
765:
766: fa_rx_util_pkg.assign_column('A1 ','RA.RECEIVABLE_APPLICATION_ID' ,'RECEIVABLE_APPLICATION_ID',
767: 'arrx_rc.var.receivable_application_id' ,'NUMBER');
768: fa_rx_util_pkg.assign_column('A2 ','RA.APPLY_DATE','APPLY_DATE',
769: 'arrx_rc.var.apply_date' ,'DATE');
770: fa_rx_util_pkg.assign_column('A3 ',DECODE_RA_STATUS,'APPLICATION_STATUS',
764: DECODE_RA_STATUS := 'DECODE(RA.STATUS,''ACC'',:L_ACCO,''APP'',:L_APPL,''UNAPP'',:L_UNAPPL,''UNID'',:L_UNIDE)';
765:
766: fa_rx_util_pkg.assign_column('A1 ','RA.RECEIVABLE_APPLICATION_ID' ,'RECEIVABLE_APPLICATION_ID',
767: 'arrx_rc.var.receivable_application_id' ,'NUMBER');
768: fa_rx_util_pkg.assign_column('A2 ','RA.APPLY_DATE','APPLY_DATE',
769: 'arrx_rc.var.apply_date' ,'DATE');
770: fa_rx_util_pkg.assign_column('A3 ',DECODE_RA_STATUS,'APPLICATION_STATUS',
771: 'arrx_rc.var.application_status' ,'VARCHAR2', 20);
772: fa_rx_util_pkg.assign_column('A4 ','RA.AMOUNT_APPLIED' ,'AMOUNT_APPLIED_TO',
766: fa_rx_util_pkg.assign_column('A1 ','RA.RECEIVABLE_APPLICATION_ID' ,'RECEIVABLE_APPLICATION_ID',
767: 'arrx_rc.var.receivable_application_id' ,'NUMBER');
768: fa_rx_util_pkg.assign_column('A2 ','RA.APPLY_DATE','APPLY_DATE',
769: 'arrx_rc.var.apply_date' ,'DATE');
770: fa_rx_util_pkg.assign_column('A3 ',DECODE_RA_STATUS,'APPLICATION_STATUS',
771: 'arrx_rc.var.application_status' ,'VARCHAR2', 20);
772: fa_rx_util_pkg.assign_column('A4 ','RA.AMOUNT_APPLIED' ,'AMOUNT_APPLIED_TO',
773: 'arrx_rc.var.amount_applied_to' ,'NUMBER');
774: fa_rx_util_pkg.assign_column('A5 ','NVL(RA.AMOUNT_APPLIED_FROM,RA.AMOUNT_APPLIED)' ,'AMOUNT_APPLIED_FROM',
768: fa_rx_util_pkg.assign_column('A2 ','RA.APPLY_DATE','APPLY_DATE',
769: 'arrx_rc.var.apply_date' ,'DATE');
770: fa_rx_util_pkg.assign_column('A3 ',DECODE_RA_STATUS,'APPLICATION_STATUS',
771: 'arrx_rc.var.application_status' ,'VARCHAR2', 20);
772: fa_rx_util_pkg.assign_column('A4 ','RA.AMOUNT_APPLIED' ,'AMOUNT_APPLIED_TO',
773: 'arrx_rc.var.amount_applied_to' ,'NUMBER');
774: fa_rx_util_pkg.assign_column('A5 ','NVL(RA.AMOUNT_APPLIED_FROM,RA.AMOUNT_APPLIED)' ,'AMOUNT_APPLIED_FROM',
775: 'arrx_rc.var.amount_applied_from' ,'NUMBER');
776: fa_rx_util_pkg.assign_column('A6 ','NVL(RA.ACCTD_AMOUNT_APPLIED_TO,RA.ACCTD_AMOUNT_APPLIED_FROM)' ,'ACCTD_AMOUNT_APPLIED_TO',
770: fa_rx_util_pkg.assign_column('A3 ',DECODE_RA_STATUS,'APPLICATION_STATUS',
771: 'arrx_rc.var.application_status' ,'VARCHAR2', 20);
772: fa_rx_util_pkg.assign_column('A4 ','RA.AMOUNT_APPLIED' ,'AMOUNT_APPLIED_TO',
773: 'arrx_rc.var.amount_applied_to' ,'NUMBER');
774: fa_rx_util_pkg.assign_column('A5 ','NVL(RA.AMOUNT_APPLIED_FROM,RA.AMOUNT_APPLIED)' ,'AMOUNT_APPLIED_FROM',
775: 'arrx_rc.var.amount_applied_from' ,'NUMBER');
776: fa_rx_util_pkg.assign_column('A6 ','NVL(RA.ACCTD_AMOUNT_APPLIED_TO,RA.ACCTD_AMOUNT_APPLIED_FROM)' ,'ACCTD_AMOUNT_APPLIED_TO',
777: 'arrx_rc.var.acctd_amount_applied_to' ,'NUMBER');
778: fa_rx_util_pkg.assign_column('A7 ','RA.ACCTD_AMOUNT_APPLIED_FROM' ,'ACCTD_AMOUNT_APPLIED_FROM',
772: fa_rx_util_pkg.assign_column('A4 ','RA.AMOUNT_APPLIED' ,'AMOUNT_APPLIED_TO',
773: 'arrx_rc.var.amount_applied_to' ,'NUMBER');
774: fa_rx_util_pkg.assign_column('A5 ','NVL(RA.AMOUNT_APPLIED_FROM,RA.AMOUNT_APPLIED)' ,'AMOUNT_APPLIED_FROM',
775: 'arrx_rc.var.amount_applied_from' ,'NUMBER');
776: fa_rx_util_pkg.assign_column('A6 ','NVL(RA.ACCTD_AMOUNT_APPLIED_TO,RA.ACCTD_AMOUNT_APPLIED_FROM)' ,'ACCTD_AMOUNT_APPLIED_TO',
777: 'arrx_rc.var.acctd_amount_applied_to' ,'NUMBER');
778: fa_rx_util_pkg.assign_column('A7 ','RA.ACCTD_AMOUNT_APPLIED_FROM' ,'ACCTD_AMOUNT_APPLIED_FROM',
779: 'arrx_rc.var.acctd_amount_applied_from' ,'NUMBER');
780: fa_rx_util_pkg.assign_column('A8 ','RA.EARNED_DISCOUNT_TAKEN' ,'EARNED_DISCOUNT_TAKEN',
774: fa_rx_util_pkg.assign_column('A5 ','NVL(RA.AMOUNT_APPLIED_FROM,RA.AMOUNT_APPLIED)' ,'AMOUNT_APPLIED_FROM',
775: 'arrx_rc.var.amount_applied_from' ,'NUMBER');
776: fa_rx_util_pkg.assign_column('A6 ','NVL(RA.ACCTD_AMOUNT_APPLIED_TO,RA.ACCTD_AMOUNT_APPLIED_FROM)' ,'ACCTD_AMOUNT_APPLIED_TO',
777: 'arrx_rc.var.acctd_amount_applied_to' ,'NUMBER');
778: fa_rx_util_pkg.assign_column('A7 ','RA.ACCTD_AMOUNT_APPLIED_FROM' ,'ACCTD_AMOUNT_APPLIED_FROM',
779: 'arrx_rc.var.acctd_amount_applied_from' ,'NUMBER');
780: fa_rx_util_pkg.assign_column('A8 ','RA.EARNED_DISCOUNT_TAKEN' ,'EARNED_DISCOUNT_TAKEN',
781: 'arrx_rc.var.earned_discount_taken' ,'NUMBER');
782: fa_rx_util_pkg.assign_column('A9 ','RA.UNEARNED_DISCOUNT_TAKEN','UNEARNED_DISCOUNT_TAKEN',
776: fa_rx_util_pkg.assign_column('A6 ','NVL(RA.ACCTD_AMOUNT_APPLIED_TO,RA.ACCTD_AMOUNT_APPLIED_FROM)' ,'ACCTD_AMOUNT_APPLIED_TO',
777: 'arrx_rc.var.acctd_amount_applied_to' ,'NUMBER');
778: fa_rx_util_pkg.assign_column('A7 ','RA.ACCTD_AMOUNT_APPLIED_FROM' ,'ACCTD_AMOUNT_APPLIED_FROM',
779: 'arrx_rc.var.acctd_amount_applied_from' ,'NUMBER');
780: fa_rx_util_pkg.assign_column('A8 ','RA.EARNED_DISCOUNT_TAKEN' ,'EARNED_DISCOUNT_TAKEN',
781: 'arrx_rc.var.earned_discount_taken' ,'NUMBER');
782: fa_rx_util_pkg.assign_column('A9 ','RA.UNEARNED_DISCOUNT_TAKEN','UNEARNED_DISCOUNT_TAKEN',
783: 'arrx_rc.var.unearned_discount_taken' ,'NUMBER');
784: fa_rx_util_pkg.assign_column('A10','RA.ACCTD_EARNED_DISCOUNT_TAKEN' ,'ACCTD_EARNED_DISCOUNT_TAKEN',
778: fa_rx_util_pkg.assign_column('A7 ','RA.ACCTD_AMOUNT_APPLIED_FROM' ,'ACCTD_AMOUNT_APPLIED_FROM',
779: 'arrx_rc.var.acctd_amount_applied_from' ,'NUMBER');
780: fa_rx_util_pkg.assign_column('A8 ','RA.EARNED_DISCOUNT_TAKEN' ,'EARNED_DISCOUNT_TAKEN',
781: 'arrx_rc.var.earned_discount_taken' ,'NUMBER');
782: fa_rx_util_pkg.assign_column('A9 ','RA.UNEARNED_DISCOUNT_TAKEN','UNEARNED_DISCOUNT_TAKEN',
783: 'arrx_rc.var.unearned_discount_taken' ,'NUMBER');
784: fa_rx_util_pkg.assign_column('A10','RA.ACCTD_EARNED_DISCOUNT_TAKEN' ,'ACCTD_EARNED_DISCOUNT_TAKEN',
785: 'arrx_rc.var.acctd_earned_discount_taken' ,'NUMBER');
786: fa_rx_util_pkg.assign_column('A11','RA.ACCTD_UNEARNED_DISCOUNT_TAKEN' ,'ACCTD_UNEARNED_DISCOUNT_TAKEN',
780: fa_rx_util_pkg.assign_column('A8 ','RA.EARNED_DISCOUNT_TAKEN' ,'EARNED_DISCOUNT_TAKEN',
781: 'arrx_rc.var.earned_discount_taken' ,'NUMBER');
782: fa_rx_util_pkg.assign_column('A9 ','RA.UNEARNED_DISCOUNT_TAKEN','UNEARNED_DISCOUNT_TAKEN',
783: 'arrx_rc.var.unearned_discount_taken' ,'NUMBER');
784: fa_rx_util_pkg.assign_column('A10','RA.ACCTD_EARNED_DISCOUNT_TAKEN' ,'ACCTD_EARNED_DISCOUNT_TAKEN',
785: 'arrx_rc.var.acctd_earned_discount_taken' ,'NUMBER');
786: fa_rx_util_pkg.assign_column('A11','RA.ACCTD_UNEARNED_DISCOUNT_TAKEN' ,'ACCTD_UNEARNED_DISCOUNT_TAKEN',
787: 'arrx_rc.var.acctd_unearned_discount_taken' ,'NUMBER');
788: fa_rx_util_pkg.assign_column('A12','TRX.CUSTOMER_TRX_ID' ,'APPLIED_CUSTOMER_TRX_ID',
782: fa_rx_util_pkg.assign_column('A9 ','RA.UNEARNED_DISCOUNT_TAKEN','UNEARNED_DISCOUNT_TAKEN',
783: 'arrx_rc.var.unearned_discount_taken' ,'NUMBER');
784: fa_rx_util_pkg.assign_column('A10','RA.ACCTD_EARNED_DISCOUNT_TAKEN' ,'ACCTD_EARNED_DISCOUNT_TAKEN',
785: 'arrx_rc.var.acctd_earned_discount_taken' ,'NUMBER');
786: fa_rx_util_pkg.assign_column('A11','RA.ACCTD_UNEARNED_DISCOUNT_TAKEN' ,'ACCTD_UNEARNED_DISCOUNT_TAKEN',
787: 'arrx_rc.var.acctd_unearned_discount_taken' ,'NUMBER');
788: fa_rx_util_pkg.assign_column('A12','TRX.CUSTOMER_TRX_ID' ,'APPLIED_CUSTOMER_TRX_ID',
789: 'arrx_rc.var.applied_customer_trx_id' ,'NUMBER');
790: fa_rx_util_pkg.assign_column('A13','DECODE(RA.STATUS, ''ACC'', :l_trx_on_acc, TRX.TRX_NUMBER)','TRX_NUMBER' ,
784: fa_rx_util_pkg.assign_column('A10','RA.ACCTD_EARNED_DISCOUNT_TAKEN' ,'ACCTD_EARNED_DISCOUNT_TAKEN',
785: 'arrx_rc.var.acctd_earned_discount_taken' ,'NUMBER');
786: fa_rx_util_pkg.assign_column('A11','RA.ACCTD_UNEARNED_DISCOUNT_TAKEN' ,'ACCTD_UNEARNED_DISCOUNT_TAKEN',
787: 'arrx_rc.var.acctd_unearned_discount_taken' ,'NUMBER');
788: fa_rx_util_pkg.assign_column('A12','TRX.CUSTOMER_TRX_ID' ,'APPLIED_CUSTOMER_TRX_ID',
789: 'arrx_rc.var.applied_customer_trx_id' ,'NUMBER');
790: fa_rx_util_pkg.assign_column('A13','DECODE(RA.STATUS, ''ACC'', :l_trx_on_acc, TRX.TRX_NUMBER)','TRX_NUMBER' ,
791: 'arrx_rc.var.trx_number','VARCHAR2', 20);
792: fa_rx_util_pkg.assign_column('A14','TRX.INVOICE_CURRENCY_CODE','TRX_CURRENCY_CODE',
786: fa_rx_util_pkg.assign_column('A11','RA.ACCTD_UNEARNED_DISCOUNT_TAKEN' ,'ACCTD_UNEARNED_DISCOUNT_TAKEN',
787: 'arrx_rc.var.acctd_unearned_discount_taken' ,'NUMBER');
788: fa_rx_util_pkg.assign_column('A12','TRX.CUSTOMER_TRX_ID' ,'APPLIED_CUSTOMER_TRX_ID',
789: 'arrx_rc.var.applied_customer_trx_id' ,'NUMBER');
790: fa_rx_util_pkg.assign_column('A13','DECODE(RA.STATUS, ''ACC'', :l_trx_on_acc, TRX.TRX_NUMBER)','TRX_NUMBER' ,
791: 'arrx_rc.var.trx_number','VARCHAR2', 20);
792: fa_rx_util_pkg.assign_column('A14','TRX.INVOICE_CURRENCY_CODE','TRX_CURRENCY_CODE',
793: 'arrx_rc.var.trx_currency_code' ,'VARCHAR2', 15);
794: fa_rx_util_pkg.assign_column('A15','TRX.TRX_DATE','TRX_DATE',
788: fa_rx_util_pkg.assign_column('A12','TRX.CUSTOMER_TRX_ID' ,'APPLIED_CUSTOMER_TRX_ID',
789: 'arrx_rc.var.applied_customer_trx_id' ,'NUMBER');
790: fa_rx_util_pkg.assign_column('A13','DECODE(RA.STATUS, ''ACC'', :l_trx_on_acc, TRX.TRX_NUMBER)','TRX_NUMBER' ,
791: 'arrx_rc.var.trx_number','VARCHAR2', 20);
792: fa_rx_util_pkg.assign_column('A14','TRX.INVOICE_CURRENCY_CODE','TRX_CURRENCY_CODE',
793: 'arrx_rc.var.trx_currency_code' ,'VARCHAR2', 15);
794: fa_rx_util_pkg.assign_column('A15','TRX.TRX_DATE','TRX_DATE',
795: 'arrx_rc.var.trx_date','DATE');
796: fa_rx_util_pkg.assign_column('A16','REC.AMOUNT','TRX_AMOUNT' ,
790: fa_rx_util_pkg.assign_column('A13','DECODE(RA.STATUS, ''ACC'', :l_trx_on_acc, TRX.TRX_NUMBER)','TRX_NUMBER' ,
791: 'arrx_rc.var.trx_number','VARCHAR2', 20);
792: fa_rx_util_pkg.assign_column('A14','TRX.INVOICE_CURRENCY_CODE','TRX_CURRENCY_CODE',
793: 'arrx_rc.var.trx_currency_code' ,'VARCHAR2', 15);
794: fa_rx_util_pkg.assign_column('A15','TRX.TRX_DATE','TRX_DATE',
795: 'arrx_rc.var.trx_date','DATE');
796: fa_rx_util_pkg.assign_column('A16','REC.AMOUNT','TRX_AMOUNT' ,
797: 'arrx_rc.var.trx_amount','NUMBER');
798: fa_rx_util_pkg.assign_column('A17','REC.ACCTD_AMOUNT' ,'ACCTD_TRX_AMOUNT',
792: fa_rx_util_pkg.assign_column('A14','TRX.INVOICE_CURRENCY_CODE','TRX_CURRENCY_CODE',
793: 'arrx_rc.var.trx_currency_code' ,'VARCHAR2', 15);
794: fa_rx_util_pkg.assign_column('A15','TRX.TRX_DATE','TRX_DATE',
795: 'arrx_rc.var.trx_date','DATE');
796: fa_rx_util_pkg.assign_column('A16','REC.AMOUNT','TRX_AMOUNT' ,
797: 'arrx_rc.var.trx_amount','NUMBER');
798: fa_rx_util_pkg.assign_column('A17','REC.ACCTD_AMOUNT' ,'ACCTD_TRX_AMOUNT',
799: 'arrx_rc.var.acctd_trx_amount' ,'NUMBER');
800:
794: fa_rx_util_pkg.assign_column('A15','TRX.TRX_DATE','TRX_DATE',
795: 'arrx_rc.var.trx_date','DATE');
796: fa_rx_util_pkg.assign_column('A16','REC.AMOUNT','TRX_AMOUNT' ,
797: 'arrx_rc.var.trx_amount','NUMBER');
798: fa_rx_util_pkg.assign_column('A17','REC.ACCTD_AMOUNT' ,'ACCTD_TRX_AMOUNT',
799: 'arrx_rc.var.acctd_trx_amount' ,'NUMBER');
800:
801: fa_rx_util_pkg.debug('Define additional FROM_CLAUSE for Actual Receipts Register');
802:
797: 'arrx_rc.var.trx_amount','NUMBER');
798: fa_rx_util_pkg.assign_column('A17','REC.ACCTD_AMOUNT' ,'ACCTD_TRX_AMOUNT',
799: 'arrx_rc.var.acctd_trx_amount' ,'NUMBER');
800:
801: fa_rx_util_pkg.debug('Define additional FROM_CLAUSE for Actual Receipts Register');
802:
803: IF NVL(var.ca_sob_type,'P') = 'P' THEN
804: fa_rx_util_pkg.From_Clause :=
805: fa_rx_util_pkg.From_Clause || ',
800:
801: fa_rx_util_pkg.debug('Define additional FROM_CLAUSE for Actual Receipts Register');
802:
803: IF NVL(var.ca_sob_type,'P') = 'P' THEN
804: fa_rx_util_pkg.From_Clause :=
805: fa_rx_util_pkg.From_Clause || ',
806: AR_RECEIVABLE_APPLICATIONS RA,
807: RA_CUSTOMER_TRX TRX,
808: RA_CUST_TRX_LINE_GL_DIST REC';
801: fa_rx_util_pkg.debug('Define additional FROM_CLAUSE for Actual Receipts Register');
802:
803: IF NVL(var.ca_sob_type,'P') = 'P' THEN
804: fa_rx_util_pkg.From_Clause :=
805: fa_rx_util_pkg.From_Clause || ',
806: AR_RECEIVABLE_APPLICATIONS RA,
807: RA_CUSTOMER_TRX TRX,
808: RA_CUST_TRX_LINE_GL_DIST REC';
809: ELSE
806: AR_RECEIVABLE_APPLICATIONS RA,
807: RA_CUSTOMER_TRX TRX,
808: RA_CUST_TRX_LINE_GL_DIST REC';
809: ELSE
810: fa_rx_util_pkg.From_Clause :=
811: fa_rx_util_pkg.From_Clause || ',
812: AR_RECEIVABLE_APPS_ALL_MRC_V RA,
813: RA_CUSTOMER_TRX_ALL_MRC_V TRX,
814: RA_TRX_LINE_GL_DIST_ALL_MRC_V REC';
807: RA_CUSTOMER_TRX TRX,
808: RA_CUST_TRX_LINE_GL_DIST REC';
809: ELSE
810: fa_rx_util_pkg.From_Clause :=
811: fa_rx_util_pkg.From_Clause || ',
812: AR_RECEIVABLE_APPS_ALL_MRC_V RA,
813: RA_CUSTOMER_TRX_ALL_MRC_V TRX,
814: RA_TRX_LINE_GL_DIST_ALL_MRC_V REC';
815: END IF;
813: RA_CUSTOMER_TRX_ALL_MRC_V TRX,
814: RA_TRX_LINE_GL_DIST_ALL_MRC_V REC';
815: END IF;
816:
817: fa_rx_util_pkg.debug('Define additional WHERE_CLAUSE for Actual Receipts Register');
818:
819: fa_rx_util_pkg.Where_Clause :=
820: fa_rx_util_pkg.Where_Clause || '
821: AND RA.CASH_RECEIPT_ID = CR.CASH_RECEIPT_ID
815: END IF;
816:
817: fa_rx_util_pkg.debug('Define additional WHERE_CLAUSE for Actual Receipts Register');
818:
819: fa_rx_util_pkg.Where_Clause :=
820: fa_rx_util_pkg.Where_Clause || '
821: AND RA.CASH_RECEIPT_ID = CR.CASH_RECEIPT_ID
822: AND RA.DISPLAY = ''Y''
823: AND RA.APPLIED_CUSTOMER_TRX_ID = TRX.CUSTOMER_TRX_ID(+)
816:
817: fa_rx_util_pkg.debug('Define additional WHERE_CLAUSE for Actual Receipts Register');
818:
819: fa_rx_util_pkg.Where_Clause :=
820: fa_rx_util_pkg.Where_Clause || '
821: AND RA.CASH_RECEIPT_ID = CR.CASH_RECEIPT_ID
822: AND RA.DISPLAY = ''Y''
823: AND RA.APPLIED_CUSTOMER_TRX_ID = TRX.CUSTOMER_TRX_ID(+)
824: AND RA.APPLIED_CUSTOMER_TRX_ID = REC.CUSTOMER_TRX_ID(+)
824: AND RA.APPLIED_CUSTOMER_TRX_ID = REC.CUSTOMER_TRX_ID(+)
825: AND REC.LATEST_REC_FLAG(+) = ''Y''
826: AND CRH.FIRST_POSTED_RECORD_FLAG = ''Y'' ';
827:
828: fa_rx_util_pkg.debug('Define additional WHERE_CLAUSE for Actual Receipts Register Pos2');
829: /*
830: fa_rx_util_pkg.Where_Clause :=
831: fa_rx_util_pkg.Where_Clause || ' ' ||
832: L_CR_ORG_WHERE || ' ' ||
826: AND CRH.FIRST_POSTED_RECORD_FLAG = ''Y'' ';
827:
828: fa_rx_util_pkg.debug('Define additional WHERE_CLAUSE for Actual Receipts Register Pos2');
829: /*
830: fa_rx_util_pkg.Where_Clause :=
831: fa_rx_util_pkg.Where_Clause || ' ' ||
832: L_CR_ORG_WHERE || ' ' ||
833: L_TAX_ORG_WHERE || ' ' ||
834: L_ABA_ORG_WHERE || ' ' ||
827:
828: fa_rx_util_pkg.debug('Define additional WHERE_CLAUSE for Actual Receipts Register Pos2');
829: /*
830: fa_rx_util_pkg.Where_Clause :=
831: fa_rx_util_pkg.Where_Clause || ' ' ||
832: L_CR_ORG_WHERE || ' ' ||
833: L_TAX_ORG_WHERE || ' ' ||
834: L_ABA_ORG_WHERE || ' ' ||
835: L_CRH_ORG_WHERE || ' ' ||
844: ------------------------------------------
845: ELSIF var.calling_program = 'APPLIED' then
846: ------------------------------------------
847:
848: fa_rx_util_pkg.debug('Define additional WHERE_CLAUSE for Applied Receipts Register');
849:
850: IF var.p_apply_date_low IS NULL AND var.p_apply_date_high IS NULL THEN
851: APPLY_DATE_WHERE := NULL;
852: ELSIF var.p_apply_date_low IS NULL THEN
935: SHOW_BILL_FROM := NULL;
936: L_CI_ORG_WHERE := NULL;
937: END IF;
938:
939: fa_rx_util_pkg.debug('Define additional ASSIGN_COLUMNS for Applied Receipts Register');
940:
941: fa_rx_util_pkg.assign_column('A1 ','RA.RECEIVABLE_APPLICATION_ID' ,'RECEIVABLE_APPLICATION_ID',
942: 'arrx_rc.var.receivable_application_id' ,'NUMBER');
943: fa_rx_util_pkg.assign_column('A2 ','RA.APPLY_DATE' ,'APPLY_DATE' ,
937: END IF;
938:
939: fa_rx_util_pkg.debug('Define additional ASSIGN_COLUMNS for Applied Receipts Register');
940:
941: fa_rx_util_pkg.assign_column('A1 ','RA.RECEIVABLE_APPLICATION_ID' ,'RECEIVABLE_APPLICATION_ID',
942: 'arrx_rc.var.receivable_application_id' ,'NUMBER');
943: fa_rx_util_pkg.assign_column('A2 ','RA.APPLY_DATE' ,'APPLY_DATE' ,
944: 'arrx_rc.var.apply_date','DATE');
945: fa_rx_util_pkg.assign_column('A3 ','RAC.ACCOUNT_NUMBER' ,'RELATED_CUSTOMER' ,
939: fa_rx_util_pkg.debug('Define additional ASSIGN_COLUMNS for Applied Receipts Register');
940:
941: fa_rx_util_pkg.assign_column('A1 ','RA.RECEIVABLE_APPLICATION_ID' ,'RECEIVABLE_APPLICATION_ID',
942: 'arrx_rc.var.receivable_application_id' ,'NUMBER');
943: fa_rx_util_pkg.assign_column('A2 ','RA.APPLY_DATE' ,'APPLY_DATE' ,
944: 'arrx_rc.var.apply_date','DATE');
945: fa_rx_util_pkg.assign_column('A3 ','RAC.ACCOUNT_NUMBER' ,'RELATED_CUSTOMER' ,
946: 'arrx_rc.var.related_customer','VARCHAR2', 50);
947: fa_rx_util_pkg.assign_column('A4 ','NVL(RA.AMOUNT_APPLIED,0)','AMOUNT_APPLIED_TO',
941: fa_rx_util_pkg.assign_column('A1 ','RA.RECEIVABLE_APPLICATION_ID' ,'RECEIVABLE_APPLICATION_ID',
942: 'arrx_rc.var.receivable_application_id' ,'NUMBER');
943: fa_rx_util_pkg.assign_column('A2 ','RA.APPLY_DATE' ,'APPLY_DATE' ,
944: 'arrx_rc.var.apply_date','DATE');
945: fa_rx_util_pkg.assign_column('A3 ','RAC.ACCOUNT_NUMBER' ,'RELATED_CUSTOMER' ,
946: 'arrx_rc.var.related_customer','VARCHAR2', 50);
947: fa_rx_util_pkg.assign_column('A4 ','NVL(RA.AMOUNT_APPLIED,0)','AMOUNT_APPLIED_TO',
948: 'arrx_rc.var.amount_applied_to' ,'NUMBER');
949: fa_rx_util_pkg.assign_column('A5 ','NVL(RA.AMOUNT_APPLIED_FROM,RA.AMOUNT_APPLIED)' ,'AMOUNT_APPLIED_FROM',
943: fa_rx_util_pkg.assign_column('A2 ','RA.APPLY_DATE' ,'APPLY_DATE' ,
944: 'arrx_rc.var.apply_date','DATE');
945: fa_rx_util_pkg.assign_column('A3 ','RAC.ACCOUNT_NUMBER' ,'RELATED_CUSTOMER' ,
946: 'arrx_rc.var.related_customer','VARCHAR2', 50);
947: fa_rx_util_pkg.assign_column('A4 ','NVL(RA.AMOUNT_APPLIED,0)','AMOUNT_APPLIED_TO',
948: 'arrx_rc.var.amount_applied_to' ,'NUMBER');
949: fa_rx_util_pkg.assign_column('A5 ','NVL(RA.AMOUNT_APPLIED_FROM,RA.AMOUNT_APPLIED)' ,'AMOUNT_APPLIED_FROM',
950: 'arrx_rc.var.amount_applied_from' ,'NUMBER');
951: fa_rx_util_pkg.assign_column('A6 ',applied_total ,'ACCTD_AMOUNT_APPLIED_TO',
945: fa_rx_util_pkg.assign_column('A3 ','RAC.ACCOUNT_NUMBER' ,'RELATED_CUSTOMER' ,
946: 'arrx_rc.var.related_customer','VARCHAR2', 50);
947: fa_rx_util_pkg.assign_column('A4 ','NVL(RA.AMOUNT_APPLIED,0)','AMOUNT_APPLIED_TO',
948: 'arrx_rc.var.amount_applied_to' ,'NUMBER');
949: fa_rx_util_pkg.assign_column('A5 ','NVL(RA.AMOUNT_APPLIED_FROM,RA.AMOUNT_APPLIED)' ,'AMOUNT_APPLIED_FROM',
950: 'arrx_rc.var.amount_applied_from' ,'NUMBER');
951: fa_rx_util_pkg.assign_column('A6 ',applied_total ,'ACCTD_AMOUNT_APPLIED_TO',
952: 'arrx_rc.var.acctd_amount_applied_to' ,'NUMBER');
953: fa_rx_util_pkg.assign_column('A7 ','NVL(RA.ACCTD_AMOUNT_APPLIED_FROM,0)' ,'ACCTD_AMOUNT_APPLIED_FROM',
947: fa_rx_util_pkg.assign_column('A4 ','NVL(RA.AMOUNT_APPLIED,0)','AMOUNT_APPLIED_TO',
948: 'arrx_rc.var.amount_applied_to' ,'NUMBER');
949: fa_rx_util_pkg.assign_column('A5 ','NVL(RA.AMOUNT_APPLIED_FROM,RA.AMOUNT_APPLIED)' ,'AMOUNT_APPLIED_FROM',
950: 'arrx_rc.var.amount_applied_from' ,'NUMBER');
951: fa_rx_util_pkg.assign_column('A6 ',applied_total ,'ACCTD_AMOUNT_APPLIED_TO',
952: 'arrx_rc.var.acctd_amount_applied_to' ,'NUMBER');
953: fa_rx_util_pkg.assign_column('A7 ','NVL(RA.ACCTD_AMOUNT_APPLIED_FROM,0)' ,'ACCTD_AMOUNT_APPLIED_FROM',
954: 'arrx_rc.var.acctd_amount_applied_from' ,'NUMBER');
955: fa_rx_util_pkg.assign_column('A8 ','NVL(RA.EARNED_DISCOUNT_TAKEN,0)' ,'EARNED_DISCOUNT_TAKEN',
949: fa_rx_util_pkg.assign_column('A5 ','NVL(RA.AMOUNT_APPLIED_FROM,RA.AMOUNT_APPLIED)' ,'AMOUNT_APPLIED_FROM',
950: 'arrx_rc.var.amount_applied_from' ,'NUMBER');
951: fa_rx_util_pkg.assign_column('A6 ',applied_total ,'ACCTD_AMOUNT_APPLIED_TO',
952: 'arrx_rc.var.acctd_amount_applied_to' ,'NUMBER');
953: fa_rx_util_pkg.assign_column('A7 ','NVL(RA.ACCTD_AMOUNT_APPLIED_FROM,0)' ,'ACCTD_AMOUNT_APPLIED_FROM',
954: 'arrx_rc.var.acctd_amount_applied_from' ,'NUMBER');
955: fa_rx_util_pkg.assign_column('A8 ','NVL(RA.EARNED_DISCOUNT_TAKEN,0)' ,'EARNED_DISCOUNT_TAKEN',
956: 'arrx_rc.var.earned_discount_taken' ,'NUMBER');
957: fa_rx_util_pkg.assign_column('A9 ','NVL(RA.UNEARNED_DISCOUNT_TAKEN,0)' ,'UNEARNED_DISCOUNT_TAKEN',
951: fa_rx_util_pkg.assign_column('A6 ',applied_total ,'ACCTD_AMOUNT_APPLIED_TO',
952: 'arrx_rc.var.acctd_amount_applied_to' ,'NUMBER');
953: fa_rx_util_pkg.assign_column('A7 ','NVL(RA.ACCTD_AMOUNT_APPLIED_FROM,0)' ,'ACCTD_AMOUNT_APPLIED_FROM',
954: 'arrx_rc.var.acctd_amount_applied_from' ,'NUMBER');
955: fa_rx_util_pkg.assign_column('A8 ','NVL(RA.EARNED_DISCOUNT_TAKEN,0)' ,'EARNED_DISCOUNT_TAKEN',
956: 'arrx_rc.var.earned_discount_taken' ,'NUMBER');
957: fa_rx_util_pkg.assign_column('A9 ','NVL(RA.UNEARNED_DISCOUNT_TAKEN,0)' ,'UNEARNED_DISCOUNT_TAKEN',
958: 'arrx_rc.var.unearned_discount_taken' ,'NUMBER');
959: fa_rx_util_pkg.assign_column('A10','NVL(RA.ACCTD_EARNED_DISCOUNT_TAKEN,0)' ,'ACCTD_EARNED_DISCOUNT_TAKEN',
953: fa_rx_util_pkg.assign_column('A7 ','NVL(RA.ACCTD_AMOUNT_APPLIED_FROM,0)' ,'ACCTD_AMOUNT_APPLIED_FROM',
954: 'arrx_rc.var.acctd_amount_applied_from' ,'NUMBER');
955: fa_rx_util_pkg.assign_column('A8 ','NVL(RA.EARNED_DISCOUNT_TAKEN,0)' ,'EARNED_DISCOUNT_TAKEN',
956: 'arrx_rc.var.earned_discount_taken' ,'NUMBER');
957: fa_rx_util_pkg.assign_column('A9 ','NVL(RA.UNEARNED_DISCOUNT_TAKEN,0)' ,'UNEARNED_DISCOUNT_TAKEN',
958: 'arrx_rc.var.unearned_discount_taken' ,'NUMBER');
959: fa_rx_util_pkg.assign_column('A10','NVL(RA.ACCTD_EARNED_DISCOUNT_TAKEN,0)' ,'ACCTD_EARNED_DISCOUNT_TAKEN',
960: 'arrx_rc.var.acctd_earned_discount_taken' ,'NUMBER');
961: fa_rx_util_pkg.assign_column('A11','NVL(RA.ACCTD_UNEARNED_DISCOUNT_TAKEN,0)' ,'ACCTD_UNEARNED_DISCOUNT_TAKEN',
955: fa_rx_util_pkg.assign_column('A8 ','NVL(RA.EARNED_DISCOUNT_TAKEN,0)' ,'EARNED_DISCOUNT_TAKEN',
956: 'arrx_rc.var.earned_discount_taken' ,'NUMBER');
957: fa_rx_util_pkg.assign_column('A9 ','NVL(RA.UNEARNED_DISCOUNT_TAKEN,0)' ,'UNEARNED_DISCOUNT_TAKEN',
958: 'arrx_rc.var.unearned_discount_taken' ,'NUMBER');
959: fa_rx_util_pkg.assign_column('A10','NVL(RA.ACCTD_EARNED_DISCOUNT_TAKEN,0)' ,'ACCTD_EARNED_DISCOUNT_TAKEN',
960: 'arrx_rc.var.acctd_earned_discount_taken' ,'NUMBER');
961: fa_rx_util_pkg.assign_column('A11','NVL(RA.ACCTD_UNEARNED_DISCOUNT_TAKEN,0)' ,'ACCTD_UNEARNED_DISCOUNT_TAKEN',
962: 'arrx_rc.var.acctd_unearned_discount_taken' ,'NUMBER');
963: fa_rx_util_pkg.assign_column('A12','TRX.CUSTOMER_TRX_ID' ,'APPLIED_CUSTOMER_TRX_ID',
957: fa_rx_util_pkg.assign_column('A9 ','NVL(RA.UNEARNED_DISCOUNT_TAKEN,0)' ,'UNEARNED_DISCOUNT_TAKEN',
958: 'arrx_rc.var.unearned_discount_taken' ,'NUMBER');
959: fa_rx_util_pkg.assign_column('A10','NVL(RA.ACCTD_EARNED_DISCOUNT_TAKEN,0)' ,'ACCTD_EARNED_DISCOUNT_TAKEN',
960: 'arrx_rc.var.acctd_earned_discount_taken' ,'NUMBER');
961: fa_rx_util_pkg.assign_column('A11','NVL(RA.ACCTD_UNEARNED_DISCOUNT_TAKEN,0)' ,'ACCTD_UNEARNED_DISCOUNT_TAKEN',
962: 'arrx_rc.var.acctd_unearned_discount_taken' ,'NUMBER');
963: fa_rx_util_pkg.assign_column('A12','TRX.CUSTOMER_TRX_ID' ,'APPLIED_CUSTOMER_TRX_ID',
964: 'arrx_rc.var.applied_customer_trx_id' ,'NUMBER');
965:
959: fa_rx_util_pkg.assign_column('A10','NVL(RA.ACCTD_EARNED_DISCOUNT_TAKEN,0)' ,'ACCTD_EARNED_DISCOUNT_TAKEN',
960: 'arrx_rc.var.acctd_earned_discount_taken' ,'NUMBER');
961: fa_rx_util_pkg.assign_column('A11','NVL(RA.ACCTD_UNEARNED_DISCOUNT_TAKEN,0)' ,'ACCTD_UNEARNED_DISCOUNT_TAKEN',
962: 'arrx_rc.var.acctd_unearned_discount_taken' ,'NUMBER');
963: fa_rx_util_pkg.assign_column('A12','TRX.CUSTOMER_TRX_ID' ,'APPLIED_CUSTOMER_TRX_ID',
964: 'arrx_rc.var.applied_customer_trx_id' ,'NUMBER');
965:
966: IF (BILL_FLAG = 'Y') THEN
967: fa_rx_util_pkg.assign_column('A13','decode(ra.status, ''ACC'', :L_ONACCOUNT
963: fa_rx_util_pkg.assign_column('A12','TRX.CUSTOMER_TRX_ID' ,'APPLIED_CUSTOMER_TRX_ID',
964: 'arrx_rc.var.applied_customer_trx_id' ,'NUMBER');
965:
966: IF (BILL_FLAG = 'Y') THEN
967: fa_rx_util_pkg.assign_column('A13','decode(ra.status, ''ACC'', :L_ONACCOUNT
968: , decode(ci.cons_billing_number, null, ps.trx_number
969: , substrb(rtrim(ci.cons_billing_number)||''/''||rtrim(to_char(trx.trx_number)),1,30)))' ,'TRX_NUMBER',
970: 'arrx_rc.var.trx_number' ,'VARCHAR2', 30);-- bug 5767413
971: ELSE
968: , decode(ci.cons_billing_number, null, ps.trx_number
969: , substrb(rtrim(ci.cons_billing_number)||''/''||rtrim(to_char(trx.trx_number)),1,30)))' ,'TRX_NUMBER',
970: 'arrx_rc.var.trx_number' ,'VARCHAR2', 30);-- bug 5767413
971: ELSE
972: fa_rx_util_pkg.assign_column('A13','decode(ra.status, ''ACC'', :L_ONACCOUNT, PS.TRX_NUMBER)','TRX_NUMBER' ,
973: 'arrx_rc.var.trx_number','VARCHAR2', 30);--bug 5767413
974: END IF;
975:
976: fa_rx_util_pkg.assign_column('A14','TRX.INVOICE_CURRENCY_CODE' ,'TRX_CURRENCY_CODE',
972: fa_rx_util_pkg.assign_column('A13','decode(ra.status, ''ACC'', :L_ONACCOUNT, PS.TRX_NUMBER)','TRX_NUMBER' ,
973: 'arrx_rc.var.trx_number','VARCHAR2', 30);--bug 5767413
974: END IF;
975:
976: fa_rx_util_pkg.assign_column('A14','TRX.INVOICE_CURRENCY_CODE' ,'TRX_CURRENCY_CODE',
977: 'arrx_rc.var.trx_currency_code' ,'VARCHAR2', 15);
978: fa_rx_util_pkg.assign_column('A15','TRX.TRX_DATE' ,'TRX_DATE' ,
979: 'arrx_rc.var.trx_date','DATE');
980: fa_rx_util_pkg.assign_column('A16','NVL(REC.AMOUNT,0)' ,'TRX_AMOUNT' ,
974: END IF;
975:
976: fa_rx_util_pkg.assign_column('A14','TRX.INVOICE_CURRENCY_CODE' ,'TRX_CURRENCY_CODE',
977: 'arrx_rc.var.trx_currency_code' ,'VARCHAR2', 15);
978: fa_rx_util_pkg.assign_column('A15','TRX.TRX_DATE' ,'TRX_DATE' ,
979: 'arrx_rc.var.trx_date','DATE');
980: fa_rx_util_pkg.assign_column('A16','NVL(REC.AMOUNT,0)' ,'TRX_AMOUNT' ,
981: 'arrx_rc.var.trx_amount','NUMBER');
982: fa_rx_util_pkg.assign_column('A17','NVL(REC.ACCTD_AMOUNT,0)' ,'ACCTD_TRX_AMOUNT',
976: fa_rx_util_pkg.assign_column('A14','TRX.INVOICE_CURRENCY_CODE' ,'TRX_CURRENCY_CODE',
977: 'arrx_rc.var.trx_currency_code' ,'VARCHAR2', 15);
978: fa_rx_util_pkg.assign_column('A15','TRX.TRX_DATE' ,'TRX_DATE' ,
979: 'arrx_rc.var.trx_date','DATE');
980: fa_rx_util_pkg.assign_column('A16','NVL(REC.AMOUNT,0)' ,'TRX_AMOUNT' ,
981: 'arrx_rc.var.trx_amount','NUMBER');
982: fa_rx_util_pkg.assign_column('A17','NVL(REC.ACCTD_AMOUNT,0)' ,'ACCTD_TRX_AMOUNT',
983: 'arrx_rc.var.acctd_trx_amount' ,'NUMBER');
984: fa_rx_util_pkg.assign_column('A18',rec_gain_loss ,'RECEIPT_GAIN_LOSS',
978: fa_rx_util_pkg.assign_column('A15','TRX.TRX_DATE' ,'TRX_DATE' ,
979: 'arrx_rc.var.trx_date','DATE');
980: fa_rx_util_pkg.assign_column('A16','NVL(REC.AMOUNT,0)' ,'TRX_AMOUNT' ,
981: 'arrx_rc.var.trx_amount','NUMBER');
982: fa_rx_util_pkg.assign_column('A17','NVL(REC.ACCTD_AMOUNT,0)' ,'ACCTD_TRX_AMOUNT',
983: 'arrx_rc.var.acctd_trx_amount' ,'NUMBER');
984: fa_rx_util_pkg.assign_column('A18',rec_gain_loss ,'RECEIPT_GAIN_LOSS',
985: 'arrx_rc.var.receipt_gain_loss' ,'NUMBER');
986: -- bug 1821300. Override RR gl_date with ARR gl_date to avoid ora-00957
980: fa_rx_util_pkg.assign_column('A16','NVL(REC.AMOUNT,0)' ,'TRX_AMOUNT' ,
981: 'arrx_rc.var.trx_amount','NUMBER');
982: fa_rx_util_pkg.assign_column('A17','NVL(REC.ACCTD_AMOUNT,0)' ,'ACCTD_TRX_AMOUNT',
983: 'arrx_rc.var.acctd_trx_amount' ,'NUMBER');
984: fa_rx_util_pkg.assign_column('A18',rec_gain_loss ,'RECEIPT_GAIN_LOSS',
985: 'arrx_rc.var.receipt_gain_loss' ,'NUMBER');
986: -- bug 1821300. Override RR gl_date with ARR gl_date to avoid ora-00957
987: fa_rx_util_pkg.assign_column('340','RA.GL_DATE' ,'GL_DATE' ,
988: 'arrx_rc.var.gl_date','DATE');
983: 'arrx_rc.var.acctd_trx_amount' ,'NUMBER');
984: fa_rx_util_pkg.assign_column('A18',rec_gain_loss ,'RECEIPT_GAIN_LOSS',
985: 'arrx_rc.var.receipt_gain_loss' ,'NUMBER');
986: -- bug 1821300. Override RR gl_date with ARR gl_date to avoid ora-00957
987: fa_rx_util_pkg.assign_column('340','RA.GL_DATE' ,'GL_DATE' ,
988: 'arrx_rc.var.gl_date','DATE');
989: -- bug 2379856. Override CRH.ccid with RA.ccid
990: fa_rx_util_pkg.assign_column('400','CC2.CODE_COMBINATION_ID' ,'ACCOUNT_CODE_COMBINATION_ID',
991: 'arrx_rc.var.account_code_combination_id' ,'NUMBER');
986: -- bug 1821300. Override RR gl_date with ARR gl_date to avoid ora-00957
987: fa_rx_util_pkg.assign_column('340','RA.GL_DATE' ,'GL_DATE' ,
988: 'arrx_rc.var.gl_date','DATE');
989: -- bug 2379856. Override CRH.ccid with RA.ccid
990: fa_rx_util_pkg.assign_column('400','CC2.CODE_COMBINATION_ID' ,'ACCOUNT_CODE_COMBINATION_ID',
991: 'arrx_rc.var.account_code_combination_id' ,'NUMBER');
992: fa_rx_util_pkg.assign_column('500','BS.NAME' ,'BATCH_SOURCE',
993: 'arrx_rc.var.batch_source' ,'VARCHAR2',50);
994:
988: 'arrx_rc.var.gl_date','DATE');
989: -- bug 2379856. Override CRH.ccid with RA.ccid
990: fa_rx_util_pkg.assign_column('400','CC2.CODE_COMBINATION_ID' ,'ACCOUNT_CODE_COMBINATION_ID',
991: 'arrx_rc.var.account_code_combination_id' ,'NUMBER');
992: fa_rx_util_pkg.assign_column('500','BS.NAME' ,'BATCH_SOURCE',
993: 'arrx_rc.var.batch_source' ,'VARCHAR2',50);
994:
995: fa_rx_util_pkg.debug('Define additional FROM_CLAUSE for Applied Receipts Register');
996:
991: 'arrx_rc.var.account_code_combination_id' ,'NUMBER');
992: fa_rx_util_pkg.assign_column('500','BS.NAME' ,'BATCH_SOURCE',
993: 'arrx_rc.var.batch_source' ,'VARCHAR2',50);
994:
995: fa_rx_util_pkg.debug('Define additional FROM_CLAUSE for Applied Receipts Register');
996:
997: IF NVL(var.ca_sob_type,'P') = 'P' THEN
998: fa_rx_util_pkg.From_Clause :=
999: fa_rx_util_pkg.From_Clause ||
994:
995: fa_rx_util_pkg.debug('Define additional FROM_CLAUSE for Applied Receipts Register');
996:
997: IF NVL(var.ca_sob_type,'P') = 'P' THEN
998: fa_rx_util_pkg.From_Clause :=
999: fa_rx_util_pkg.From_Clause ||
1000: ', AR_RECEIVABLE_APPLICATIONS RA,
1001: RA_CUSTOMER_TRX TRX,
1002: RA_CUST_TRX_LINE_GL_DIST REC,
995: fa_rx_util_pkg.debug('Define additional FROM_CLAUSE for Applied Receipts Register');
996:
997: IF NVL(var.ca_sob_type,'P') = 'P' THEN
998: fa_rx_util_pkg.From_Clause :=
999: fa_rx_util_pkg.From_Clause ||
1000: ', AR_RECEIVABLE_APPLICATIONS RA,
1001: RA_CUSTOMER_TRX TRX,
1002: RA_CUST_TRX_LINE_GL_DIST REC,
1003: HZ_CUST_ACCOUNTS RAC ,
1004: AR_PAYMENT_SCHEDULES PS ,
1005: AR_BATCH_SOURCES BS ,
1006: GL_CODE_COMBINATIONS CC2 ' || SHOW_BILL_FROM;
1007: ELSE
1008: fa_rx_util_pkg.From_Clause :=
1009: fa_rx_util_pkg.From_Clause ||
1010: ', AR_RECEIVABLE_APPS_ALL_MRC_V RA,
1011: RA_CUSTOMER_TRX_ALL_MRC_V TRX,
1012: RA_TRX_LINE_GL_DIST_ALL_MRC_V REC,
1005: AR_BATCH_SOURCES BS ,
1006: GL_CODE_COMBINATIONS CC2 ' || SHOW_BILL_FROM;
1007: ELSE
1008: fa_rx_util_pkg.From_Clause :=
1009: fa_rx_util_pkg.From_Clause ||
1010: ', AR_RECEIVABLE_APPS_ALL_MRC_V RA,
1011: RA_CUSTOMER_TRX_ALL_MRC_V TRX,
1012: RA_TRX_LINE_GL_DIST_ALL_MRC_V REC,
1013: HZ_CUST_ACCOUNTS_ALL RAC ,
1014: AR_PAYMENT_SCHEDULES_ALL_MRC_V PS ,
1015: GL_CODE_COMBINATIONS CC2 ' || SHOW_BILL_FROM;
1016: END IF;
1017:
1018: fa_rx_util_pkg.Where_Clause :=
1019: fa_rx_util_pkg.Where_Clause ||
1020: ' AND RA.CASH_RECEIPT_ID = CR.CASH_RECEIPT_ID
1021: AND ( RA.STATUS = ''APP'' OR
1022: (RA.STATUS = ''ACTIVITY'' AND
1015: GL_CODE_COMBINATIONS CC2 ' || SHOW_BILL_FROM;
1016: END IF;
1017:
1018: fa_rx_util_pkg.Where_Clause :=
1019: fa_rx_util_pkg.Where_Clause ||
1020: ' AND RA.CASH_RECEIPT_ID = CR.CASH_RECEIPT_ID
1021: AND ( RA.STATUS = ''APP'' OR
1022: (RA.STATUS = ''ACTIVITY'' AND
1023: RA.RECEIVABLES_TRX_ID = -16))
1039:
1040: IF (var.p_receipt_gl_date_low IS NOT NULL AND var.p_receipt_gl_date_high IS NOT NULL)
1041: OR
1042: (var.p_gl_date_low IS NOT NULL AND var.p_gl_date_high IS NOT NULL) THEN
1043: fa_rx_util_pkg.Hint_Clause := '/*+ leading(ra) */';
1044: END IF;
1045:
1046: ---------------------------------------
1047: ELSIF var.calling_program = 'MISC' then
1046: ---------------------------------------
1047: ELSIF var.calling_program = 'MISC' then
1048: ---------------------------------------
1049:
1050: fa_rx_util_pkg.debug('Define additional ASSIGN_COLUMNS for Misc Receipts Register');
1051:
1052: fa_rx_util_pkg.assign_column('A1 ','decode(ARD.SOURCE_TYPE,''TAX'',NULL,MCD.PERCENT)' ,'MISC_PERCENT',
1053: 'arrx_rc.var.percent' ,'NUMBER');
1054: -- bug5444415
1048: ---------------------------------------
1049:
1050: fa_rx_util_pkg.debug('Define additional ASSIGN_COLUMNS for Misc Receipts Register');
1051:
1052: fa_rx_util_pkg.assign_column('A1 ','decode(ARD.SOURCE_TYPE,''TAX'',NULL,MCD.PERCENT)' ,'MISC_PERCENT',
1053: 'arrx_rc.var.percent' ,'NUMBER');
1054: -- bug5444415
1055: IF arp_global.sysparam.accounting_method='ACCRUAL' THEN
1056: fa_rx_util_pkg.assign_column('A2 ','decode(SIGN(MCD.AMOUNT), 1, ARD.AMOUNT_CR,-1, SIGN(MCD.AMOUNT) * ARD.AMOUNT_DR, 0)' ,'MISC_AMOUNT' ,
1052: fa_rx_util_pkg.assign_column('A1 ','decode(ARD.SOURCE_TYPE,''TAX'',NULL,MCD.PERCENT)' ,'MISC_PERCENT',
1053: 'arrx_rc.var.percent' ,'NUMBER');
1054: -- bug5444415
1055: IF arp_global.sysparam.accounting_method='ACCRUAL' THEN
1056: fa_rx_util_pkg.assign_column('A2 ','decode(SIGN(MCD.AMOUNT), 1, ARD.AMOUNT_CR,-1, SIGN(MCD.AMOUNT) * ARD.AMOUNT_DR, 0)' ,'MISC_AMOUNT' ,
1057: 'arrx_rc.var.misc_amount' ,'NUMBER');
1058: ELSE
1059: fa_rx_util_pkg.assign_column('A2 ','MCD.AMOUNT','MISC_AMOUNT' ,'arrx_rc.var.misc_amount' ,'NUMBER');
1060: END IF ;
1055: IF arp_global.sysparam.accounting_method='ACCRUAL' THEN
1056: fa_rx_util_pkg.assign_column('A2 ','decode(SIGN(MCD.AMOUNT), 1, ARD.AMOUNT_CR,-1, SIGN(MCD.AMOUNT) * ARD.AMOUNT_DR, 0)' ,'MISC_AMOUNT' ,
1057: 'arrx_rc.var.misc_amount' ,'NUMBER');
1058: ELSE
1059: fa_rx_util_pkg.assign_column('A2 ','MCD.AMOUNT','MISC_AMOUNT' ,'arrx_rc.var.misc_amount' ,'NUMBER');
1060: END IF ;
1061: fa_rx_util_pkg.assign_column('A3 ','BS.NAME' ,'BATCH_SOURCE',
1062: 'arrx_rc.var.batch_source' ,'VARCHAR2',50);
1063: /* Bugfix 2842928. Override CRH.ccid with ARD.ccid */
1057: 'arrx_rc.var.misc_amount' ,'NUMBER');
1058: ELSE
1059: fa_rx_util_pkg.assign_column('A2 ','MCD.AMOUNT','MISC_AMOUNT' ,'arrx_rc.var.misc_amount' ,'NUMBER');
1060: END IF ;
1061: fa_rx_util_pkg.assign_column('A3 ','BS.NAME' ,'BATCH_SOURCE',
1062: 'arrx_rc.var.batch_source' ,'VARCHAR2',50);
1063: /* Bugfix 2842928. Override CRH.ccid with ARD.ccid */
1064: fa_rx_util_pkg.assign_column('400','CC2.CODE_COMBINATION_ID' ,'ACCOUNT_CODE_COMBINATION_ID',
1065: 'arrx_rc.var.account_code_combination_id' ,'NUMBER');
1060: END IF ;
1061: fa_rx_util_pkg.assign_column('A3 ','BS.NAME' ,'BATCH_SOURCE',
1062: 'arrx_rc.var.batch_source' ,'VARCHAR2',50);
1063: /* Bugfix 2842928. Override CRH.ccid with ARD.ccid */
1064: fa_rx_util_pkg.assign_column('400','CC2.CODE_COMBINATION_ID' ,'ACCOUNT_CODE_COMBINATION_ID',
1065: 'arrx_rc.var.account_code_combination_id' ,'NUMBER');
1066: /* Bugfix 2842928. Tax Code should be displayed only for TAX lines. */
1067: fa_rx_util_pkg.assign_column('200','decode(ARD.SOURCE_TYPE,''TAX'', TAX.TAX_CODE, NULL)' ,'TAX_CODE',
1068: 'arrx_rc.var.tax_code' ,'VARCHAR2', 50);
1063: /* Bugfix 2842928. Override CRH.ccid with ARD.ccid */
1064: fa_rx_util_pkg.assign_column('400','CC2.CODE_COMBINATION_ID' ,'ACCOUNT_CODE_COMBINATION_ID',
1065: 'arrx_rc.var.account_code_combination_id' ,'NUMBER');
1066: /* Bugfix 2842928. Tax Code should be displayed only for TAX lines. */
1067: fa_rx_util_pkg.assign_column('200','decode(ARD.SOURCE_TYPE,''TAX'', TAX.TAX_CODE, NULL)' ,'TAX_CODE',
1068: 'arrx_rc.var.tax_code' ,'VARCHAR2', 50);
1069:
1070: fa_rx_util_pkg.debug('Define additional FROM_CLAUSE for Misc Receipts Register');
1071:
1066: /* Bugfix 2842928. Tax Code should be displayed only for TAX lines. */
1067: fa_rx_util_pkg.assign_column('200','decode(ARD.SOURCE_TYPE,''TAX'', TAX.TAX_CODE, NULL)' ,'TAX_CODE',
1068: 'arrx_rc.var.tax_code' ,'VARCHAR2', 50);
1069:
1070: fa_rx_util_pkg.debug('Define additional FROM_CLAUSE for Misc Receipts Register');
1071:
1072: /* Bugfix 2842928. Added GL_CODE_COMBINATIONS CC2, AR_DISTRIBUTIONS ARD */
1073: fa_rx_util_pkg.From_Clause :=
1074: fa_rx_util_pkg.From_Clause ||
1069:
1070: fa_rx_util_pkg.debug('Define additional FROM_CLAUSE for Misc Receipts Register');
1071:
1072: /* Bugfix 2842928. Added GL_CODE_COMBINATIONS CC2, AR_DISTRIBUTIONS ARD */
1073: fa_rx_util_pkg.From_Clause :=
1074: fa_rx_util_pkg.From_Clause ||
1075: ' ,AR_MISC_CASH_DISTRIBUTIONS MCD,
1076: AR_DISTRIBUTIONS ARD,
1077: GL_CODE_COMBINATIONS CC2,
1070: fa_rx_util_pkg.debug('Define additional FROM_CLAUSE for Misc Receipts Register');
1071:
1072: /* Bugfix 2842928. Added GL_CODE_COMBINATIONS CC2, AR_DISTRIBUTIONS ARD */
1073: fa_rx_util_pkg.From_Clause :=
1074: fa_rx_util_pkg.From_Clause ||
1075: ' ,AR_MISC_CASH_DISTRIBUTIONS MCD,
1076: AR_DISTRIBUTIONS ARD,
1077: GL_CODE_COMBINATIONS CC2,
1078: AR_BATCH_SOURCES BS ';
1134:
1135: /*bug 5444415, Changed ARD.SOURCE_ID to ARD.SOURCE_ID(+), ARD.SOURCE_TABLE to ARD.SOURCE_TABLE(+) and
1136: ARD.CODE_COMBINATION_ID to MCD.CODE_COMBINATION_ID */
1137: /*bug 5030073-5039469 Added Co_seg_where*/
1138: fa_rx_util_pkg.Where_Clause :=
1139: fa_rx_util_pkg.Where_Clause ||
1140: ' AND MCD.CASH_RECEIPT_ID = CR.CASH_RECEIPT_ID ' ||
1141: ' AND MCD.MISC_CASH_DISTRIBUTION_ID = ARD.SOURCE_ID(+) AND ARD.SOURCE_TABLE(+) = ''MCD'''||
1142: ' AND ARD.CODE_COMBINATION_ID = CC2.CODE_COMBINATION_ID'||
1135: /*bug 5444415, Changed ARD.SOURCE_ID to ARD.SOURCE_ID(+), ARD.SOURCE_TABLE to ARD.SOURCE_TABLE(+) and
1136: ARD.CODE_COMBINATION_ID to MCD.CODE_COMBINATION_ID */
1137: /*bug 5030073-5039469 Added Co_seg_where*/
1138: fa_rx_util_pkg.Where_Clause :=
1139: fa_rx_util_pkg.Where_Clause ||
1140: ' AND MCD.CASH_RECEIPT_ID = CR.CASH_RECEIPT_ID ' ||
1141: ' AND MCD.MISC_CASH_DISTRIBUTION_ID = ARD.SOURCE_ID(+) AND ARD.SOURCE_TABLE(+) = ''MCD'''||
1142: ' AND ARD.CODE_COMBINATION_ID = CC2.CODE_COMBINATION_ID'||
1143: ' AND NVL(BATCH.BATCH_SOURCE_ID,-1) = BS.BATCH_SOURCE_ID(+) ' ||
1161: MCD_GL_DATE_WHERE || ' ';
1162: END IF;
1163:
1164:
1165: fa_rx_util_pkg.debug('arrx_rc.before_report()-');
1166:
1167: end before_report;
1168:
1169: procedure bind(c in integer)
1184: L_UNIDE varchar2(80);
1185: L_ONACCOUNT VARCHAR2(80);
1186:
1187: begin
1188: fa_rx_util_pkg.debug('Define BIND variables');
1189:
1190: -- Bug 4219081
1191:
1192: if var.calling_program not in ('RECEIPT','APPLIED','MISC','ACTUAL') THEN
1311: dbms_sql.bind_variable(c, 'L_REVERSED' , L_REVERSED);
1312:
1313: if var.calling_program = 'ACTUAL' then
1314:
1315: fa_rx_util_pkg.debug('Define additional BIND variables for Actual Receipts Register');
1316:
1317: select MEANING into L_ACCO from ar_lookups where lookup_type='PAYMENT_TYPE' and lookup_code='ACC';
1318: select MEANING into L_APPL from ar_lookups where lookup_type='PAYMENT_TYPE' and lookup_code='APP';
1319: select MEANING into L_UNAPPL from ar_lookups where lookup_type='PAYMENT_TYPE' and lookup_code='UNAPP';
1326: dbms_sql.bind_variable(c, 'l_trx_on_acc', l_acco);
1327:
1328: elsif var.calling_program = 'APPLIED' then
1329:
1330: fa_rx_util_pkg.debug('Define additional BIND variables for Applied Receipts Register');
1331:
1332: SELECT substrb(meaning,1,20) INTO L_ONACCOUNT FROM ar_lookups WHERE lookup_type='PAYMENT_TYPE' AND lookup_code='ACC';
1333:
1334: dbms_sql.bind_variable(c, 'L_ONACCOUNT' , L_ONACCOUNT);
1361:
1362: procedure after_fetch
1363: is
1364: begin
1365: fa_rx_util_pkg.debug('Get Flexfield value and Description');
1366:
1367: var.functional_currency_code := var.currency_code;
1368: var.organization_name := var.org_name;
1369:
1478: is
1479: l_profile_rsob_id NUMBER := NULL;
1480: l_client_info_rsob_id NUMBER := NULL;
1481: begin
1482: fa_rx_util_pkg.debug('arrx_rc.arrc_rep()+');
1483:
1484: -- initialize all var to null
1485: arrx_rc.init_var;
1486:
1537: mo_global.set_policy_context('S',p_reporting_entity_id);
1538:
1539: end if;
1540:
1541: fa_rx_util_pkg.debug('p_reporting_level = '||var.p_reporting_level);
1542: fa_rx_util_pkg.debug('p_reporting_entity_id = '||var.p_reporting_entity_id);
1543: fa_rx_util_pkg.debug('p_sob_id = '||var.p_sob_id);
1544: fa_rx_util_pkg.debug('p_coa_id = '||var.p_coa_id);
1545: fa_rx_util_pkg.debug('p_co_seg_low = '||var.p_co_seg_low);
1538:
1539: end if;
1540:
1541: fa_rx_util_pkg.debug('p_reporting_level = '||var.p_reporting_level);
1542: fa_rx_util_pkg.debug('p_reporting_entity_id = '||var.p_reporting_entity_id);
1543: fa_rx_util_pkg.debug('p_sob_id = '||var.p_sob_id);
1544: fa_rx_util_pkg.debug('p_coa_id = '||var.p_coa_id);
1545: fa_rx_util_pkg.debug('p_co_seg_low = '||var.p_co_seg_low);
1546: fa_rx_util_pkg.debug('p_co_seg_high = '||var.p_co_seg_high);
1539: end if;
1540:
1541: fa_rx_util_pkg.debug('p_reporting_level = '||var.p_reporting_level);
1542: fa_rx_util_pkg.debug('p_reporting_entity_id = '||var.p_reporting_entity_id);
1543: fa_rx_util_pkg.debug('p_sob_id = '||var.p_sob_id);
1544: fa_rx_util_pkg.debug('p_coa_id = '||var.p_coa_id);
1545: fa_rx_util_pkg.debug('p_co_seg_low = '||var.p_co_seg_low);
1546: fa_rx_util_pkg.debug('p_co_seg_high = '||var.p_co_seg_high);
1547: fa_rx_util_pkg.debug('p_gl_date_from = '||var.p_gl_date_low);
1540:
1541: fa_rx_util_pkg.debug('p_reporting_level = '||var.p_reporting_level);
1542: fa_rx_util_pkg.debug('p_reporting_entity_id = '||var.p_reporting_entity_id);
1543: fa_rx_util_pkg.debug('p_sob_id = '||var.p_sob_id);
1544: fa_rx_util_pkg.debug('p_coa_id = '||var.p_coa_id);
1545: fa_rx_util_pkg.debug('p_co_seg_low = '||var.p_co_seg_low);
1546: fa_rx_util_pkg.debug('p_co_seg_high = '||var.p_co_seg_high);
1547: fa_rx_util_pkg.debug('p_gl_date_from = '||var.p_gl_date_low);
1548: fa_rx_util_pkg.debug('p_gl_date_to = '||var.p_gl_date_high);
1541: fa_rx_util_pkg.debug('p_reporting_level = '||var.p_reporting_level);
1542: fa_rx_util_pkg.debug('p_reporting_entity_id = '||var.p_reporting_entity_id);
1543: fa_rx_util_pkg.debug('p_sob_id = '||var.p_sob_id);
1544: fa_rx_util_pkg.debug('p_coa_id = '||var.p_coa_id);
1545: fa_rx_util_pkg.debug('p_co_seg_low = '||var.p_co_seg_low);
1546: fa_rx_util_pkg.debug('p_co_seg_high = '||var.p_co_seg_high);
1547: fa_rx_util_pkg.debug('p_gl_date_from = '||var.p_gl_date_low);
1548: fa_rx_util_pkg.debug('p_gl_date_to = '||var.p_gl_date_high);
1549: fa_rx_util_pkg.debug('p_entered_currency = '||var.p_currency_code);
1542: fa_rx_util_pkg.debug('p_reporting_entity_id = '||var.p_reporting_entity_id);
1543: fa_rx_util_pkg.debug('p_sob_id = '||var.p_sob_id);
1544: fa_rx_util_pkg.debug('p_coa_id = '||var.p_coa_id);
1545: fa_rx_util_pkg.debug('p_co_seg_low = '||var.p_co_seg_low);
1546: fa_rx_util_pkg.debug('p_co_seg_high = '||var.p_co_seg_high);
1547: fa_rx_util_pkg.debug('p_gl_date_from = '||var.p_gl_date_low);
1548: fa_rx_util_pkg.debug('p_gl_date_to = '||var.p_gl_date_high);
1549: fa_rx_util_pkg.debug('p_entered_currency = '||var.p_currency_code);
1550: fa_rx_util_pkg.debug('p_batch_name_low = '||var.p_batch_name_low);
1543: fa_rx_util_pkg.debug('p_sob_id = '||var.p_sob_id);
1544: fa_rx_util_pkg.debug('p_coa_id = '||var.p_coa_id);
1545: fa_rx_util_pkg.debug('p_co_seg_low = '||var.p_co_seg_low);
1546: fa_rx_util_pkg.debug('p_co_seg_high = '||var.p_co_seg_high);
1547: fa_rx_util_pkg.debug('p_gl_date_from = '||var.p_gl_date_low);
1548: fa_rx_util_pkg.debug('p_gl_date_to = '||var.p_gl_date_high);
1549: fa_rx_util_pkg.debug('p_entered_currency = '||var.p_currency_code);
1550: fa_rx_util_pkg.debug('p_batch_name_low = '||var.p_batch_name_low);
1551: fa_rx_util_pkg.debug('p_batch_name_high = '||var.p_batch_name_high);
1544: fa_rx_util_pkg.debug('p_coa_id = '||var.p_coa_id);
1545: fa_rx_util_pkg.debug('p_co_seg_low = '||var.p_co_seg_low);
1546: fa_rx_util_pkg.debug('p_co_seg_high = '||var.p_co_seg_high);
1547: fa_rx_util_pkg.debug('p_gl_date_from = '||var.p_gl_date_low);
1548: fa_rx_util_pkg.debug('p_gl_date_to = '||var.p_gl_date_high);
1549: fa_rx_util_pkg.debug('p_entered_currency = '||var.p_currency_code);
1550: fa_rx_util_pkg.debug('p_batch_name_low = '||var.p_batch_name_low);
1551: fa_rx_util_pkg.debug('p_batch_name_high = '||var.p_batch_name_high);
1552: fa_rx_util_pkg.debug('p_customer_name_low = '||var.p_customer_name_low);
1545: fa_rx_util_pkg.debug('p_co_seg_low = '||var.p_co_seg_low);
1546: fa_rx_util_pkg.debug('p_co_seg_high = '||var.p_co_seg_high);
1547: fa_rx_util_pkg.debug('p_gl_date_from = '||var.p_gl_date_low);
1548: fa_rx_util_pkg.debug('p_gl_date_to = '||var.p_gl_date_high);
1549: fa_rx_util_pkg.debug('p_entered_currency = '||var.p_currency_code);
1550: fa_rx_util_pkg.debug('p_batch_name_low = '||var.p_batch_name_low);
1551: fa_rx_util_pkg.debug('p_batch_name_high = '||var.p_batch_name_high);
1552: fa_rx_util_pkg.debug('p_customer_name_low = '||var.p_customer_name_low);
1553: fa_rx_util_pkg.debug('p_customer_name_high = '||var.p_customer_name_high);
1546: fa_rx_util_pkg.debug('p_co_seg_high = '||var.p_co_seg_high);
1547: fa_rx_util_pkg.debug('p_gl_date_from = '||var.p_gl_date_low);
1548: fa_rx_util_pkg.debug('p_gl_date_to = '||var.p_gl_date_high);
1549: fa_rx_util_pkg.debug('p_entered_currency = '||var.p_currency_code);
1550: fa_rx_util_pkg.debug('p_batch_name_low = '||var.p_batch_name_low);
1551: fa_rx_util_pkg.debug('p_batch_name_high = '||var.p_batch_name_high);
1552: fa_rx_util_pkg.debug('p_customer_name_low = '||var.p_customer_name_low);
1553: fa_rx_util_pkg.debug('p_customer_name_high = '||var.p_customer_name_high);
1554: fa_rx_util_pkg.debug('p_deposit_date_low = '||var.p_deposit_date_low);
1547: fa_rx_util_pkg.debug('p_gl_date_from = '||var.p_gl_date_low);
1548: fa_rx_util_pkg.debug('p_gl_date_to = '||var.p_gl_date_high);
1549: fa_rx_util_pkg.debug('p_entered_currency = '||var.p_currency_code);
1550: fa_rx_util_pkg.debug('p_batch_name_low = '||var.p_batch_name_low);
1551: fa_rx_util_pkg.debug('p_batch_name_high = '||var.p_batch_name_high);
1552: fa_rx_util_pkg.debug('p_customer_name_low = '||var.p_customer_name_low);
1553: fa_rx_util_pkg.debug('p_customer_name_high = '||var.p_customer_name_high);
1554: fa_rx_util_pkg.debug('p_deposit_date_low = '||var.p_deposit_date_low);
1555: fa_rx_util_pkg.debug('p_deposit_date_high = '||var.p_deposit_date_high);
1548: fa_rx_util_pkg.debug('p_gl_date_to = '||var.p_gl_date_high);
1549: fa_rx_util_pkg.debug('p_entered_currency = '||var.p_currency_code);
1550: fa_rx_util_pkg.debug('p_batch_name_low = '||var.p_batch_name_low);
1551: fa_rx_util_pkg.debug('p_batch_name_high = '||var.p_batch_name_high);
1552: fa_rx_util_pkg.debug('p_customer_name_low = '||var.p_customer_name_low);
1553: fa_rx_util_pkg.debug('p_customer_name_high = '||var.p_customer_name_high);
1554: fa_rx_util_pkg.debug('p_deposit_date_low = '||var.p_deposit_date_low);
1555: fa_rx_util_pkg.debug('p_deposit_date_high = '||var.p_deposit_date_high);
1556: fa_rx_util_pkg.debug('p_receipt_status_low = '||var.p_receipt_status_low);
1549: fa_rx_util_pkg.debug('p_entered_currency = '||var.p_currency_code);
1550: fa_rx_util_pkg.debug('p_batch_name_low = '||var.p_batch_name_low);
1551: fa_rx_util_pkg.debug('p_batch_name_high = '||var.p_batch_name_high);
1552: fa_rx_util_pkg.debug('p_customer_name_low = '||var.p_customer_name_low);
1553: fa_rx_util_pkg.debug('p_customer_name_high = '||var.p_customer_name_high);
1554: fa_rx_util_pkg.debug('p_deposit_date_low = '||var.p_deposit_date_low);
1555: fa_rx_util_pkg.debug('p_deposit_date_high = '||var.p_deposit_date_high);
1556: fa_rx_util_pkg.debug('p_receipt_status_low = '||var.p_receipt_status_low);
1557: fa_rx_util_pkg.debug('p_receipt_status_high = '||var.p_receipt_status_high);
1550: fa_rx_util_pkg.debug('p_batch_name_low = '||var.p_batch_name_low);
1551: fa_rx_util_pkg.debug('p_batch_name_high = '||var.p_batch_name_high);
1552: fa_rx_util_pkg.debug('p_customer_name_low = '||var.p_customer_name_low);
1553: fa_rx_util_pkg.debug('p_customer_name_high = '||var.p_customer_name_high);
1554: fa_rx_util_pkg.debug('p_deposit_date_low = '||var.p_deposit_date_low);
1555: fa_rx_util_pkg.debug('p_deposit_date_high = '||var.p_deposit_date_high);
1556: fa_rx_util_pkg.debug('p_receipt_status_low = '||var.p_receipt_status_low);
1557: fa_rx_util_pkg.debug('p_receipt_status_high = '||var.p_receipt_status_high);
1558: fa_rx_util_pkg.debug('p_receipt_number_low = '||var.p_receipt_number_low);
1551: fa_rx_util_pkg.debug('p_batch_name_high = '||var.p_batch_name_high);
1552: fa_rx_util_pkg.debug('p_customer_name_low = '||var.p_customer_name_low);
1553: fa_rx_util_pkg.debug('p_customer_name_high = '||var.p_customer_name_high);
1554: fa_rx_util_pkg.debug('p_deposit_date_low = '||var.p_deposit_date_low);
1555: fa_rx_util_pkg.debug('p_deposit_date_high = '||var.p_deposit_date_high);
1556: fa_rx_util_pkg.debug('p_receipt_status_low = '||var.p_receipt_status_low);
1557: fa_rx_util_pkg.debug('p_receipt_status_high = '||var.p_receipt_status_high);
1558: fa_rx_util_pkg.debug('p_receipt_number_low = '||var.p_receipt_number_low);
1559: fa_rx_util_pkg.debug('p_receipt_number_high = '||var.p_receipt_number_high);
1552: fa_rx_util_pkg.debug('p_customer_name_low = '||var.p_customer_name_low);
1553: fa_rx_util_pkg.debug('p_customer_name_high = '||var.p_customer_name_high);
1554: fa_rx_util_pkg.debug('p_deposit_date_low = '||var.p_deposit_date_low);
1555: fa_rx_util_pkg.debug('p_deposit_date_high = '||var.p_deposit_date_high);
1556: fa_rx_util_pkg.debug('p_receipt_status_low = '||var.p_receipt_status_low);
1557: fa_rx_util_pkg.debug('p_receipt_status_high = '||var.p_receipt_status_high);
1558: fa_rx_util_pkg.debug('p_receipt_number_low = '||var.p_receipt_number_low);
1559: fa_rx_util_pkg.debug('p_receipt_number_high = '||var.p_receipt_number_high);
1560: fa_rx_util_pkg.debug('p_invoice_number_low = '||var.p_invoice_number_low);
1553: fa_rx_util_pkg.debug('p_customer_name_high = '||var.p_customer_name_high);
1554: fa_rx_util_pkg.debug('p_deposit_date_low = '||var.p_deposit_date_low);
1555: fa_rx_util_pkg.debug('p_deposit_date_high = '||var.p_deposit_date_high);
1556: fa_rx_util_pkg.debug('p_receipt_status_low = '||var.p_receipt_status_low);
1557: fa_rx_util_pkg.debug('p_receipt_status_high = '||var.p_receipt_status_high);
1558: fa_rx_util_pkg.debug('p_receipt_number_low = '||var.p_receipt_number_low);
1559: fa_rx_util_pkg.debug('p_receipt_number_high = '||var.p_receipt_number_high);
1560: fa_rx_util_pkg.debug('p_invoice_number_low = '||var.p_invoice_number_low);
1561: fa_rx_util_pkg.debug('p_invoice_number_high = '||var.p_invoice_number_high);
1554: fa_rx_util_pkg.debug('p_deposit_date_low = '||var.p_deposit_date_low);
1555: fa_rx_util_pkg.debug('p_deposit_date_high = '||var.p_deposit_date_high);
1556: fa_rx_util_pkg.debug('p_receipt_status_low = '||var.p_receipt_status_low);
1557: fa_rx_util_pkg.debug('p_receipt_status_high = '||var.p_receipt_status_high);
1558: fa_rx_util_pkg.debug('p_receipt_number_low = '||var.p_receipt_number_low);
1559: fa_rx_util_pkg.debug('p_receipt_number_high = '||var.p_receipt_number_high);
1560: fa_rx_util_pkg.debug('p_invoice_number_low = '||var.p_invoice_number_low);
1561: fa_rx_util_pkg.debug('p_invoice_number_high = '||var.p_invoice_number_high);
1562: fa_rx_util_pkg.debug('p_receipt_date_low = '||var.p_receipt_date_low);
1555: fa_rx_util_pkg.debug('p_deposit_date_high = '||var.p_deposit_date_high);
1556: fa_rx_util_pkg.debug('p_receipt_status_low = '||var.p_receipt_status_low);
1557: fa_rx_util_pkg.debug('p_receipt_status_high = '||var.p_receipt_status_high);
1558: fa_rx_util_pkg.debug('p_receipt_number_low = '||var.p_receipt_number_low);
1559: fa_rx_util_pkg.debug('p_receipt_number_high = '||var.p_receipt_number_high);
1560: fa_rx_util_pkg.debug('p_invoice_number_low = '||var.p_invoice_number_low);
1561: fa_rx_util_pkg.debug('p_invoice_number_high = '||var.p_invoice_number_high);
1562: fa_rx_util_pkg.debug('p_receipt_date_low = '||var.p_receipt_date_low);
1563: fa_rx_util_pkg.debug('p_receipt_date_high = '||var.p_receipt_date_high);
1556: fa_rx_util_pkg.debug('p_receipt_status_low = '||var.p_receipt_status_low);
1557: fa_rx_util_pkg.debug('p_receipt_status_high = '||var.p_receipt_status_high);
1558: fa_rx_util_pkg.debug('p_receipt_number_low = '||var.p_receipt_number_low);
1559: fa_rx_util_pkg.debug('p_receipt_number_high = '||var.p_receipt_number_high);
1560: fa_rx_util_pkg.debug('p_invoice_number_low = '||var.p_invoice_number_low);
1561: fa_rx_util_pkg.debug('p_invoice_number_high = '||var.p_invoice_number_high);
1562: fa_rx_util_pkg.debug('p_receipt_date_low = '||var.p_receipt_date_low);
1563: fa_rx_util_pkg.debug('p_receipt_date_high = '||var.p_receipt_date_high);
1564: fa_rx_util_pkg.debug('p_bank_account_name = '||var.p_bank_account_name);
1557: fa_rx_util_pkg.debug('p_receipt_status_high = '||var.p_receipt_status_high);
1558: fa_rx_util_pkg.debug('p_receipt_number_low = '||var.p_receipt_number_low);
1559: fa_rx_util_pkg.debug('p_receipt_number_high = '||var.p_receipt_number_high);
1560: fa_rx_util_pkg.debug('p_invoice_number_low = '||var.p_invoice_number_low);
1561: fa_rx_util_pkg.debug('p_invoice_number_high = '||var.p_invoice_number_high);
1562: fa_rx_util_pkg.debug('p_receipt_date_low = '||var.p_receipt_date_low);
1563: fa_rx_util_pkg.debug('p_receipt_date_high = '||var.p_receipt_date_high);
1564: fa_rx_util_pkg.debug('p_bank_account_name = '||var.p_bank_account_name);
1565: fa_rx_util_pkg.debug('p_payment_method = '||var.p_payment_method);
1558: fa_rx_util_pkg.debug('p_receipt_number_low = '||var.p_receipt_number_low);
1559: fa_rx_util_pkg.debug('p_receipt_number_high = '||var.p_receipt_number_high);
1560: fa_rx_util_pkg.debug('p_invoice_number_low = '||var.p_invoice_number_low);
1561: fa_rx_util_pkg.debug('p_invoice_number_high = '||var.p_invoice_number_high);
1562: fa_rx_util_pkg.debug('p_receipt_date_low = '||var.p_receipt_date_low);
1563: fa_rx_util_pkg.debug('p_receipt_date_high = '||var.p_receipt_date_high);
1564: fa_rx_util_pkg.debug('p_bank_account_name = '||var.p_bank_account_name);
1565: fa_rx_util_pkg.debug('p_payment_method = '||var.p_payment_method);
1566: fa_rx_util_pkg.debug('p_confirmed_flag = '||var.p_confirmed_flag);
1559: fa_rx_util_pkg.debug('p_receipt_number_high = '||var.p_receipt_number_high);
1560: fa_rx_util_pkg.debug('p_invoice_number_low = '||var.p_invoice_number_low);
1561: fa_rx_util_pkg.debug('p_invoice_number_high = '||var.p_invoice_number_high);
1562: fa_rx_util_pkg.debug('p_receipt_date_low = '||var.p_receipt_date_low);
1563: fa_rx_util_pkg.debug('p_receipt_date_high = '||var.p_receipt_date_high);
1564: fa_rx_util_pkg.debug('p_bank_account_name = '||var.p_bank_account_name);
1565: fa_rx_util_pkg.debug('p_payment_method = '||var.p_payment_method);
1566: fa_rx_util_pkg.debug('p_confirmed_flag = '||var.p_confirmed_flag);
1567: fa_rx_util_pkg.debug('p_doc_sequence_name = '||var.p_doc_sequence_name);
1560: fa_rx_util_pkg.debug('p_invoice_number_low = '||var.p_invoice_number_low);
1561: fa_rx_util_pkg.debug('p_invoice_number_high = '||var.p_invoice_number_high);
1562: fa_rx_util_pkg.debug('p_receipt_date_low = '||var.p_receipt_date_low);
1563: fa_rx_util_pkg.debug('p_receipt_date_high = '||var.p_receipt_date_high);
1564: fa_rx_util_pkg.debug('p_bank_account_name = '||var.p_bank_account_name);
1565: fa_rx_util_pkg.debug('p_payment_method = '||var.p_payment_method);
1566: fa_rx_util_pkg.debug('p_confirmed_flag = '||var.p_confirmed_flag);
1567: fa_rx_util_pkg.debug('p_doc_sequence_name = '||var.p_doc_sequence_name);
1568: fa_rx_util_pkg.debug('p_doc_sequence_number_from = '||var.p_doc_sequence_number_from);
1561: fa_rx_util_pkg.debug('p_invoice_number_high = '||var.p_invoice_number_high);
1562: fa_rx_util_pkg.debug('p_receipt_date_low = '||var.p_receipt_date_low);
1563: fa_rx_util_pkg.debug('p_receipt_date_high = '||var.p_receipt_date_high);
1564: fa_rx_util_pkg.debug('p_bank_account_name = '||var.p_bank_account_name);
1565: fa_rx_util_pkg.debug('p_payment_method = '||var.p_payment_method);
1566: fa_rx_util_pkg.debug('p_confirmed_flag = '||var.p_confirmed_flag);
1567: fa_rx_util_pkg.debug('p_doc_sequence_name = '||var.p_doc_sequence_name);
1568: fa_rx_util_pkg.debug('p_doc_sequence_number_from = '||var.p_doc_sequence_number_from);
1569: fa_rx_util_pkg.debug('p_doc_sequence_number_to = '||var.p_doc_sequence_number_to);
1562: fa_rx_util_pkg.debug('p_receipt_date_low = '||var.p_receipt_date_low);
1563: fa_rx_util_pkg.debug('p_receipt_date_high = '||var.p_receipt_date_high);
1564: fa_rx_util_pkg.debug('p_bank_account_name = '||var.p_bank_account_name);
1565: fa_rx_util_pkg.debug('p_payment_method = '||var.p_payment_method);
1566: fa_rx_util_pkg.debug('p_confirmed_flag = '||var.p_confirmed_flag);
1567: fa_rx_util_pkg.debug('p_doc_sequence_name = '||var.p_doc_sequence_name);
1568: fa_rx_util_pkg.debug('p_doc_sequence_number_from = '||var.p_doc_sequence_number_from);
1569: fa_rx_util_pkg.debug('p_doc_sequence_number_to = '||var.p_doc_sequence_number_to);
1570: fa_rx_util_pkg.debug('request_id = '||var.request_id);
1563: fa_rx_util_pkg.debug('p_receipt_date_high = '||var.p_receipt_date_high);
1564: fa_rx_util_pkg.debug('p_bank_account_name = '||var.p_bank_account_name);
1565: fa_rx_util_pkg.debug('p_payment_method = '||var.p_payment_method);
1566: fa_rx_util_pkg.debug('p_confirmed_flag = '||var.p_confirmed_flag);
1567: fa_rx_util_pkg.debug('p_doc_sequence_name = '||var.p_doc_sequence_name);
1568: fa_rx_util_pkg.debug('p_doc_sequence_number_from = '||var.p_doc_sequence_number_from);
1569: fa_rx_util_pkg.debug('p_doc_sequence_number_to = '||var.p_doc_sequence_number_to);
1570: fa_rx_util_pkg.debug('request_id = '||var.request_id);
1571:
1564: fa_rx_util_pkg.debug('p_bank_account_name = '||var.p_bank_account_name);
1565: fa_rx_util_pkg.debug('p_payment_method = '||var.p_payment_method);
1566: fa_rx_util_pkg.debug('p_confirmed_flag = '||var.p_confirmed_flag);
1567: fa_rx_util_pkg.debug('p_doc_sequence_name = '||var.p_doc_sequence_name);
1568: fa_rx_util_pkg.debug('p_doc_sequence_number_from = '||var.p_doc_sequence_number_from);
1569: fa_rx_util_pkg.debug('p_doc_sequence_number_to = '||var.p_doc_sequence_number_to);
1570: fa_rx_util_pkg.debug('request_id = '||var.request_id);
1571:
1572: /* Set the appropriate sob type into the global variable var.ca_sob_type */
1565: fa_rx_util_pkg.debug('p_payment_method = '||var.p_payment_method);
1566: fa_rx_util_pkg.debug('p_confirmed_flag = '||var.p_confirmed_flag);
1567: fa_rx_util_pkg.debug('p_doc_sequence_name = '||var.p_doc_sequence_name);
1568: fa_rx_util_pkg.debug('p_doc_sequence_number_from = '||var.p_doc_sequence_number_from);
1569: fa_rx_util_pkg.debug('p_doc_sequence_number_to = '||var.p_doc_sequence_number_to);
1570: fa_rx_util_pkg.debug('request_id = '||var.request_id);
1571:
1572: /* Set the appropriate sob type into the global variable var.ca_sob_type */
1573: select to_number(nvl(replace(substr(userenv('CLIENT_INFO'),45,10),' '),-99))
1566: fa_rx_util_pkg.debug('p_confirmed_flag = '||var.p_confirmed_flag);
1567: fa_rx_util_pkg.debug('p_doc_sequence_name = '||var.p_doc_sequence_name);
1568: fa_rx_util_pkg.debug('p_doc_sequence_number_from = '||var.p_doc_sequence_number_from);
1569: fa_rx_util_pkg.debug('p_doc_sequence_number_to = '||var.p_doc_sequence_number_to);
1570: fa_rx_util_pkg.debug('request_id = '||var.request_id);
1571:
1572: /* Set the appropriate sob type into the global variable var.ca_sob_type */
1573: select to_number(nvl(replace(substr(userenv('CLIENT_INFO'),45,10),' '),-99))
1574: into l_client_info_rsob_id
1577: fnd_profile.get('MRC_REPORTING_SOB_ID', l_profile_rsob_id);
1578: IF (l_client_info_rsob_id = NVL(l_profile_rsob_id,-1)) OR
1579: (l_client_info_rsob_id = -99)
1580: THEN
1581: fa_rx_util_pkg.debug('Setting the sob type to P');
1582: var.ca_sob_type := 'P';
1583: ELSE
1584: fa_rx_util_pkg.debug('Setting the sob type to R');
1585: var.ca_sob_id := l_client_info_rsob_id;
1580: THEN
1581: fa_rx_util_pkg.debug('Setting the sob type to P');
1582: var.ca_sob_type := 'P';
1583: ELSE
1584: fa_rx_util_pkg.debug('Setting the sob type to R');
1585: var.ca_sob_id := l_client_info_rsob_id;
1586: var.ca_sob_type := 'R';
1587: END IF;
1588: --
1586: var.ca_sob_type := 'R';
1587: END IF;
1588: --
1589: -- Initialize request
1590: fa_rx_util_pkg.debug('Initializing the request');
1591: fa_rx_util_pkg.init_request('arrx_rc.arrc_rep',request_id,'AR_RECEIPTS_REP_ITF');
1592:
1593: fa_rx_util_pkg.assign_report('AR RECEIPTS',
1594: true,
1587: END IF;
1588: --
1589: -- Initialize request
1590: fa_rx_util_pkg.debug('Initializing the request');
1591: fa_rx_util_pkg.init_request('arrx_rc.arrc_rep',request_id,'AR_RECEIPTS_REP_ITF');
1592:
1593: fa_rx_util_pkg.assign_report('AR RECEIPTS',
1594: true,
1595: 'arrx_rc.before_report;',
1589: -- Initialize request
1590: fa_rx_util_pkg.debug('Initializing the request');
1591: fa_rx_util_pkg.init_request('arrx_rc.arrc_rep',request_id,'AR_RECEIPTS_REP_ITF');
1592:
1593: fa_rx_util_pkg.assign_report('AR RECEIPTS',
1594: true,
1595: 'arrx_rc.before_report;',
1596: 'arrx_rc.bind(:CURSOR_SELECT);',
1597: 'arrx_rc.after_fetch;',
1599:
1600: --
1601: -- Run the report.
1602: -- Make sure to pass the p_calling_proc assigned from within this procedure ('arrx_rc.arrc_rep')
1603: fa_rx_util_pkg.run_report('arrx_rc.arrc_rep', retcode, errbuf);
1604:
1605: fa_rx_util_pkg.debug('arrx_rc.arrc_rep()-');
1606:
1607: exception
1601: -- Run the report.
1602: -- Make sure to pass the p_calling_proc assigned from within this procedure ('arrx_rc.arrc_rep')
1603: fa_rx_util_pkg.run_report('arrx_rc.arrc_rep', retcode, errbuf);
1604:
1605: fa_rx_util_pkg.debug('arrx_rc.arrc_rep()-');
1606:
1607: exception
1608: when others then
1609: fa_rx_util_pkg.log(sqlcode);
1605: fa_rx_util_pkg.debug('arrx_rc.arrc_rep()-');
1606:
1607: exception
1608: when others then
1609: fa_rx_util_pkg.log(sqlcode);
1610: fa_rx_util_pkg.log(sqlerrm);
1611: fa_rx_util_pkg.debug(sqlcode);
1612: fa_rx_util_pkg.debug(sqlerrm);
1613: fa_rx_util_pkg.debug('arrx_rc.arrc_rep(EXCEPTION)-');
1606:
1607: exception
1608: when others then
1609: fa_rx_util_pkg.log(sqlcode);
1610: fa_rx_util_pkg.log(sqlerrm);
1611: fa_rx_util_pkg.debug(sqlcode);
1612: fa_rx_util_pkg.debug(sqlerrm);
1613: fa_rx_util_pkg.debug('arrx_rc.arrc_rep(EXCEPTION)-');
1614: end arrc_rep;
1607: exception
1608: when others then
1609: fa_rx_util_pkg.log(sqlcode);
1610: fa_rx_util_pkg.log(sqlerrm);
1611: fa_rx_util_pkg.debug(sqlcode);
1612: fa_rx_util_pkg.debug(sqlerrm);
1613: fa_rx_util_pkg.debug('arrx_rc.arrc_rep(EXCEPTION)-');
1614: end arrc_rep;
1615:
1608: when others then
1609: fa_rx_util_pkg.log(sqlcode);
1610: fa_rx_util_pkg.log(sqlerrm);
1611: fa_rx_util_pkg.debug(sqlcode);
1612: fa_rx_util_pkg.debug(sqlerrm);
1613: fa_rx_util_pkg.debug('arrx_rc.arrc_rep(EXCEPTION)-');
1614: end arrc_rep;
1615:
1616: ------------------
1609: fa_rx_util_pkg.log(sqlcode);
1610: fa_rx_util_pkg.log(sqlerrm);
1611: fa_rx_util_pkg.debug(sqlcode);
1612: fa_rx_util_pkg.debug(sqlerrm);
1613: fa_rx_util_pkg.debug('arrx_rc.arrc_rep(EXCEPTION)-');
1614: end arrc_rep;
1615:
1616: ------------------
1617: -- Actual Register
1645: is
1646: l_profile_rsob_id NUMBER := NULL;
1647: l_client_info_rsob_id NUMBER := NULL;
1648: begin
1649: fa_rx_util_pkg.debug('arrx_rc.arrc_rep_actual()+');
1650:
1651: -- initialize all var to null
1652: arrx_rc.init_var;
1653:
1701: fnd_profile.get('MRC_REPORTING_SOB_ID', l_profile_rsob_id);
1702: IF (l_client_info_rsob_id = NVL(l_profile_rsob_id,-1)) OR
1703: (l_client_info_rsob_id = -99)
1704: THEN
1705: fa_rx_util_pkg.debug('Setting the sob type to P');
1706: fa_rx_util_pkg.debug(l_client_info_rsob_id);
1707: var.ca_sob_type := 'P';
1708: ELSE
1709: fa_rx_util_pkg.debug('Setting the sob type to R');
1702: IF (l_client_info_rsob_id = NVL(l_profile_rsob_id,-1)) OR
1703: (l_client_info_rsob_id = -99)
1704: THEN
1705: fa_rx_util_pkg.debug('Setting the sob type to P');
1706: fa_rx_util_pkg.debug(l_client_info_rsob_id);
1707: var.ca_sob_type := 'P';
1708: ELSE
1709: fa_rx_util_pkg.debug('Setting the sob type to R');
1710: var.ca_sob_id := l_client_info_rsob_id;
1705: fa_rx_util_pkg.debug('Setting the sob type to P');
1706: fa_rx_util_pkg.debug(l_client_info_rsob_id);
1707: var.ca_sob_type := 'P';
1708: ELSE
1709: fa_rx_util_pkg.debug('Setting the sob type to R');
1710: var.ca_sob_id := l_client_info_rsob_id;
1711: var.ca_sob_type := 'R';
1712: END IF;
1713:
1711: var.ca_sob_type := 'R';
1712: END IF;
1713:
1714: -- Initialize request
1715: fa_rx_util_pkg.init_request('arrx_rc.arrc_rep_actual',request_id,'AR_RECEIPTS_REP_ITF');
1716:
1717: --
1718: -- Assign triggers specific to this report
1719: -- Make sure that you make your assignment to the correct section ('AR RECEIPTS')
1716:
1717: --
1718: -- Assign triggers specific to this report
1719: -- Make sure that you make your assignment to the correct section ('AR RECEIPTS')
1720: fa_rx_util_pkg.assign_report('AR RECEIPTS',
1721: true,
1722: 'arrx_rc.before_report;',
1723: 'arrx_rc.bind(:CURSOR_SELECT);',
1724: 'arrx_rc.after_fetch;',
1726:
1727: --
1728: -- Run the report.
1729: -- Make sure to pass the p_calling_proc assigned from within this procedure ('arrx_rc.arrc_rep_actual')
1730: fa_rx_util_pkg.run_report('arrx_rc.arrc_rep_actual', retcode, errbuf);
1731:
1732: fa_rx_util_pkg.debug('arrx_rc.arrc_rep_actual()-');
1733:
1734: exception
1728: -- Run the report.
1729: -- Make sure to pass the p_calling_proc assigned from within this procedure ('arrx_rc.arrc_rep_actual')
1730: fa_rx_util_pkg.run_report('arrx_rc.arrc_rep_actual', retcode, errbuf);
1731:
1732: fa_rx_util_pkg.debug('arrx_rc.arrc_rep_actual()-');
1733:
1734: exception
1735: when others then
1736: fa_rx_util_pkg.log(sqlcode);
1732: fa_rx_util_pkg.debug('arrx_rc.arrc_rep_actual()-');
1733:
1734: exception
1735: when others then
1736: fa_rx_util_pkg.log(sqlcode);
1737: fa_rx_util_pkg.log(sqlerrm);
1738: fa_rx_util_pkg.debug(sqlcode);
1739: fa_rx_util_pkg.debug(sqlerrm);
1740: fa_rx_util_pkg.debug('arrx_rc.arrc_rep_actual(EXCEPTION)-');
1733:
1734: exception
1735: when others then
1736: fa_rx_util_pkg.log(sqlcode);
1737: fa_rx_util_pkg.log(sqlerrm);
1738: fa_rx_util_pkg.debug(sqlcode);
1739: fa_rx_util_pkg.debug(sqlerrm);
1740: fa_rx_util_pkg.debug('arrx_rc.arrc_rep_actual(EXCEPTION)-');
1741: end arrc_rep_actual;
1734: exception
1735: when others then
1736: fa_rx_util_pkg.log(sqlcode);
1737: fa_rx_util_pkg.log(sqlerrm);
1738: fa_rx_util_pkg.debug(sqlcode);
1739: fa_rx_util_pkg.debug(sqlerrm);
1740: fa_rx_util_pkg.debug('arrx_rc.arrc_rep_actual(EXCEPTION)-');
1741: end arrc_rep_actual;
1742:
1735: when others then
1736: fa_rx_util_pkg.log(sqlcode);
1737: fa_rx_util_pkg.log(sqlerrm);
1738: fa_rx_util_pkg.debug(sqlcode);
1739: fa_rx_util_pkg.debug(sqlerrm);
1740: fa_rx_util_pkg.debug('arrx_rc.arrc_rep_actual(EXCEPTION)-');
1741: end arrc_rep_actual;
1742:
1743: -------------------
1736: fa_rx_util_pkg.log(sqlcode);
1737: fa_rx_util_pkg.log(sqlerrm);
1738: fa_rx_util_pkg.debug(sqlcode);
1739: fa_rx_util_pkg.debug(sqlerrm);
1740: fa_rx_util_pkg.debug('arrx_rc.arrc_rep_actual(EXCEPTION)-');
1741: end arrc_rep_actual;
1742:
1743: -------------------
1744: -- Applied Register
1776:
1777:
1778: begin
1779:
1780: fa_rx_util_pkg.debug('arrx_rc.arar_rep()+');
1781:
1782: -- initialize all var to null
1783: arrx_rc.init_var;
1784:
1846: END IF;
1847:
1848: --
1849: -- Initialize request
1850: fa_rx_util_pkg.init_request('arrx_rc.arar_rep',request_id,'AR_RECEIPTS_REP_ITF');
1851:
1852: -- Assign triggers specific to this report
1853: -- Make sure that you make your assignment to the correct section ('AR RECEIPTS')
1854:
1851:
1852: -- Assign triggers specific to this report
1853: -- Make sure that you make your assignment to the correct section ('AR RECEIPTS')
1854:
1855: fa_rx_util_pkg.assign_report('AR RECEIPTS',
1856: true,
1857: 'arrx_rc.before_report;',
1858: 'arrx_rc.bind(:CURSOR_SELECT);',
1859: 'arrx_rc.after_fetch;',
1860: null);
1861: --
1862: -- Run the report.
1863: -- Make sure to pass the p_calling_proc assigned from within this procedure
1864: fa_rx_util_pkg.run_report('arrx_rc.arar_rep', retcode, errbuf);
1865:
1866: fa_rx_util_pkg.debug('arrx_rc.arar_rep()-');
1867: exception
1868: when others then
1862: -- Run the report.
1863: -- Make sure to pass the p_calling_proc assigned from within this procedure
1864: fa_rx_util_pkg.run_report('arrx_rc.arar_rep', retcode, errbuf);
1865:
1866: fa_rx_util_pkg.debug('arrx_rc.arar_rep()-');
1867: exception
1868: when others then
1869: fa_rx_util_pkg.log(sqlcode);
1870: fa_rx_util_pkg.log(sqlerrm);
1865:
1866: fa_rx_util_pkg.debug('arrx_rc.arar_rep()-');
1867: exception
1868: when others then
1869: fa_rx_util_pkg.log(sqlcode);
1870: fa_rx_util_pkg.log(sqlerrm);
1871: fa_rx_util_pkg.debug(sqlcode);
1872: fa_rx_util_pkg.debug(sqlerrm);
1873: end arar_rep;
1866: fa_rx_util_pkg.debug('arrx_rc.arar_rep()-');
1867: exception
1868: when others then
1869: fa_rx_util_pkg.log(sqlcode);
1870: fa_rx_util_pkg.log(sqlerrm);
1871: fa_rx_util_pkg.debug(sqlcode);
1872: fa_rx_util_pkg.debug(sqlerrm);
1873: end arar_rep;
1874:
1867: exception
1868: when others then
1869: fa_rx_util_pkg.log(sqlcode);
1870: fa_rx_util_pkg.log(sqlerrm);
1871: fa_rx_util_pkg.debug(sqlcode);
1872: fa_rx_util_pkg.debug(sqlerrm);
1873: end arar_rep;
1874:
1875: -----------------------------------
1868: when others then
1869: fa_rx_util_pkg.log(sqlcode);
1870: fa_rx_util_pkg.log(sqlerrm);
1871: fa_rx_util_pkg.debug(sqlcode);
1872: fa_rx_util_pkg.debug(sqlerrm);
1873: end arar_rep;
1874:
1875: -----------------------------------
1876: -- Miscellaneous Receipts Register
1899: errbuf out NOCOPY varchar2)
1900: is
1901: begin
1902:
1903: fa_rx_util_pkg.debug('arrx_rc.arar_rep()+');
1904:
1905: -- initialize all var to null
1906: arrx_rc.init_var;
1907: --
1953: var.ca_sob_type := 'P';
1954:
1955: --
1956: -- Initialize request
1957: fa_rx_util_pkg.init_request('arrx_rc.armtr_rep',request_id,'AR_RECEIPTS_REP_ITF');
1958:
1959: fa_rx_util_pkg.assign_report('AR RECEIPTS',
1960: true,
1961: 'arrx_rc.before_report;',
1955: --
1956: -- Initialize request
1957: fa_rx_util_pkg.init_request('arrx_rc.armtr_rep',request_id,'AR_RECEIPTS_REP_ITF');
1958:
1959: fa_rx_util_pkg.assign_report('AR RECEIPTS',
1960: true,
1961: 'arrx_rc.before_report;',
1962: 'arrx_rc.bind(:CURSOR_SELECT);',
1963: 'arrx_rc.after_fetch;',
1964: null);
1965: --
1966: -- Run the report.
1967: -- Make sure to pass the p_calling_proc assigned from within this procedure
1968: fa_rx_util_pkg.run_report('arrx_rc.armtr_rep', retcode, errbuf);
1969:
1970: exception
1971: when others then
1972: fa_rx_util_pkg.log(sqlcode);
1968: fa_rx_util_pkg.run_report('arrx_rc.armtr_rep', retcode, errbuf);
1969:
1970: exception
1971: when others then
1972: fa_rx_util_pkg.log(sqlcode);
1973: fa_rx_util_pkg.log(sqlerrm);
1974: fa_rx_util_pkg.debug(sqlcode);
1975: fa_rx_util_pkg.debug(sqlerrm);
1976: end armtr_rep;
1969:
1970: exception
1971: when others then
1972: fa_rx_util_pkg.log(sqlcode);
1973: fa_rx_util_pkg.log(sqlerrm);
1974: fa_rx_util_pkg.debug(sqlcode);
1975: fa_rx_util_pkg.debug(sqlerrm);
1976: end armtr_rep;
1977:
1970: exception
1971: when others then
1972: fa_rx_util_pkg.log(sqlcode);
1973: fa_rx_util_pkg.log(sqlerrm);
1974: fa_rx_util_pkg.debug(sqlcode);
1975: fa_rx_util_pkg.debug(sqlerrm);
1976: end armtr_rep;
1977:
1978: end ARRX_RC;
1971: when others then
1972: fa_rx_util_pkg.log(sqlcode);
1973: fa_rx_util_pkg.log(sqlerrm);
1974: fa_rx_util_pkg.debug(sqlcode);
1975: fa_rx_util_pkg.debug(sqlerrm);
1976: end armtr_rep;
1977:
1978: end ARRX_RC;
1979: