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

APPS.ARP_XLA_EXTRACT_MAIN_PKG dependencies on AR_MFAR_EXTRACT_S

Line 5029: ,-1 * ar_mfar_extract_s.nextval

5025: ,THIRD_PARTY_SITE_ID
5026: ,THIRD_PARTY_TYPE
5027: ,SOURCE_TYPE )
5028: SELECT l.EVENT_ID
5029: ,-1 * ar_mfar_extract_s.nextval
5030: ,l.LANGUAGE
5031: ,l.LEDGER_ID
5032: ,l.SOURCE_ID
5033: ,l.SOURCE_TABLE

Line 5276: ,-1 * ar_mfar_extract_s.nextval

5272: ,THIRD_PARTY_SITE_ID
5273: ,THIRD_PARTY_TYPE
5274: ,SOURCE_TYPE )
5275: SELECT l.EVENT_ID
5276: ,-1 * ar_mfar_extract_s.nextval
5277: ,l.LANGUAGE
5278: ,l.LEDGER_ID
5279: ,l.SOURCE_ID
5280: ,l.SOURCE_TABLE

Line 5644: l_ar_mfar_extract_s number;

5640: k number := 1;
5641: x_app_id number := 0;
5642: x_sign_value number := 0;
5643:
5644: l_ar_mfar_extract_s number;
5645:
5646: -- pl/sql table for ar_xla_lines_extract
5647: TYPE ar_xla_mfar_extract_gt_tab IS TABLE OF ar_xla_lines_extract%ROWTYPE
5648: INDEX BY BINARY_INTEGER;

Line 5722: SELECT ar_mfar_extract_s.nextval INTO l_ar_mfar_extract_s

5718: p_msg_text => 'Prorated Amount: '||x_alloc_acctd_amt);
5719:
5720: END IF;
5721:
5722: SELECT ar_mfar_extract_s.nextval INTO l_ar_mfar_extract_s
5723: FROM dual;
5724:
5725: -- Assign the values to extract table
5726: l_cm_app_mfar_extract_tab(k).EVENT_ID := p_ar_cm_from_rec(i).EVENT_ID;

Line 5727: l_cm_app_mfar_extract_tab(k).LINE_NUMBER := -1 * l_ar_mfar_extract_s;

5723: FROM dual;
5724:
5725: -- Assign the values to extract table
5726: l_cm_app_mfar_extract_tab(k).EVENT_ID := p_ar_cm_from_rec(i).EVENT_ID;
5727: l_cm_app_mfar_extract_tab(k).LINE_NUMBER := -1 * l_ar_mfar_extract_s;
5728: l_cm_app_mfar_extract_tab(k).MFAR_ADDITIONAL_ENTRY := 'Y';
5729: l_cm_app_mfar_extract_tab(k).LEDGER_ID := p_ar_cm_from_rec(i).LEDGER_ID;
5730: l_cm_app_mfar_extract_tab(k).BASE_CURRENCY_CODE := p_ar_cm_from_rec(i).base_currency_code;
5731: l_cm_app_mfar_extract_tab(k).ORG_ID := p_ar_cm_from_rec(i).ORG_ID;

Line 6229: ,-1 * ar_mfar_extract_s.nextval LINE_NUMBER

6225: --
6226: CURSOR mfar_extract_cur IS
6227: SELECT
6228: ordered_crh_by_app.*
6229: ,-1 * ar_mfar_extract_s.nextval LINE_NUMBER
6230: FROM (SELECT
6231: crh.event_id event_id
6232: -- ,-1 * ar_mfar_extract_s.nextval LINE_NUMBER
6233: ,'Y' MFAR_ADDITIONAL_ENTRY

Line 6232: -- ,-1 * ar_mfar_extract_s.nextval LINE_NUMBER

6228: ordered_crh_by_app.*
6229: ,-1 * ar_mfar_extract_s.nextval LINE_NUMBER
6230: FROM (SELECT
6231: crh.event_id event_id
6232: -- ,-1 * ar_mfar_extract_s.nextval LINE_NUMBER
6233: ,'Y' MFAR_ADDITIONAL_ENTRY
6234: ,crh.ledger_id LEDGER_ID
6235: ,crh.base_currency_code BASE_CURRENCY_CODE
6236: ,crh.org_id ORG_ID

Line 6400: ,-1 * ar_mfar_extract_s.NEXTVAL LINE_NUMBER

6396:
6397: CURSOR mfar_extract_app_cur IS
6398: Select
6399: ordered_crh.*
6400: ,-1 * ar_mfar_extract_s.NEXTVAL LINE_NUMBER
6401: FROM
6402: (SELECT
6403: gt.event_id EVENT_ID
6404: -- ,-1 * ar_mfar_extract_s.NEXTVAL LINE_NUMBER

Line 6404: -- ,-1 * ar_mfar_extract_s.NEXTVAL LINE_NUMBER

6400: ,-1 * ar_mfar_extract_s.NEXTVAL LINE_NUMBER
6401: FROM
6402: (SELECT
6403: gt.event_id EVENT_ID
6404: -- ,-1 * ar_mfar_extract_s.NEXTVAL LINE_NUMBER
6405: ,'Y' MFAR_ADDITIONAL_ENTRY
6406: ,trx.set_of_books_id LEDGER_ID
6407: ,lg.currency_code BASE_CURRENCY_CODE
6408: ,ra.org_id ORG_ID

Line 6521: -- ,-1 * ar_mfar_extract_s.NEXTVAL LINE_NUMBER

6517: AND posting_control_id <> -3)
6518: UNION ALL
6519: SELECT
6520: gt.event_id EVENT_ID
6521: -- ,-1 * ar_mfar_extract_s.NEXTVAL LINE_NUMBER
6522: ,'Y' MFAR_ADDITIONAL_ENTRY
6523: ,trx.set_of_books_id LEDGER_ID
6524: ,lg.currency_code BASE_CURRENCY_CODE
6525: ,ra.org_id ORG_ID

Line 6634: -- ,-1 * ar_mfar_extract_s.NEXTVAL LINE_NUMBER

6630: AND ra.applied_customer_trx_id = trx.customer_trx_id
6631: UNION ALL
6632: SELECT
6633: gt.event_id EVENT_ID
6634: -- ,-1 * ar_mfar_extract_s.NEXTVAL LINE_NUMBER
6635: ,'Y' MFAR_ADDITIONAL_ENTRY
6636: ,trx.set_of_books_id LEDGER_ID
6637: ,lg.currency_code BASE_CURRENCY_CODE
6638: ,ra.org_id ORG_ID

Line 6754: -- ,-1 * ar_mfar_extract_s.NEXTVAL LINE_NUMBER

6750: AND NVL(crhlatest.acctd_factor_discount_amount,0) <> 0
6751: UNION ALL
6752: SELECT
6753: gt.event_id EVENT_ID
6754: -- ,-1 * ar_mfar_extract_s.NEXTVAL LINE_NUMBER
6755: ,'Y' MFAR_ADDITIONAL_ENTRY
6756: ,trx.set_of_books_id LEDGER_ID
6757: ,lg.currency_code BASE_CURRENCY_CODE
6758: ,ra.org_id ORG_ID

Line 7018: -1 * ar_mfar_extract_s.nextval, -- LINE_NUMBER

7014: ,REF_DIST_CCID
7015: )
7016: SELECT /*+LEADING(gt) USE_NL(gt, app)*/
7017: gt.event_id, -- EVENT_ID
7018: -1 * ar_mfar_extract_s.nextval, -- LINE_NUMBER
7019: '', -- LANGUAGE
7020: sob.set_of_books_id, -- LEDGER_ID
7021: dist.source_id, -- SOURCE_ID
7022: dist.source_table, -- SOURCE_TABLE

Line 7356: ,-1 * ar_mfar_extract_s.NEXTVAL --LINE_NUMBER

7352: ,EVENT_CLASS_CODE
7353: ,ENTITY_CODE)
7354: SELECT
7355: crh.event_id --event_id
7356: ,-1 * ar_mfar_extract_s.NEXTVAL --LINE_NUMBER
7357: ,'Y' --MFAR_ADDITIONAL_ENTRY
7358: ,crh.ledger_id --LEDGER_ID
7359: ,crh.base_currency_code --BASE_CURRENCY_CODE
7360: ,crh.org_id --ORG_ID

Line 7539: ar_mfar_extract_s.NEXTVAL, --LINE_NUMBER

7535: ,MFAR_ADDITIONAL_ENTRY
7536: )
7537: SELECT /*+LEADING(gt) USE_NL(gt,th)*/
7538: gt.event_id, -- EVENT_ID
7539: ar_mfar_extract_s.NEXTVAL, --LINE_NUMBER
7540: '', -- LANGUAGE
7541: sob.set_of_books_id, -- LEDGER_ID
7542: dist.source_id, -- SOURCE_ID
7543: dist.source_table, -- SOURCE_TABLE