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_TRX_DETAIL_T

Line 199: UPDATE zx_rep_trx_detail_t temp

195:
196: IF P_REPORT_NAME = 'ZXXTATAT' THEN
197: BEGIN
198:
199: UPDATE zx_rep_trx_detail_t temp
200: SET (temp.TAXABLE_AMT,temp.TAXABLE_AMT_FUNCL_CURR)
201: =
202: (SELECT
203: SUM(nvl(lnk.UNROUNDED_ENTERED_DR,0)- nvl(lnk.UNROUNDED_ENTERED_CR,0)

Line 207: FROM zx_rep_trx_detail_t dtl,

203: SUM(nvl(lnk.UNROUNDED_ENTERED_DR,0)- nvl(lnk.UNROUNDED_ENTERED_CR,0)
204: ) taxable_amt,
205: SUM(nvl(lnk.UNROUNDED_ACCOUNTED_DR,0)- nvl(lnk.UNROUNDED_ACCOUNTED_CR,0)
206: ) taxable_act_amt
207: FROM zx_rep_trx_detail_t dtl,
208: ap_prepay_app_dists pre_dist,
209: xla_distribution_links lnk,
210: xla_ae_headers aeh,
211: xla_ae_lines ael

Line 246: UPDATE zx_rep_trx_detail_t dtl

242:
243: -- Upgraded prepay applications new code replaces SLA based queries --
244:
245: IF P_TRL_GLOBAL_VARIABLES_REC.REPORTING_LEDGER_ID IS NULL THEN
246: UPDATE zx_rep_trx_detail_t dtl
247: SET (dtl.TAXABLE_AMT,dtl.TAXABLE_AMT_FUNCL_CURR)
248: = (SELECT dist.amount, nvl(dist.base_amount,dist.amount)
249: FROM AP_INVOICE_DISTRIBUTIONS_ALL dist
250: WHERE dist.invoice_distribution_id = dtl.taxable_item_source_id)

Line 264: UPDATE zx_rep_trx_detail_t dtl

260: AND NVL(dist1.historical_flag,'N') = 'Y');
261:
262: ELSE
263:
264: UPDATE zx_rep_trx_detail_t dtl
265: SET (dtl.TAXABLE_AMT,dtl.TAXABLE_AMT_FUNCL_CURR)
266: = (SELECT sum(mc.amount), sum(nvl(mc.base_amount,mc.amount))
267: FROM AP_INVOICE_DISTRIBUTIONS_ALL dist,
268: AP_MC_INVOICE_DISTS mc

Line 313: FROM zx_rep_trx_detail_t dtl

309: dtl.last_updated_by,
310: dtl.last_update_date,
311: dtl.last_update_login,
312: p_request_id
313: FROM zx_rep_trx_detail_t dtl
314: WHERE EXISTS (select distinct ah.invoice_id
315: FROM ap_holds_all ah
316: WHERE ah.invoice_id = dtl.trx_id
317: AND ah.release_lookup_code IS NULL )

Line 341: zx_rep_trx_detail_t dtl,

337: l_trx_currency_desc_tbl,
338: l_batch_name_tbl,
339: l_acc_ccid_tbl
340: FROM
341: zx_rep_trx_detail_t dtl,
342: fnd_currencies_vl fcv,
343: ap_invoices_all ai,
344: ap_batches_all ab,
345: zx_rates_b rates,

Line 431: zx_rep_trx_detail_t dtl

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
433: and dtl.TAXABLE_ITEM_SOURCE_ID = apd.invoice_distribution_id
434: and act.detail_tax_line_id = dtl.detail_tax_line_id
435: and dtl.request_id = p_request_id)

Line 449: FROM zx_rep_trx_detail_t dtl,

445:
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,

Line 488: UPDATE zx_rep_trx_detail_t dtl

484: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_CORE_REP_EXTRACT_PKG.POPULATE_CORE_AP',
485: 'Number of rows updated in table zx_rep_trx_jx_ext_t: '||to_char(SQL%ROWCOUNT) );
486: END IF;
487:
488: UPDATE zx_rep_trx_detail_t dtl
489: SET dtl.TAXABLE_AMT = 0,
490: dtl.TAXABLE_AMT_FUNCL_CURR = 0
491: WHERE dtl.request_id = p_request_id
492: AND NOT EXISTS

Line 512: 'Number of rows updated to Amt as 0 in table zx_rep_trx_detail_t: '||to_char(SQL%ROWCOUNT));

508: );
509:
510: IF (g_level_statement >= g_current_runtime_level ) THEN
511: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_CORE_REP_EXTRACT_PKG.POPULATE_CORE_AP',
512: 'Number of rows updated to Amt as 0 in table zx_rep_trx_detail_t: '||to_char(SQL%ROWCOUNT));
513: END IF;
514:
515: EXCEPTION
516: WHEN OTHERS THEN

Line 553: 'Update zx_rep_trx_detail_t.taxable_amt_funcl_curr for IPV issue' );

549:
550: IF p_trl_global_variables_rec.reporting_ledger_id IS NOT NULL THEN
551: IF (g_level_statement >= g_current_runtime_level ) THEN
552: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_CORE_REP_EXTRACT_PKG.POPULATE_CORE_AP',
553: 'Update zx_rep_trx_detail_t.taxable_amt_funcl_curr for IPV issue' );
554: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_CORE_REP_EXTRACT_PKG.POPULATE_CORE_AP',
555: 'Reporting_ledger_id : '||to_char(p_trl_global_variables_rec.reporting_ledger_id) );
556: END IF;
557:

Line 558: UPDATE zx_rep_trx_detail_t dtl1

554: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_CORE_REP_EXTRACT_PKG.POPULATE_CORE_AP',
555: 'Reporting_ledger_id : '||to_char(p_trl_global_variables_rec.reporting_ledger_id) );
556: END IF;
557:
558: UPDATE zx_rep_trx_detail_t dtl1
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,

Line 562: FROM zx_rep_trx_detail_t dtl2,

558: UPDATE zx_rep_trx_detail_t dtl1
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,

Line 593: FROM zx_rep_trx_detail_t dtl2,

589: ),0),
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,

Line 633: 'Update zx_rep_trx_detail_t.taxable_amt_funcl_curr with AP Dist base_amount' );

629: ELSE
630:
631: IF (g_level_statement >= g_current_runtime_level ) THEN
632: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_CORE_REP_EXTRACT_PKG.POPULATE_CORE_AP',
633: 'Update zx_rep_trx_detail_t.taxable_amt_funcl_curr with AP Dist base_amount' );
634: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_CORE_REP_EXTRACT_PKG.POPULATE_CORE_AP',
635: 'Primar ledger id : '||to_char(p_trl_global_variables_rec.ledger_id) );
636: END IF;
637:

Line 638: UPDATE zx_rep_trx_detail_t dtl1

634: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_CORE_REP_EXTRACT_PKG.POPULATE_CORE_AP',
635: 'Primar ledger id : '||to_char(p_trl_global_variables_rec.ledger_id) );
636: END IF;
637:
638: UPDATE zx_rep_trx_detail_t dtl1
639: SET dtl1.taxable_amt_funcl_curr =
640: decode(sign(nvl(dtl1.taxable_amt_funcl_curr,0)),0,1,sign(nvl(dtl1.taxable_amt_funcl_curr,0)))
641: *
642: abs((select SUM(NVL(ap_dist.base_amount, ap_dist.amount))

Line 672: 'Update zx_rep_trx_detail_t.taxable_amt_funcl_curr with AP Dist base_amount' );

668: AND dtl1.ref_doc_application_id = 201;
669:
670: IF (g_level_statement >= g_current_runtime_level ) THEN
671: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_CORE_REP_EXTRACT_PKG.POPULATE_CORE_AP',
672: 'Update zx_rep_trx_detail_t.taxable_amt_funcl_curr with AP Dist base_amount' );
673: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_CORE_REP_EXTRACT_PKG.POPULATE_CORE_AP',
674: 'Primar ledger id : '||to_char(p_trl_global_variables_rec.ledger_id) );
675: END IF;
676:

Line 681: UPDATE ZX_REP_TRX_DETAIL_T DTL

677:
678: END IF;
679:
680: -- This update added to populate recovery rate for migrated AP invoices --
681: UPDATE ZX_REP_TRX_DETAIL_T DTL
682: SET DTL.TAX_RECOVERY_RATE =
683: ( SELECT AP_DIST.REC_NREC_RATE
684: FROM AP_INVOICE_DISTRIBUTIONS_ALL AP_DIST
685: WHERE AP_DIST.INVOICE_ID=DTL.TRX_ID

Line 706: UPDATE ZX_REP_TRX_DETAIL_T DTL

702: -- Bug 12814237, This is for the migrated AP invoices where in 11i 2 tax distributions
703: -- carry same tax_code_id and recoverability,but with different tax amount. Use the proration logic,
704: -- similar to 11i, to stamp the recovery rate
705:
706: UPDATE ZX_REP_TRX_DETAIL_T DTL
707: SET DTL.TAX_RECOVERY_RATE = (SELECT (ZX_DIST.rec_nrec_tax_amt/ZX_DIST.trx_line_dist_tax_amt)*100
708: FROM zx_rec_nrec_dist ZX_DIST
709: WHERE DTL.EXTRACT_SOURCE_LEDGER = 'AP'
710: AND ZX_DIST.rec_nrec_tax_dist_id = DTL.actg_source_id

Line 766: zx_rep_trx_detail_t dtl

762: zx_reporting_codes_b rep_code,
763: zx_report_codes_assoc rep_ass,
764: zx_party_tax_profile ptp,
765: xle_etb_profiles xle_pf ,
766: zx_rep_trx_detail_t dtl
767: WHERE rep_type.reporting_type_id = rep_code.reporting_type_id
768: AND rep_type.reporting_type_code = 'MEMBER STATE'
769: AND rep_code.reporting_code_id = rep_ass.reporting_code_id
770: AND rep_ass.entity_code = 'ZX_PARTY_TAX_PROFILE'

Line 816: --Bug 5251425 : To derive the C_CREATED_BY(zx_rep_trx_detail_t.attribute6)

812: 'After getting the org_vat_num' );
813: END IF;
814:
815:
816: --Bug 5251425 : To derive the C_CREATED_BY(zx_rep_trx_detail_t.attribute6)
817: -- and C_ATTRIBUTE3(Operating Unit Desc) into (zx_rep_trx_detail_t.attribute7)
818:
819: GET_CREATED_BY(
820: l_detail_tax_line_id_tbl,

Line 817: -- and C_ATTRIBUTE3(Operating Unit Desc) into (zx_rep_trx_detail_t.attribute7)

813: END IF;
814:
815:
816: --Bug 5251425 : To derive the C_CREATED_BY(zx_rep_trx_detail_t.attribute6)
817: -- and C_ATTRIBUTE3(Operating Unit Desc) into (zx_rep_trx_detail_t.attribute7)
818:
819: GET_CREATED_BY(
820: l_detail_tax_line_id_tbl,
821: l_trx_id_tbl,

Line 881: DELETE FROM zx_rep_trx_detail_t itf

877:
878: END IF ;
879: -- Delete Unwanted lines from Detail ITF
880:
881: DELETE FROM zx_rep_trx_detail_t itf
882: WHERE itf.request_id = p_request_id
883: AND NOT EXISTS ( SELECT 1
884: FROM zx_rep_trx_jx_ext_t ext
885: WHERE ext.detail_tax_line_id = itf.detail_tax_line_id);

Line 889: 'After deletion from zx_rep_trx_detail_t : '||to_char(SQL%ROWCOUNT) );

885: WHERE ext.detail_tax_line_id = itf.detail_tax_line_id);
886:
887: IF (g_level_statement >= g_current_runtime_level ) THEN
888: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_CORE_REP_EXTRACT_PKG.POPULATE_CORE_AP',
889: 'After deletion from zx_rep_trx_detail_t : '||to_char(SQL%ROWCOUNT) );
890: END IF;
891:
892: EXCEPTION
893: WHEN OTHERS THEN

Line 917: DELETE FROM zx_rep_trx_detail_t dtl

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
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:

Line 924: 'No of rows deleted from zx_rep_trx_detail_t: '|| sql%rowcount);

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',
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

Line 934: DELETE FROM zx_rep_trx_detail_t dtl

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'
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);

Line 942: 'No of rows deleted from zx_rep_trx_detail_t: '|| sql%rowcount);

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',
942: 'No of rows deleted from zx_rep_trx_detail_t: '|| sql%rowcount);
943: END IF;
944: END IF; /* END P_POSTING_STATUS */
945:
946: IF P_TRL_GLOBAL_VARIABLES_REC.REPORTING_LEDGER_ID IS NULL THEN

Line 980: FROM zx_rep_trx_detail_t dtl

976: SELECT dtl.detail_tax_line_id,
977: dtl.tax_rate_code
978: BULK COLLECT INTO l_detail_tax_line_id_tbl,
979: l_tax_rate_code_tbl
980: FROM zx_rep_trx_detail_t dtl
981: WHERE dtl.request_id = p_request_id;
982:
983: IF (g_level_statement >= g_current_runtime_level ) THEN
984: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_CORE_REP_EXTRACT_PKG.POPULATE_CORE_AP',

Line 1095: -- zx_rep_trx_detail_t dtl

1091: zx_reporting_codes_b rep_code,
1092: zx_report_codes_assoc rep_ass,
1093: zx_party_tax_profile ptp,
1094: xle_etb_profiles xle_pf
1095: -- zx_rep_trx_detail_t dtl
1096: WHERE rep_type.reporting_type_id = rep_code.reporting_type_id
1097: AND rep_type.reporting_type_code = 'FSO_REG_NUM'
1098: AND rep_code.reporting_code_id = rep_ass.reporting_code_id
1099: AND rep_ass.entity_code = 'ZX_PARTY_TAX_PROFILE'

Line 1384: ZX_REP_TRX_DETAIL_T.DETAIL_TAX_LINE_ID%TYPE INDEX BY BINARY_INTEGER;

1380: x_return_status VARCHAR2(1);
1381: prev_event_class_mapping_id NUMBER;
1382:
1383: TYPE DETAIL_TAX_LINE_ID_TBL IS TABLE OF
1384: ZX_REP_TRX_DETAIL_T.DETAIL_TAX_LINE_ID%TYPE INDEX BY BINARY_INTEGER;
1385: TYPE EVENT_CLASS_MAPPING_ID_TBL IS TABLE OF
1386: ZX_REP_TRX_DETAIL_T.EVENT_CLASS_MAPPING_ID%TYPE INDEX BY BINARY_INTEGER;
1387: TYPE TRX_ID_TBL IS TABLE OF
1388: ZX_REP_TRX_DETAIL_T.TRX_ID%TYPE INDEX BY BINARY_INTEGER;

Line 1386: ZX_REP_TRX_DETAIL_T.EVENT_CLASS_MAPPING_ID%TYPE INDEX BY BINARY_INTEGER;

1382:
1383: TYPE DETAIL_TAX_LINE_ID_TBL IS TABLE OF
1384: ZX_REP_TRX_DETAIL_T.DETAIL_TAX_LINE_ID%TYPE INDEX BY BINARY_INTEGER;
1385: TYPE EVENT_CLASS_MAPPING_ID_TBL IS TABLE OF
1386: ZX_REP_TRX_DETAIL_T.EVENT_CLASS_MAPPING_ID%TYPE INDEX BY BINARY_INTEGER;
1387: TYPE TRX_ID_TBL IS TABLE OF
1388: ZX_REP_TRX_DETAIL_T.TRX_ID%TYPE INDEX BY BINARY_INTEGER;
1389: TYPE TRX_LINE_ID_TBL IS TABLE OF
1390: ZX_REP_TRX_DETAIL_T.TRX_LINE_ID%TYPE INDEX BY BINARY_INTEGER;

Line 1388: ZX_REP_TRX_DETAIL_T.TRX_ID%TYPE INDEX BY BINARY_INTEGER;

1384: ZX_REP_TRX_DETAIL_T.DETAIL_TAX_LINE_ID%TYPE INDEX BY BINARY_INTEGER;
1385: TYPE EVENT_CLASS_MAPPING_ID_TBL IS TABLE OF
1386: ZX_REP_TRX_DETAIL_T.EVENT_CLASS_MAPPING_ID%TYPE INDEX BY BINARY_INTEGER;
1387: TYPE TRX_ID_TBL IS TABLE OF
1388: ZX_REP_TRX_DETAIL_T.TRX_ID%TYPE INDEX BY BINARY_INTEGER;
1389: TYPE TRX_LINE_ID_TBL IS TABLE OF
1390: ZX_REP_TRX_DETAIL_T.TRX_LINE_ID%TYPE INDEX BY BINARY_INTEGER;
1391: TYPE TRX_LEVEL_TYPE_TBL IS TABLE OF
1392: ZX_REP_TRX_DETAIL_T.TRX_LEVEL_TYPE%TYPE INDEX BY BINARY_INTEGER;

Line 1390: ZX_REP_TRX_DETAIL_T.TRX_LINE_ID%TYPE INDEX BY BINARY_INTEGER;

1386: ZX_REP_TRX_DETAIL_T.EVENT_CLASS_MAPPING_ID%TYPE INDEX BY BINARY_INTEGER;
1387: TYPE TRX_ID_TBL IS TABLE OF
1388: ZX_REP_TRX_DETAIL_T.TRX_ID%TYPE INDEX BY BINARY_INTEGER;
1389: TYPE TRX_LINE_ID_TBL IS TABLE OF
1390: ZX_REP_TRX_DETAIL_T.TRX_LINE_ID%TYPE INDEX BY BINARY_INTEGER;
1391: TYPE TRX_LEVEL_TYPE_TBL IS TABLE OF
1392: ZX_REP_TRX_DETAIL_T.TRX_LEVEL_TYPE%TYPE INDEX BY BINARY_INTEGER;
1393: TYPE POS_TYPE_CODE_TBL IS TABLE OF
1394: ZX_REP_TRX_DETAIL_T.PLACE_OF_SUPPLY_TYPE_CODE%TYPE INDEX BY BINARY_INTEGER;

Line 1392: ZX_REP_TRX_DETAIL_T.TRX_LEVEL_TYPE%TYPE INDEX BY BINARY_INTEGER;

1388: ZX_REP_TRX_DETAIL_T.TRX_ID%TYPE INDEX BY BINARY_INTEGER;
1389: TYPE TRX_LINE_ID_TBL IS TABLE OF
1390: ZX_REP_TRX_DETAIL_T.TRX_LINE_ID%TYPE INDEX BY BINARY_INTEGER;
1391: TYPE TRX_LEVEL_TYPE_TBL IS TABLE OF
1392: ZX_REP_TRX_DETAIL_T.TRX_LEVEL_TYPE%TYPE INDEX BY BINARY_INTEGER;
1393: TYPE POS_TYPE_CODE_TBL IS TABLE OF
1394: ZX_REP_TRX_DETAIL_T.PLACE_OF_SUPPLY_TYPE_CODE%TYPE INDEX BY BINARY_INTEGER;
1395: TYPE SHIP_TO_LOCATION_ID_TBL IS TABLE OF
1396: ZX_REP_TRX_DETAIL_T.SHIP_TO_LOCATION_ID%TYPE INDEX BY BINARY_INTEGER;

Line 1394: ZX_REP_TRX_DETAIL_T.PLACE_OF_SUPPLY_TYPE_CODE%TYPE INDEX BY BINARY_INTEGER;

1390: ZX_REP_TRX_DETAIL_T.TRX_LINE_ID%TYPE INDEX BY BINARY_INTEGER;
1391: TYPE TRX_LEVEL_TYPE_TBL IS TABLE OF
1392: ZX_REP_TRX_DETAIL_T.TRX_LEVEL_TYPE%TYPE INDEX BY BINARY_INTEGER;
1393: TYPE POS_TYPE_CODE_TBL IS TABLE OF
1394: ZX_REP_TRX_DETAIL_T.PLACE_OF_SUPPLY_TYPE_CODE%TYPE INDEX BY BINARY_INTEGER;
1395: TYPE SHIP_TO_LOCATION_ID_TBL IS TABLE OF
1396: ZX_REP_TRX_DETAIL_T.SHIP_TO_LOCATION_ID%TYPE INDEX BY BINARY_INTEGER;
1397: TYPE SHIP_FROM_LOCATION_ID_TBL IS TABLE OF
1398: ZX_REP_TRX_DETAIL_T.SHIP_FROM_LOCATION_ID%TYPE INDEX BY BINARY_INTEGER;

Line 1396: ZX_REP_TRX_DETAIL_T.SHIP_TO_LOCATION_ID%TYPE INDEX BY BINARY_INTEGER;

1392: ZX_REP_TRX_DETAIL_T.TRX_LEVEL_TYPE%TYPE INDEX BY BINARY_INTEGER;
1393: TYPE POS_TYPE_CODE_TBL IS TABLE OF
1394: ZX_REP_TRX_DETAIL_T.PLACE_OF_SUPPLY_TYPE_CODE%TYPE INDEX BY BINARY_INTEGER;
1395: TYPE SHIP_TO_LOCATION_ID_TBL IS TABLE OF
1396: ZX_REP_TRX_DETAIL_T.SHIP_TO_LOCATION_ID%TYPE INDEX BY BINARY_INTEGER;
1397: TYPE SHIP_FROM_LOCATION_ID_TBL IS TABLE OF
1398: ZX_REP_TRX_DETAIL_T.SHIP_FROM_LOCATION_ID%TYPE INDEX BY BINARY_INTEGER;
1399: TYPE BILL_TO_LOCATION_ID_TBL IS TABLE OF
1400: ZX_REP_TRX_DETAIL_T.BILL_TO_LOCATION_ID%TYPE INDEX BY BINARY_INTEGER;

Line 1398: ZX_REP_TRX_DETAIL_T.SHIP_FROM_LOCATION_ID%TYPE INDEX BY BINARY_INTEGER;

1394: ZX_REP_TRX_DETAIL_T.PLACE_OF_SUPPLY_TYPE_CODE%TYPE INDEX BY BINARY_INTEGER;
1395: TYPE SHIP_TO_LOCATION_ID_TBL IS TABLE OF
1396: ZX_REP_TRX_DETAIL_T.SHIP_TO_LOCATION_ID%TYPE INDEX BY BINARY_INTEGER;
1397: TYPE SHIP_FROM_LOCATION_ID_TBL IS TABLE OF
1398: ZX_REP_TRX_DETAIL_T.SHIP_FROM_LOCATION_ID%TYPE INDEX BY BINARY_INTEGER;
1399: TYPE BILL_TO_LOCATION_ID_TBL IS TABLE OF
1400: ZX_REP_TRX_DETAIL_T.BILL_TO_LOCATION_ID%TYPE INDEX BY BINARY_INTEGER;
1401: TYPE BILL_FROM_LOCATION_ID_TBL IS TABLE OF
1402: ZX_REP_TRX_DETAIL_T.BILL_FROM_LOCATION_ID%TYPE INDEX BY BINARY_INTEGER;

Line 1400: ZX_REP_TRX_DETAIL_T.BILL_TO_LOCATION_ID%TYPE INDEX BY BINARY_INTEGER;

1396: ZX_REP_TRX_DETAIL_T.SHIP_TO_LOCATION_ID%TYPE INDEX BY BINARY_INTEGER;
1397: TYPE SHIP_FROM_LOCATION_ID_TBL IS TABLE OF
1398: ZX_REP_TRX_DETAIL_T.SHIP_FROM_LOCATION_ID%TYPE INDEX BY BINARY_INTEGER;
1399: TYPE BILL_TO_LOCATION_ID_TBL IS TABLE OF
1400: ZX_REP_TRX_DETAIL_T.BILL_TO_LOCATION_ID%TYPE INDEX BY BINARY_INTEGER;
1401: TYPE BILL_FROM_LOCATION_ID_TBL IS TABLE OF
1402: ZX_REP_TRX_DETAIL_T.BILL_FROM_LOCATION_ID%TYPE INDEX BY BINARY_INTEGER;
1403: TYPE POA_LOCATION_ID_TBL IS TABLE OF
1404: ZX_REP_TRX_DETAIL_T.POA_LOCATION_ID%TYPE INDEX BY BINARY_INTEGER;

Line 1402: ZX_REP_TRX_DETAIL_T.BILL_FROM_LOCATION_ID%TYPE INDEX BY BINARY_INTEGER;

1398: ZX_REP_TRX_DETAIL_T.SHIP_FROM_LOCATION_ID%TYPE INDEX BY BINARY_INTEGER;
1399: TYPE BILL_TO_LOCATION_ID_TBL IS TABLE OF
1400: ZX_REP_TRX_DETAIL_T.BILL_TO_LOCATION_ID%TYPE INDEX BY BINARY_INTEGER;
1401: TYPE BILL_FROM_LOCATION_ID_TBL IS TABLE OF
1402: ZX_REP_TRX_DETAIL_T.BILL_FROM_LOCATION_ID%TYPE INDEX BY BINARY_INTEGER;
1403: TYPE POA_LOCATION_ID_TBL IS TABLE OF
1404: ZX_REP_TRX_DETAIL_T.POA_LOCATION_ID%TYPE INDEX BY BINARY_INTEGER;
1405: TYPE POO_LOCATION_ID_TBL IS TABLE OF
1406: ZX_REP_TRX_DETAIL_T.POO_LOCATION_ID%TYPE INDEX BY BINARY_INTEGER;

Line 1404: ZX_REP_TRX_DETAIL_T.POA_LOCATION_ID%TYPE INDEX BY BINARY_INTEGER;

1400: ZX_REP_TRX_DETAIL_T.BILL_TO_LOCATION_ID%TYPE INDEX BY BINARY_INTEGER;
1401: TYPE BILL_FROM_LOCATION_ID_TBL IS TABLE OF
1402: ZX_REP_TRX_DETAIL_T.BILL_FROM_LOCATION_ID%TYPE INDEX BY BINARY_INTEGER;
1403: TYPE POA_LOCATION_ID_TBL IS TABLE OF
1404: ZX_REP_TRX_DETAIL_T.POA_LOCATION_ID%TYPE INDEX BY BINARY_INTEGER;
1405: TYPE POO_LOCATION_ID_TBL IS TABLE OF
1406: ZX_REP_TRX_DETAIL_T.POO_LOCATION_ID%TYPE INDEX BY BINARY_INTEGER;
1407: TYPE DEF_POS_TYPE_CODE_TBL IS TABLE OF
1408: ZX_REP_TRX_DETAIL_T.DEF_PLACE_OF_SUPPLY_TYPE_CODE%TYPE INDEX BY BINARY_INTEGER;

Line 1406: ZX_REP_TRX_DETAIL_T.POO_LOCATION_ID%TYPE INDEX BY BINARY_INTEGER;

1402: ZX_REP_TRX_DETAIL_T.BILL_FROM_LOCATION_ID%TYPE INDEX BY BINARY_INTEGER;
1403: TYPE POA_LOCATION_ID_TBL IS TABLE OF
1404: ZX_REP_TRX_DETAIL_T.POA_LOCATION_ID%TYPE INDEX BY BINARY_INTEGER;
1405: TYPE POO_LOCATION_ID_TBL IS TABLE OF
1406: ZX_REP_TRX_DETAIL_T.POO_LOCATION_ID%TYPE INDEX BY BINARY_INTEGER;
1407: TYPE DEF_POS_TYPE_CODE_TBL IS TABLE OF
1408: ZX_REP_TRX_DETAIL_T.DEF_PLACE_OF_SUPPLY_TYPE_CODE%TYPE INDEX BY BINARY_INTEGER;
1409: TYPE GEO_VAL_TBL IS TABLE OF VARCHAR2(30) INDEX BY BINARY_INTEGER;
1410: TYPE PERIOD_NAME_TBL IS TABLE OF VARCHAR2(15) INDEX BY BINARY_INTEGER;

Line 1408: ZX_REP_TRX_DETAIL_T.DEF_PLACE_OF_SUPPLY_TYPE_CODE%TYPE INDEX BY BINARY_INTEGER;

1404: ZX_REP_TRX_DETAIL_T.POA_LOCATION_ID%TYPE INDEX BY BINARY_INTEGER;
1405: TYPE POO_LOCATION_ID_TBL IS TABLE OF
1406: ZX_REP_TRX_DETAIL_T.POO_LOCATION_ID%TYPE INDEX BY BINARY_INTEGER;
1407: TYPE DEF_POS_TYPE_CODE_TBL IS TABLE OF
1408: ZX_REP_TRX_DETAIL_T.DEF_PLACE_OF_SUPPLY_TYPE_CODE%TYPE INDEX BY BINARY_INTEGER;
1409: TYPE GEO_VAL_TBL IS TABLE OF VARCHAR2(30) INDEX BY BINARY_INTEGER;
1410: TYPE PERIOD_NAME_TBL IS TABLE OF VARCHAR2(15) INDEX BY BINARY_INTEGER;
1411:
1412: l_detail_tax_line_id_tbl ZX_EXTRACT_PKG.DETAIL_TAX_LINE_ID_TBL;

Line 1543: UPDATE zx_rep_trx_detail_t dtl

1539: END IF;
1540: ELSE
1541: BEGIN
1542: -- Directly populate the tax line id from Base Doc on which application is done.
1543: UPDATE zx_rep_trx_detail_t dtl
1544: set dtl.tax_line_id = (select min (tax_line_id)
1545: from zx_lines lines
1546: where lines.application_id = 222
1547: and lines.trx_id = dtl.ADJUSTED_DOC_TRX_ID

Line 1559: UPDATE zx_rep_trx_detail_t dtl

1555: and dtl.APPLICATION_ID =222
1556: and dtl.APPLIED_FROM_ENTITY_CODE = 'APP';
1557:
1558: -- Directly populate the tax line id from Adjustment Doc
1559: UPDATE zx_rep_trx_detail_t dtl
1560: set dtl.tax_line_id = (select min (tax_line_id)
1561: from zx_lines lines
1562: where lines.application_id = 222
1563: and lines.trx_id = dtl.ADJUSTED_DOC_TRX_ID

Line 1575: UPDATE zx_rep_trx_detail_t dtl

1571: and dtl.APPLICATION_ID =222
1572: and dtl.EVENT_CLASS_CODE = 'ADJ';
1573:
1574: /***
1575: UPDATE zx_rep_trx_detail_t dtl
1576: set tax_line_id = (select min (tax_line_id)
1577: from zx_lines lines
1578: where lines.application_id = 222
1579: and lines.trx_id = dtl.TRX_ID

Line 1589: 'Error in updating tax line id zx_rep_trx_detail_t: Error Message : '||substrb(SQLERRM,1,120) );

1585: ***/
1586: EXCEPTION WHEN OTHERS THEN
1587: IF ( g_level_statement>= g_current_runtime_level ) THEN
1588: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_CORE_REP_EXTRACT_PKG.POPULATE_CORE_AR',
1589: 'Error in updating tax line id zx_rep_trx_detail_t: Error Message : '||substrb(SQLERRM,1,120) );
1590: END IF;
1591: END;
1592:
1593:

Line 1675: FROM zx_rep_trx_detail_t dtl

1671: l_adj_trx_class_mng_tbl,
1672: l_hq_estb_reg_num_tbl,
1673: l_disc_class_mng_tbl,
1674: l_disc_apply_date_tbl
1675: FROM zx_rep_trx_detail_t dtl
1676: WHERE dtl.request_id = P_REQUEST_ID
1677: and ZX_EXTRACT_PKG.get_vat_transaction_code_name(
1678: dtl.tax_line_id,
1679: P_TRL_GLOBAL_VARIABLES_REC.ESL_EU_TRX_TYPE,

Line 2174: DELETE FROM zx_rep_trx_detail_t dtl

2170: 'After insertion into zx_rep_trx_jx_ext_t ');
2171: END IF;
2172:
2173:
2174: DELETE FROM zx_rep_trx_detail_t dtl
2175: WHERE dtl.request_id = p_request_id
2176: AND NOT EXISTS ( SELECT 1
2177: FROM zx_rep_trx_jx_ext_t ext
2178: WHERE ext.detail_tax_line_id = dtl.detail_tax_line_id);

Line 2182: 'After deleting data from zx_rep_trx_detail_t ' ||to_char(SQL%ROWCOUNT));

2178: WHERE ext.detail_tax_line_id = dtl.detail_tax_line_id);
2179:
2180: IF ( g_level_statement>= g_current_runtime_level ) THEN
2181: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_CORE_REP_EXTRACT_PKG.POPULATE_CORE_AR',
2182: 'After deleting data from zx_rep_trx_detail_t ' ||to_char(SQL%ROWCOUNT));
2183: END IF;
2184: END IF; -- Reporting codes parameters NULL check --
2185: END IF; -- report_name
2186: --End Bug 9031051

Line 2207: DELETE FROM zx_rep_trx_detail_t dtl

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
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:

Line 2214: 'No of rows deleted from zx_rep_trx_detail_t: '|| sql%rowcount);

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',
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

Line 2224: DELETE FROM zx_rep_trx_detail_t dtl

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'
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);

Line 2232: 'No of rows deleted from zx_rep_trx_detail_t: '|| sql%rowcount);

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',
2232: 'No of rows deleted from zx_rep_trx_detail_t: '|| sql%rowcount);
2233: END IF;
2234: END IF;
2235: END IF; -- Summary Level --
2236: ELSIF P_REPORT_NAME = 'ARXSTR' THEN

Line 2265: FROM zx_rep_trx_detail_t itf

2261: l_bill_from_location_id_tbl,
2262: l_poa_location_id_tbl,
2263: l_poo_location_id_tbl,
2264: l_def_pos_type_code_tbl
2265: FROM zx_rep_trx_detail_t itf
2266: WHERE itf.request_id = P_REQUEST_ID;
2267: EXCEPTION
2268: WHEN OTHERS THEN
2269: null;

Line 2481: DELETE from zx_rep_trx_detail_t itf

2477:
2478: -- Delete Unwanted lines from Detail ITF
2479:
2480: BEGIN
2481: DELETE from zx_rep_trx_detail_t itf
2482: WHERE itf.request_id = p_request_id
2483: AND NOT EXISTS ( SELECT 1
2484: FROM zx_rep_trx_jx_ext_t ext
2485: WHERE ext.detail_tax_line_id = itf.detail_tax_line_id);

Line 2489: 'After deletion from zx_rep_trx_detail_t : '||to_char(SQL%ROWCOUNT) );

2485: WHERE ext.detail_tax_line_id = itf.detail_tax_line_id);
2486:
2487: IF ( g_level_statement>= g_current_runtime_level ) THEN
2488: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_CORE_REP_EXTRACT_PKG.POPULATE_CORE_AR',
2489: 'After deletion from zx_rep_trx_detail_t : '||to_char(SQL%ROWCOUNT) );
2490: END IF;
2491:
2492: EXCEPTION
2493: WHEN OTHERS THEN

Line 2533: DELETE FROM zx_rep_trx_detail_t dtl

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
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;

Line 2544: DELETE FROM zx_rep_trx_detail_t dtl

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
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;

Line 2684: zx_rep_trx_detail_t det ,

2680: l_trx_id_tbl,
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:

Line 2784: FROM zx_rep_trx_detail_t dtl ,

2780: BULK COLLECT INTO
2781: l_detail_tax_line_id_tbl,
2782: l_trx_id_tbl,
2783: l_org_id_tbl
2784: FROM zx_rep_trx_detail_t dtl ,
2785: ar_receivable_applications_all cash
2786: WHERE dtl.request_id = p_request_id
2787: AND dtl.trx_id = cash.applied_customer_trx_id
2788: AND cash.status = 'APP'

Line 2838: DELETE FROM zx_rep_trx_detail_t dtl

2834: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_CORE_REP_EXTRACT_PKG.POPULATE_CORE_AR',
2835: 'After insertion into zx_rep_trx_jx_ext_t ');
2836: END IF;
2837:
2838: DELETE FROM zx_rep_trx_detail_t dtl
2839: WHERE dtl.request_id = p_request_id
2840: AND NOT EXISTS ( SELECT 1
2841: FROM zx_rep_trx_jx_ext_t ext
2842: WHERE ext.detail_tax_line_id = dtl.detail_tax_line_id);

Line 2846: 'After deleting data from zx_rep_trx_detail_t ' ||to_char(SQL%ROWCOUNT));

2842: WHERE ext.detail_tax_line_id = dtl.detail_tax_line_id);
2843:
2844: IF ( g_level_statement>= g_current_runtime_level ) THEN
2845: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_CORE_REP_EXTRACT_PKG.POPULATE_CORE_AR',
2846: 'After deleting data from zx_rep_trx_detail_t ' ||to_char(SQL%ROWCOUNT));
2847: END IF;
2848:
2849: END IF ;
2850: