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.ZX_CORE_REP_EXTRACT_PKG dependencies on ZX_REP_ACTG_EXT_T

Line 44: ZX_REP_ACTG_EXT_T.ACTG_LINE_CCID%TYPE INDEX BY BINARY_INTEGER;

40: TYPE batch_name_tbl IS TABLE OF
41: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE8%TYPE INDEX BY BINARY_INTEGER;
42:
43: TYPE CCID_TBL IS TABLE OF
44: ZX_REP_ACTG_EXT_T.ACTG_LINE_CCID%TYPE INDEX BY BINARY_INTEGER;
45:
46: TYPE NUMBER_TBL is table of number index by binary_integer;
47:
48: TYPE NUMERIC1_TBL IS TABLE OF

Line 410: DELETE FROM zx_rep_actg_ext_t acct1

406: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_CORE_REP_EXTRACT_PKG.POPULATE_CORE_AP',
407: 'Update for ERV/IPV , ext.numeric1 : ' );
408: END IF;
409:
410: DELETE FROM zx_rep_actg_ext_t acct1
411: WHERE acct1.request_id = p_request_id
412: AND acct1.actg_ext_line_id <> (SELECT MIN(actg_ext_line_id)
413: FROM zx_rep_actg_ext_t acct2
414: WHERE acct2.actg_header_id= acct1.actg_header_id

Line 413: FROM zx_rep_actg_ext_t acct2

409:
410: DELETE FROM zx_rep_actg_ext_t acct1
411: WHERE acct1.request_id = p_request_id
412: AND acct1.actg_ext_line_id <> (SELECT MIN(actg_ext_line_id)
413: FROM zx_rep_actg_ext_t acct2
414: WHERE acct2.actg_header_id= acct1.actg_header_id
415: and acct2.actg_event_id = acct1.actg_event_id
416: AND acct2.actg_source_id = acct1.actg_source_id
417: AND acct2.detail_tax_line_id = acct1.detail_tax_line_id

Line 425: 'Deleted duplicate rows from zx_rep_actg_ext_t: '||to_char(SQL%ROWCOUNT) );

421: HAVING COUNT( DISTINCT acct2.actg_ext_line_id) >=2);
422:
423: IF (g_level_statement >= g_current_runtime_level ) THEN
424: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_CORE_REP_EXTRACT_PKG.POPULATE_CORE_AP',
425: 'Deleted duplicate rows from zx_rep_actg_ext_t: '||to_char(SQL%ROWCOUNT) );
426: END IF;
427:
428: update zx_rep_actg_ext_t act
429: set act.period_name = (select apd.period_name

Line 428: update zx_rep_actg_ext_t act

424: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_CORE_REP_EXTRACT_PKG.POPULATE_CORE_AP',
425: 'Deleted duplicate rows from zx_rep_actg_ext_t: '||to_char(SQL%ROWCOUNT) );
426: END IF;
427:
428: update zx_rep_actg_ext_t act
429: set act.period_name = (select apd.period_name
430: from ap_invoice_distributions_all apd,
431: zx_rep_trx_detail_t dtl
432: where dtl.trx_id = apd.invoice_id

Line 441: 'After Updating period name on zx_rep_actg_ext_t table ');

437: and act.period_name is null;
438:
439: IF (g_level_statement >= g_current_runtime_level ) THEN
440: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_CORE_REP_EXTRACT_PKG.POPULATE_CORE_AP',
441: 'After Updating period name on zx_rep_actg_ext_t table ');
442: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_CORE_REP_EXTRACT_PKG.POPULATE_CORE_AP',
443: 'Number of rows updated: '||to_char(SQL%ROWCOUNT));
444: END IF;
445:

Line 450: zx_rep_actg_ext_t act_ext,

446: UPDATE zx_rep_trx_jx_ext_t ext
447: SET ext.numeric1 =
448: (SELECT sum(nvl(lnk.UNROUNDED_accounted_DR,0)-nvl(lnk.UNROUNDED_accounted_CR,0))
449: FROM zx_rep_trx_detail_t dtl,
450: zx_rep_actg_ext_t act_ext,
451: ap_invoice_distributions_all ap_dist,
452: po_distributions_all pod,
453: xla_ae_headers aeh,
454: xla_ae_lines ael,

Line 531: DELETE FROM zx_rep_actg_ext_t acct1

527: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_CORE_REP_EXTRACT_PKG.POPULATE_CORE_AP',
528: 'Report Name: JGVAT ' );
529: END IF;
530:
531: DELETE FROM zx_rep_actg_ext_t acct1
532: WHERE acct1.request_id = p_request_id
533: AND acct1.actg_ext_line_id <> (SELECT MIN(actg_ext_line_id)
534: FROM zx_rep_actg_ext_t acct2
535: WHERE acct2.actg_header_id= acct1.actg_header_id

Line 534: FROM zx_rep_actg_ext_t acct2

530:
531: DELETE FROM zx_rep_actg_ext_t acct1
532: WHERE acct1.request_id = p_request_id
533: AND acct1.actg_ext_line_id <> (SELECT MIN(actg_ext_line_id)
534: FROM zx_rep_actg_ext_t acct2
535: WHERE acct2.actg_header_id= acct1.actg_header_id
536: and acct2.actg_event_id = acct1.actg_event_id
537: AND acct2.actg_source_id = acct1.actg_source_id
538: AND acct2.detail_tax_line_id = acct1.detail_tax_line_id

Line 546: 'Deleted duplicate rows from zx_rep_actg_ext_t: '||to_char(SQL%ROWCOUNT) );

542: HAVING COUNT( DISTINCT acct2.actg_ext_line_id) >=2);
543:
544: IF (g_level_statement >= g_current_runtime_level ) THEN
545: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_CORE_REP_EXTRACT_PKG.POPULATE_CORE_AP',
546: 'Deleted duplicate rows from zx_rep_actg_ext_t: '||to_char(SQL%ROWCOUNT) );
547: END IF;
548:
549:
550: IF p_trl_global_variables_rec.reporting_ledger_id IS NOT NULL THEN

Line 563: zx_rep_actg_ext_t act_ext,

559: SET dtl1.taxable_amt_funcl_curr = nvl(dtl1.taxable_amt_funcl_curr,0)
560: + NVL(( SELECT sum(nvl(lnk.UNROUNDED_accounted_DR,0)-nvl(lnk.UNROUNDED_accounted_CR,0)) *
561: decode(sign(nvl(dtl1.taxable_amt_funcl_curr,0)),0,1,sign(nvl(dtl1.taxable_amt_funcl_curr,0)))
562: FROM zx_rep_trx_detail_t dtl2,
563: zx_rep_actg_ext_t act_ext,
564: AP_INVOICE_DISTRIBUTIONS_ALL AP_DIST,
565: xla_distribution_links lnk,
566: xla_ae_headers aeh,
567: xla_ae_lines ael

Line 594: zx_rep_actg_ext_t act_ext,

590: dtl1.taxable_amt = nvl(dtl1.taxable_amt,0)
591: + NVL(( SELECT sum(nvl(lnk.UNROUNDED_ENTERED_DR,0)-nvl(lnk.UNROUNDED_ENTERED_CR,0)) *
592: decode(sign(nvl(dtl1.taxable_amt,0)),0,1,sign(nvl(dtl1.taxable_amt,0)))
593: FROM zx_rep_trx_detail_t dtl2,
594: zx_rep_actg_ext_t act_ext,
595: AP_INVOICE_DISTRIBUTIONS_ALL AP_DIST,
596: xla_distribution_links lnk,
597: xla_ae_headers aeh,
598: xla_ae_lines ael

Line 908: DELETE FROM zx_rep_actg_ext_t

904:
905: IF P_REPORT_NAME = 'RXZXPFTR' THEN
906: IF P_TRL_GLOBAL_VARIABLES_REC.SUMMARY_LEVEL = 'TRANSACTION_DISTRIBUTION' THEN
907: IF P_POSTING_STATUS = 'TRANSFERRED' THEN
908: DELETE FROM zx_rep_actg_ext_t
909: WHERE request_id = p_request_id
910: AND NVL(gl_transfer_flag,'N') <>'Y';
911:
912: IF ( g_level_statement>= g_current_runtime_level ) THEN

Line 914: 'No of Unposted transactions deleted from zx_rep_actg_ext_t: '|| sql%rowcount);

910: AND NVL(gl_transfer_flag,'N') <>'Y';
911:
912: IF ( g_level_statement>= g_current_runtime_level ) THEN
913: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_JA_EXTRACT_PKG.POPULATE_CORE_AP',
914: 'No of Unposted transactions deleted from zx_rep_actg_ext_t: '|| sql%rowcount);
915: END IF;
916:
917: DELETE FROM zx_rep_trx_detail_t dtl
918: WHERE dtl.request_id = p_request_id

Line 919: AND NOT EXISTS (SELECT 1 FROM zx_rep_actg_ext_t act

915: END IF;
916:
917: DELETE FROM zx_rep_trx_detail_t dtl
918: WHERE dtl.request_id = p_request_id
919: AND NOT EXISTS (SELECT 1 FROM zx_rep_actg_ext_t act
920: WHERE act.detail_tax_line_id = dtl.detail_tax_line_id) ;
921:
922: IF ( g_level_statement>= g_current_runtime_level ) THEN
923: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_JA_EXTRACT_PKG.POPULATE_CORE_AP',

Line 927: DELETE FROM zx_rep_actg_ext_t

923: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_JA_EXTRACT_PKG.POPULATE_CORE_AP',
924: 'No of rows deleted from zx_rep_trx_detail_t: '|| sql%rowcount);
925: END IF;
926: ELSIF P_POSTING_STATUS = 'NOT_TRANSFERRED' THEN
927: DELETE FROM zx_rep_actg_ext_t
928: WHERE request_id = p_request_id
929: AND NVL(gl_transfer_flag,'N') = 'Y';
930: IF ( g_level_statement>= g_current_runtime_level ) THEN
931: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_JA_EXTRACT_PKG.POPULATE_CORE_AP',

Line 932: 'No of Unposted transactions deleted from zx_rep_actg_ext_t: '|| sql%rowcount);

928: WHERE request_id = p_request_id
929: AND NVL(gl_transfer_flag,'N') = 'Y';
930: IF ( g_level_statement>= g_current_runtime_level ) THEN
931: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_JA_EXTRACT_PKG.POPULATE_CORE_AP',
932: 'No of Unposted transactions deleted from zx_rep_actg_ext_t: '|| sql%rowcount);
933: END IF;
934: DELETE FROM zx_rep_trx_detail_t dtl
935: WHERE dtl.request_id = p_request_id
936: AND NVL(dtl.posted_flag,'N') = 'A'

Line 937: AND NOT EXISTS (SELECT 1 FROM zx_rep_actg_ext_t act

933: END IF;
934: DELETE FROM zx_rep_trx_detail_t dtl
935: WHERE dtl.request_id = p_request_id
936: AND NVL(dtl.posted_flag,'N') = 'A'
937: AND NOT EXISTS (SELECT 1 FROM zx_rep_actg_ext_t act
938: WHERE act.detail_tax_line_id = dtl.detail_tax_line_id);
939:
940: IF ( g_level_statement>= g_current_runtime_level ) THEN
941: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_JA_EXTRACT_PKG.POPULATE_CORE_AP',

Line 947: DELETE FROM zx_rep_actg_ext_t acct1

943: END IF;
944: END IF; /* END P_POSTING_STATUS */
945:
946: IF P_TRL_GLOBAL_VARIABLES_REC.REPORTING_LEDGER_ID IS NULL THEN
947: DELETE FROM zx_rep_actg_ext_t acct1
948: WHERE acct1.request_id = p_request_id
949: AND acct1.actg_ext_line_id <> (SELECT MIN(actg_ext_line_id)
950: FROM zx_rep_actg_ext_t acct2
951: WHERE acct2.actg_header_id= acct1.actg_header_id

Line 950: FROM zx_rep_actg_ext_t acct2

946: IF P_TRL_GLOBAL_VARIABLES_REC.REPORTING_LEDGER_ID IS NULL THEN
947: DELETE FROM zx_rep_actg_ext_t acct1
948: WHERE acct1.request_id = p_request_id
949: AND acct1.actg_ext_line_id <> (SELECT MIN(actg_ext_line_id)
950: FROM zx_rep_actg_ext_t acct2
951: WHERE acct2.actg_header_id= acct1.actg_header_id
952: and acct2.actg_event_id = acct1.actg_event_id
953: AND acct2.actg_source_id = acct1.actg_source_id
954: AND acct2.detail_tax_line_id = acct1.detail_tax_line_id

Line 962: 'For Primary Ledger Deleted duplicate rows from zx_rep_actg_ext_t: '||to_char(SQL%ROWCOUNT) );

958: HAVING COUNT( DISTINCT acct2.actg_ext_line_id) >=2);
959:
960: IF (g_level_statement >= g_current_runtime_level ) THEN
961: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_CORE_REP_EXTRACT_PKG.POPULATE_CORE_AP',
962: 'For Primary Ledger Deleted duplicate rows from zx_rep_actg_ext_t: '||to_char(SQL%ROWCOUNT) );
963: END IF;
964: END IF; -- Primary Ledger Id --
965:
966: END IF; -- Summary Level --

Line 1269: FROM ZX_REP_ACTG_EXT_T act

1265: FOR i in 1..nvl(p_detail_tax_line_id_tbl.last,0) LOOP
1266: BEGIN
1267: SELECT Decode(p_ACC_CCID_TBL(i), act.ACTG_LINE_CCID,NULL,l_nls_no )
1268: INTO p_match_tbl(i)
1269: FROM ZX_REP_ACTG_EXT_T act
1270: WHERE act.detail_tax_line_id = p_detail_tax_line_id_tbl(i);
1271: EXCEPTION
1272: WHEN OTHERS THEN
1273: p_match_tbl(i) := null;

Line 2198: DELETE FROM zx_rep_actg_ext_t

2194: END IF;
2195:
2196: IF P_TRL_GLOBAL_VARIABLES_REC.SUMMARY_LEVEL = 'TRANSACTION_DISTRIBUTION' THEN
2197: IF P_POSTING_STATUS = 'TRANSFERRED' THEN
2198: DELETE FROM zx_rep_actg_ext_t
2199: WHERE request_id = p_request_id
2200: AND NVL(gl_transfer_flag,'N') <>'Y';
2201:
2202: IF ( g_level_statement>= g_current_runtime_level ) THEN

Line 2204: 'No of Unposted transactions deleted from zx_rep_actg_ext_t: '|| sql%rowcount);

2200: AND NVL(gl_transfer_flag,'N') <>'Y';
2201:
2202: IF ( g_level_statement>= g_current_runtime_level ) THEN
2203: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_JA_EXTRACT_PKG.POPULATE_CORE_AR',
2204: 'No of Unposted transactions deleted from zx_rep_actg_ext_t: '|| sql%rowcount);
2205: END IF;
2206:
2207: DELETE FROM zx_rep_trx_detail_t dtl
2208: WHERE dtl.request_id = p_request_id

Line 2209: AND NOT EXISTS (SELECT 1 FROM zx_rep_actg_ext_t act

2205: END IF;
2206:
2207: DELETE FROM zx_rep_trx_detail_t dtl
2208: WHERE dtl.request_id = p_request_id
2209: AND NOT EXISTS (SELECT 1 FROM zx_rep_actg_ext_t act
2210: WHERE act.detail_tax_line_id = dtl.detail_tax_line_id) ;
2211:
2212: IF ( g_level_statement>= g_current_runtime_level ) THEN
2213: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_JA_EXTRACT_PKG.POPULATE_CORE_AR',

Line 2217: DELETE FROM zx_rep_actg_ext_t

2213: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_JA_EXTRACT_PKG.POPULATE_CORE_AR',
2214: 'No of rows deleted from zx_rep_trx_detail_t: '|| sql%rowcount);
2215: END IF;
2216: ELSIF P_POSTING_STATUS = 'NOT_TRANSFERRED' THEN
2217: DELETE FROM zx_rep_actg_ext_t
2218: WHERE request_id = p_request_id
2219: AND NVL(gl_transfer_flag,'N') = 'Y';
2220: IF ( g_level_statement>= g_current_runtime_level ) THEN
2221: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_JA_EXTRACT_PKG.POPULATE_CORE_AR',

Line 2222: 'No of posted transactions deleted from zx_rep_actg_ext_t: '|| sql%rowcount);

2218: WHERE request_id = p_request_id
2219: AND NVL(gl_transfer_flag,'N') = 'Y';
2220: IF ( g_level_statement>= g_current_runtime_level ) THEN
2221: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_JA_EXTRACT_PKG.POPULATE_CORE_AR',
2222: 'No of posted transactions deleted from zx_rep_actg_ext_t: '|| sql%rowcount);
2223: END IF;
2224: DELETE FROM zx_rep_trx_detail_t dtl
2225: WHERE dtl.request_id = p_request_id
2226: AND NVL(dtl.posted_flag,'N') = 'Y'

Line 2227: AND NOT EXISTS (SELECT 1 FROM zx_rep_actg_ext_t act

2223: END IF;
2224: DELETE FROM zx_rep_trx_detail_t dtl
2225: WHERE dtl.request_id = p_request_id
2226: AND NVL(dtl.posted_flag,'N') = 'Y'
2227: AND NOT EXISTS (SELECT 1 FROM zx_rep_actg_ext_t act
2228: WHERE act.detail_tax_line_id = dtl.detail_tax_line_id);
2229:
2230: IF ( g_level_statement>= g_current_runtime_level ) THEN
2231: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_JA_EXTRACT_PKG.POPULATE_CORE_AR',

Line 2529: DELETE FROM zx_rep_actg_ext_t

2525: END IF;
2526:
2527:
2528: IF P_POSTING_STATUS = 'POSTED' THEN
2529: DELETE FROM zx_rep_actg_ext_t
2530: WHERE NVL(gl_transfer_flag,'N') <>'Y'
2531: AND request_id = p_request_id;
2532:
2533: DELETE FROM zx_rep_trx_detail_t dtl

Line 2534: WHERE NOT EXISTS (SELECT 1 FROM zx_rep_actg_ext_t act

2530: WHERE NVL(gl_transfer_flag,'N') <>'Y'
2531: AND request_id = p_request_id;
2532:
2533: DELETE FROM zx_rep_trx_detail_t dtl
2534: WHERE NOT EXISTS (SELECT 1 FROM zx_rep_actg_ext_t act
2535: WHERE act.detail_tax_line_id = dtl.detail_tax_line_id)
2536: AND dtl.request_id = p_request_id;
2537: END IF;
2538:

Line 2540: DELETE FROM zx_rep_actg_ext_t

2536: AND dtl.request_id = p_request_id;
2537: END IF;
2538:
2539: IF P_POSTING_STATUS = 'UNPOSTED' THEN
2540: DELETE FROM zx_rep_actg_ext_t
2541: WHERE NVL(gl_transfer_flag,'N') = 'Y'
2542: AND request_id = p_request_id;
2543:
2544: DELETE FROM zx_rep_trx_detail_t dtl

Line 2545: WHERE NOT EXISTS (SELECT 1 FROM zx_rep_actg_ext_t act

2541: WHERE NVL(gl_transfer_flag,'N') = 'Y'
2542: AND request_id = p_request_id;
2543:
2544: DELETE FROM zx_rep_trx_detail_t dtl
2545: WHERE NOT EXISTS (SELECT 1 FROM zx_rep_actg_ext_t act
2546: WHERE act.detail_tax_line_id = dtl.detail_tax_line_id)
2547: AND dtl.request_id = p_request_id;
2548: END IF;
2549:

Line 2685: ZX_REP_ACTG_EXT_T act

2681: L_CCID_TBL,
2682: L_LEDGER_ID_TBL
2683: FROM
2684: zx_rep_trx_detail_t det ,
2685: ZX_REP_ACTG_EXT_T act
2686: WHERE det.request_id = p_request_id
2687: AND det.DETAIL_TAX_LINE_ID = ACT.DETAIL_TAX_LINE_ID(+);
2688:
2689: IF ( g_level_statement>= g_current_runtime_level ) THEN