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_JA_EXTRACT_PKG dependencies on ZX_REP_TRX_DETAIL_T

Line 96: | all unnecessary rows in ZX_REP_TRX_DETAIL_T table are deleted |

92: | Pre-req : None |
93: | Function : |
94: | This procedure is called to filter the records of transaction tables |
95: | by selecting only the records associated with JA specific lookup type |
96: | all unnecessary rows in ZX_REP_TRX_DETAIL_T table are deleted |
97: | |
98: | Called from AR_TAX_EXTRACT.EXECUTE_SQL. |
99: | |
100: | Parameters : |

Line 200: 'DELETE from ZX_REP_TRX_DETAIL_T DET

196: END IF;
197:
198: -- AMIt changed = to <> because there is NOT
199: l_delete_sql_string:=
200: 'DELETE from ZX_REP_TRX_DETAIL_T DET
201: WHERE DET.REQUEST_ID = '||P_TRL_GLOBAL_VARIABLES_REC.REQUEST_ID||' and NOT(
202: substrb(DET.DOCUMENT_SUB_TYPE,10,2) in (''31'',''32'',''33'',''34'',''35'',''36'',''37'') and
203: DET.TRX_LINE_CLASS IN (''INVOICE'', ''CREDIT_MEMO'') and
204: DET.DOC_EVENT_STATUS <> ''CANCELLED'' and ( ' ||

Line 216: DELETE from ZX_REP_TRX_DETAIL_T DET

212: END IF;
213:
214: -- AMIt changed = to <> because there is NOT
215: EXECUTE IMMEDIATE l_delete_sql_string;
216: DELETE from ZX_REP_TRX_DETAIL_T DET
217: WHERE DET.REQUEST_ID = P_TRL_GLOBAL_VARIABLES_REC.REQUEST_ID and NOT(
218: substrb(DET.DOCUMENT_SUB_TYPE,10,2) in ('31','32','33','34','35','36','37') and
219: DET.TRX_LINE_CLASS IN ('INVOICE', 'CREDIT_MEMO') and
220: DET.DOC_EVENT_STATUS <> 'CANCELLED' and ( DET.TRX_BATCH_SOURCE_ID = P_TRL_GLOBAL_VARIABLES_REC.BATCH_SOURCE_ID and 1 = 1));

Line 255: 'DELETE from ZX_REP_TRX_DETAIL_T DET

251: lp_where_inc_reference_source:= ' 1 = 1';
252: end if;
253:
254: l_delete_sql_string:=
255: 'DELETE from ZX_REP_TRX_DETAIL_T DET
256: WHERE DET.REQUEST_ID = '||P_TRL_GLOBAL_VARIABLES_REC.REQUEST_ID||' and
257: NOT EXISTS
258: (
259: SELECT 1 FROM ra_batch_sources_all rbs,

Line 327: 'DELETE from ZX_REP_TRX_DETAIL_T DET

323: P_TRL_GLOBAL_VARIABLES_REC.exp_method || '''';
324: end if;
325:
326: l_delete_sql_string:=
327: 'DELETE from ZX_REP_TRX_DETAIL_T DET
328: WHERE DET.REQUEST_ID = '||P_TRL_GLOBAL_VARIABLES_REC.REQUEST_ID||' and
329: NOT EXISTS
330: (SELECT 1
331: FROM

Line 370: DELETE from ZX_REP_TRX_DETAIL_T DET

366:
367: elsif P_TRL_GLOBAL_VARIABLES_REC.REPORT_NAME = 'ZXTWRSRD' then
368: /* Taiwanese Sales Return and Discount Report */
369:
370: DELETE from ZX_REP_TRX_DETAIL_T DET
371: WHERE DET.REQUEST_ID = P_TRL_GLOBAL_VARIABLES_REC.REQUEST_ID and
372: NOT (DET.TRX_LINE_CLASS = 'CREDIT_MEMO' and
373: DET.EXTRACT_SOURCE_LEDGER = 'AR' and
374: substrb(DET.DOCUMENT_SUB_TYPE,10,2) IN ('33','34'));

Line 390: DELETE from ZX_REP_TRX_DETAIL_T DET

386: /* Taiwanese EDI Government Uniform Invoice
387: This report should print only the posted transaction if it's not a voided
388: invoices.
389: */
390: DELETE from ZX_REP_TRX_DETAIL_T DET
391: WHERE DET.REQUEST_ID = P_TRL_GLOBAL_VARIABLES_REC.REQUEST_ID and
392: NOT
393: (
394: (DET.EXTRACT_SOURCE_LEDGER = 'AR' and

Line 522: DELETE from ZX_REP_TRX_DETAIL_T DET

518:
519: if P_TRL_GLOBAL_VARIABLES_REC.REPORT_NAME = 'ZXTWPVAT' then
520: /* Taiwanese Input VAT Rerport */
521:
522: DELETE from ZX_REP_TRX_DETAIL_T DET
523: WHERE DET.REQUEST_ID = P_TRL_GLOBAL_VARIABLES_REC.REQUEST_ID and
524: NOT (DET.EXTRACT_SOURCE_LEDGER = 'AP' and
525: DET.TRX_LINE_CLASS IN ('STANDARD INVOICES', 'AP_CREDIT_MEMO', 'AP_DEBIT_MEMO') and
526: substrb(DET.DOCUMENT_SUB_TYPE, 10, 2) in ('21','22','23','24','25','26','27','28')

Line 551: 'DELETE from ZX_REP_TRX_DETAIL_T DET

547: lp_reprint_where:= ' and ai.global_attribute4 is NULL ';
548: end if;
549: */
550: l_delete_sql_string:=
551: 'DELETE from ZX_REP_TRX_DETAIL_T DET
552: WHERE DET.REQUEST_ID = '||P_TRL_GLOBAL_VARIABLES_REC.REQUEST_ID||' and
553: NOT EXISTS (SELECT 1 FROM AP_INVOICES ai
554: WHERE DET.EXTRACT_SOURCE_LEDGER = ''AP'' and
555: DET.TRX_LINE_CLASS IN (''STANDARD INVOICES'',''AP_CREDIT_MEMO'', ''AP_DEBIT_MEMO'') and

Line 575: DELETE from ZX_REP_TRX_DETAIL_T DET

571: END IF;
572:
573: elsif P_TRL_GLOBAL_VARIABLES_REC.REPORT_NAME = 'ZXTWSPRF' then
574: /* Taiwanese Pro Forma 401 Report */
575: DELETE from ZX_REP_TRX_DETAIL_T DET
576: WHERE DET.REQUEST_ID = P_TRL_GLOBAL_VARIABLES_REC.REQUEST_ID and
577: NOT (
578: (DET.EXTRACT_SOURCE_LEDGER = 'AR' and
579: DET.TRX_LINE_CLASS in ('INVOICE', 'CREDIT_MEMO') and

Line 602: DELETE from ZX_REP_TRX_DETAIL_T DET

598:
599:
600: elsif P_TRL_GLOBAL_VARIABLES_REC.REPORT_NAME = 'ZXTWPPRD' then
601: /* Taiwanese Purchase Return and Discount Report */
602: DELETE from ZX_REP_TRX_DETAIL_T DET
603: WHERE DET.REQUEST_ID = P_TRL_GLOBAL_VARIABLES_REC.REQUEST_ID and
604: NOT (DET.EXTRACT_SOURCE_LEDGER = 'AP' and
605: substrb(DET.DOCUMENT_SUB_TYPE,10,2) IN ('23','24') and
606: DET.CANCEL_FLAG <> 'Y'

Line 624: DELETE from ZX_REP_TRX_DETAIL_T DET

620: END IF;
621:
622: elsif P_TRL_GLOBAL_VARIABLES_REC.REPORT_NAME = 'ZXSGAGAL' then
623: /* Singaporean Input Taxes Gain/Loss Report */
624: DELETE from ZX_REP_TRX_DETAIL_T DET
625: WHERE DET.REQUEST_ID = P_TRL_GLOBAL_VARIABLES_REC.REQUEST_ID and
626: NOT (DET.EXTRACT_SOURCE_LEDGER = 'AP' and
627: DET.FUNCTIONAL_CURRENCY_CODE <> DET.TRX_CURRENCY_CODE and
628: DET.SUPPLIER_EXCHANGE_RATE IS NOT NULL and

Line 682: ' DELETE from ZX_REP_TRX_DETAIL_T DET

678: end if;
679:
680:
681: l_delete_sql_string:=
682: ' DELETE from ZX_REP_TRX_DETAIL_T DET
683: WHERE DET.REQUEST_ID = '||P_TRL_GLOBAL_VARIABLES_REC.REQUEST_ID||' and
684: NOT ((DET.EXTRACT_SOURCE_LEDGER in (''AR'',''GL'') '||
685: lp_where_org_art ||' ) or
686: (DET.EXTRACT_SOURCE_LEDGER = ''AP''))';

Line 729: | IN : p_zx_rep_detail_rec zx_rep_trx_detail_t%rowtype |

725: | |
726: | Called from ARP_TAX_EXTRACT.POPULATE_MISSING_COLUMNS. |
727: | |
728: | Parameters : |
729: | IN : p_zx_rep_detail_rec zx_rep_trx_detail_t%rowtype |
730: | p_report_name varchar2 -- required |
731: | |
732: | |
733: | MODIFICATION HISTORY |

Line 905: FROM zx_rep_trx_detail_t itf1

901: l_trx_batch_source_name_tbl,
902: l_document_sub_type_tbl,
903: l_prod_fisc_classification_tbl,
904: l_trx_date_tbl --Bug 5251425
905: FROM zx_rep_trx_detail_t itf1
906: WHERE itf1.request_id = P_TRL_GLOBAL_VARIABLES_REC.REQUEST_ID;
907:
908: IF ( g_level_statement>= g_current_runtime_level ) THEN
909: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_JA_EXTRACT_PKG.populate_ja_ar',

Line 1110: FROM zx_rep_trx_detail_t

1106: /****** Populate the missing columns ********/
1107:
1108: SELECT count(taxable_amt_funcl_curr)
1109: INTO lp_count_taxable
1110: FROM zx_rep_trx_detail_t
1111: WHERE request_id = P_TRL_GLOBAL_VARIABLES_REC.REQUEST_ID;
1112:
1113: FOR i in 1 .. nvl(l_detail_tax_line_id_tbl.count,0) LOOP
1114:

Line 1185: zx_rep_trx_detail_t dtl

1181: l_detail_tax_line_id_tbl
1182: FROM zx_reporting_types_b rep_type,
1183: zx_report_codes_assoc rep_ass,
1184: hr_locations loc,
1185: zx_rep_trx_detail_t dtl
1186: WHERE rep_type.reporting_type_code = 'KR_BUSINESS_LOCATIONS'
1187: AND rep_ass.reporting_type_id = rep_type.reporting_type_id
1188: AND rep_ass.entity_code = 'ZX_RATES'
1189: AND rep_ass.entity_id = dtl.tax_rate_id

Line 1215: zx_rep_trx_detail_t dtl

1211: BULK COLLECT INTO
1212: l_ind_classif_tbl,
1213: l_ind_sub_classif_tbl
1214: FROM hz_cust_acct_sites_all acct_site,
1215: zx_rep_trx_detail_t dtl
1216: WHERE acct_site.cust_acct_site_id = NVL(dtl.shipping_tp_address_id, dtl.billing_tp_address_id)
1217: AND dtl.application_id = 222
1218: AND dtl.request_id = p_trl_global_variables_rec.request_id ;
1219:

Line 1484: FROM zx_rep_trx_detail_t itf1

1480: l_supplier_exchange_rate_tbl,
1481: l_tax_amt_tbl,
1482: l_applied_to_trx_number_tbl,
1483: l_trx_date_tbl
1484: FROM zx_rep_trx_detail_t itf1
1485: WHERE itf1.request_id = P_TRL_GLOBAL_VARIABLES_REC.REQUEST_ID;
1486:
1487: IF ( g_level_statement>= g_current_runtime_level ) THEN
1488: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_JA_EXTRACT_PKG.POPULATE_JA_AP',

Line 1877: zx_rep_trx_detail_t dtl

1873: l_detail_tax_line_id_tbl
1874: FROM zx_reporting_types_b rep_type,
1875: zx_report_codes_assoc rep_ass,
1876: hr_locations loc,
1877: zx_rep_trx_detail_t dtl
1878: WHERE rep_type.reporting_type_code = 'KR_BUSINESS_LOCATIONS'
1879: AND rep_ass.reporting_type_id = rep_type.reporting_type_id
1880: AND rep_ass.entity_code = 'ZX_RATES'
1881: AND rep_ass.entity_id = dtl.tax_rate_id

Line 1901: zx_rep_trx_detail_t dtl

1897: BULK COLLECT INTO
1898: l_ind_classif_tbl,
1899: l_ind_sub_classif_tbl
1900: FROM ap_supplier_sites_all sup_site,
1901: zx_rep_trx_detail_t dtl
1902: WHERE sup_site.vendor_site_id = NVL(dtl.shipping_tp_address_id, dtl.billing_tp_address_id)
1903: AND dtl.application_id = 200
1904: AND dtl.request_id = p_trl_global_variables_rec.request_id ;
1905:

Line 2607: FROM zx_rep_trx_detail_t dtl

2603: CLOSE reg_bank_count_cur;
2604:
2605: SELECT dtl.detail_tax_line_id
2606: BULK COLLECT INTO l_detail_tax_line_id_tbl
2607: FROM zx_rep_trx_detail_t dtl
2608: WHERE dtl.request_id = P_TRL_GLOBAL_VARIABLES_REC.request_id;
2609:
2610: IF (l_bank_id is NOT NULL
2611: OR l_bank_branch_id IS NOT NULL

Line 2665: zx_rep_trx_detail_t dtl

2661: FROM hr_all_organization_units ou,
2662: hr_organization_information oi,
2663: hr_locations loc,
2664: gl_sets_of_books sob,
2665: zx_rep_trx_detail_t dtl
2666: WHERE ou.organization_id = oi.organization_id
2667: AND ou.location_id = loc.location_id
2668: AND TO_NUMBER(oi.org_information1) = sob.set_of_books_id
2669: AND oi.org_information_context = 'Legal Entity Accounting'