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 411: FROM zx_rep_trx_detail_t dtl

407: );
408: */
409:
410: DELETE
411: FROM zx_rep_trx_detail_t dtl
412: WHERE DTL.request_id = P_TRL_GLOBAL_VARIABLES_REC.REQUEST_ID
413: AND DTL.EXTRACT_SOURCE_LEDGER = 'AR'
414: AND EXISTS (SELECT 1 FROM ra_cust_trx_types_all types
415: WHERE types.org_id = dtl.internal_organization_id

Line 534: DELETE from ZX_REP_TRX_DETAIL_T DET

530:
531: if P_TRL_GLOBAL_VARIABLES_REC.REPORT_NAME = 'ZXTWPVAT' then
532: /* Taiwanese Input VAT Rerport */
533:
534: DELETE from ZX_REP_TRX_DETAIL_T DET
535: WHERE DET.REQUEST_ID = P_TRL_GLOBAL_VARIABLES_REC.REQUEST_ID and
536: NOT (DET.EXTRACT_SOURCE_LEDGER = 'AP' and
537: DET.TRX_LINE_CLASS IN ('STANDARD INVOICES', 'AP_CREDIT_MEMO', 'AP_DEBIT_MEMO') and
538: substrb(DET.DOCUMENT_SUB_TYPE, 10, 2) in ('21','22','23','24','25','26','27','28')

Line 563: 'DELETE from ZX_REP_TRX_DETAIL_T DET

559: lp_reprint_where:= ' and ai.global_attribute4 is NULL ';
560: end if;
561: */
562: l_delete_sql_string:=
563: 'DELETE from ZX_REP_TRX_DETAIL_T DET
564: WHERE DET.REQUEST_ID = '||P_TRL_GLOBAL_VARIABLES_REC.REQUEST_ID||' and
565: NOT EXISTS (SELECT 1 FROM AP_INVOICES ai
566: WHERE DET.EXTRACT_SOURCE_LEDGER = ''AP'' and
567: DET.TRX_LINE_CLASS IN (''STANDARD INVOICES'',''AP_CREDIT_MEMO'', ''AP_DEBIT_MEMO'') and

Line 587: DELETE from ZX_REP_TRX_DETAIL_T DET

583: END IF;
584:
585: elsif P_TRL_GLOBAL_VARIABLES_REC.REPORT_NAME = 'ZXTWSPRF' then
586: /* Taiwanese Pro Forma 401 Report */
587: DELETE from ZX_REP_TRX_DETAIL_T DET
588: WHERE DET.REQUEST_ID = P_TRL_GLOBAL_VARIABLES_REC.REQUEST_ID and
589: NOT (
590: (DET.EXTRACT_SOURCE_LEDGER = 'AR' and
591: DET.TRX_LINE_CLASS in ('INVOICE', 'CREDIT_MEMO') and

Line 614: DELETE from ZX_REP_TRX_DETAIL_T DET

610:
611:
612: elsif P_TRL_GLOBAL_VARIABLES_REC.REPORT_NAME = 'ZXTWPPRD' then
613: /* Taiwanese Purchase Return and Discount Report */
614: DELETE from ZX_REP_TRX_DETAIL_T DET
615: WHERE DET.REQUEST_ID = P_TRL_GLOBAL_VARIABLES_REC.REQUEST_ID and
616: NOT (DET.EXTRACT_SOURCE_LEDGER = 'AP' and
617: substrb(DET.DOCUMENT_SUB_TYPE,10,2) IN ('23','24') and
618: DET.CANCEL_FLAG <> 'Y'

Line 636: DELETE from ZX_REP_TRX_DETAIL_T DET

632: END IF;
633:
634: elsif P_TRL_GLOBAL_VARIABLES_REC.REPORT_NAME = 'ZXSGAGAL' then
635: /* Singaporean Input Taxes Gain/Loss Report */
636: DELETE from ZX_REP_TRX_DETAIL_T DET
637: WHERE DET.REQUEST_ID = P_TRL_GLOBAL_VARIABLES_REC.REQUEST_ID and
638: NOT (DET.EXTRACT_SOURCE_LEDGER = 'AP' and
639: DET.FUNCTIONAL_CURRENCY_CODE <> DET.TRX_CURRENCY_CODE and
640: DET.SUPPLIER_EXCHANGE_RATE IS NOT NULL and

Line 694: ' DELETE from ZX_REP_TRX_DETAIL_T DET

690: end if;
691:
692:
693: l_delete_sql_string:=
694: ' DELETE from ZX_REP_TRX_DETAIL_T DET
695: WHERE DET.REQUEST_ID = '||P_TRL_GLOBAL_VARIABLES_REC.REQUEST_ID||' and
696: NOT ((DET.EXTRACT_SOURCE_LEDGER in (''AR'',''GL'') '||
697: lp_where_org_art ||' ) or
698: (DET.EXTRACT_SOURCE_LEDGER = ''AP''))';

Line 741: | IN : p_zx_rep_detail_rec zx_rep_trx_detail_t%rowtype |

737: | |
738: | Called from ARP_TAX_EXTRACT.POPULATE_MISSING_COLUMNS. |
739: | |
740: | Parameters : |
741: | IN : p_zx_rep_detail_rec zx_rep_trx_detail_t%rowtype |
742: | p_report_name varchar2 -- required |
743: | |
744: | |
745: | MODIFICATION HISTORY |

Line 918: FROM zx_rep_trx_detail_t itf1

914: l_trx_batch_source_name_tbl,
915: l_document_sub_type_tbl,
916: l_prod_fisc_classification_tbl,
917: l_trx_date_tbl --Bug 5251425
918: FROM zx_rep_trx_detail_t itf1
919: WHERE itf1.request_id = P_TRL_GLOBAL_VARIABLES_REC.REQUEST_ID;
920:
921: IF ( g_level_statement>= g_current_runtime_level ) THEN
922: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_JA_EXTRACT_PKG.populate_ja_ar',

Line 1145: FROM zx_rep_trx_detail_t dtl,

1141: fnd_global.user_id,
1142: sysdate,
1143: fnd_global.login_id,
1144: p_trl_global_variables_rec.request_id
1145: FROM zx_rep_trx_detail_t dtl,
1146: ra_cust_trx_types_all types
1147: WHERE dtl.request_id = P_TRL_GLOBAL_VARIABLES_REC.REQUEST_ID
1148: and dtl.extract_source_ledger = 'AR'
1149: and types.cust_trx_type_id = dtl.trx_type_id

Line 1190: zx_rep_trx_detail_t dtl

1186: l_detail_tax_line_id_tbl
1187: FROM zx_reporting_types_b rep_type,
1188: zx_report_codes_assoc rep_ass,
1189: hr_locations loc,
1190: zx_rep_trx_detail_t dtl
1191: WHERE rep_type.reporting_type_code = 'KR_BUSINESS_LOCATIONS'
1192: AND rep_ass.reporting_type_id = rep_type.reporting_type_id
1193: AND rep_ass.entity_code = 'ZX_RATES'
1194: AND rep_ass.entity_id = dtl.tax_rate_id

Line 1220: zx_rep_trx_detail_t dtl

1216: BULK COLLECT INTO
1217: l_ind_classif_tbl,
1218: l_ind_sub_classif_tbl
1219: FROM hz_cust_acct_sites_all acct_site,
1220: zx_rep_trx_detail_t dtl
1221: WHERE acct_site.cust_acct_site_id = NVL(dtl.shipping_tp_address_id, dtl.billing_tp_address_id)
1222: AND dtl.application_id = 222
1223: AND dtl.request_id = p_trl_global_variables_rec.request_id ;
1224:

Line 1489: FROM zx_rep_trx_detail_t itf1

1485: l_supplier_exchange_rate_tbl,
1486: l_tax_amt_tbl,
1487: l_applied_to_trx_number_tbl,
1488: l_trx_date_tbl
1489: FROM zx_rep_trx_detail_t itf1
1490: WHERE itf1.request_id = P_TRL_GLOBAL_VARIABLES_REC.REQUEST_ID;
1491:
1492: IF ( g_level_statement>= g_current_runtime_level ) THEN
1493: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_JA_EXTRACT_PKG.POPULATE_JA_AP',

Line 1790: FROM zx_rep_trx_detail_t itf

1786: ORDER BY NVL(itf.tax_recoverable_flag,'N'),
1787: itf.actg_source_id,
1788: itf.detail_tax_line_id
1789: ) AS tax_line_change
1790: FROM zx_rep_trx_detail_t itf
1791: WHERE itf.request_id = p_trl_global_variables_rec.request_id
1792: AND itf.application_id = 200);
1793: elsif P_TRL_GLOBAL_VARIABLES_REC.REPORT_NAME = 'ZXSGAGAL' and l_detail_tax_line_id_tbl.count <> 0 then
1794:

Line 1950: zx_rep_trx_detail_t dtl

1946: l_detail_tax_line_id_tbl
1947: FROM zx_reporting_types_b rep_type,
1948: zx_report_codes_assoc rep_ass,
1949: hr_locations loc,
1950: zx_rep_trx_detail_t dtl
1951: WHERE rep_type.reporting_type_code = 'KR_BUSINESS_LOCATIONS'
1952: AND rep_ass.reporting_type_id = rep_type.reporting_type_id
1953: AND rep_ass.entity_code = 'ZX_RATES'
1954: AND rep_ass.entity_id = dtl.tax_rate_id

Line 1974: zx_rep_trx_detail_t dtl

1970: BULK COLLECT INTO
1971: l_ind_classif_tbl,
1972: l_ind_sub_classif_tbl
1973: FROM ap_supplier_sites_all sup_site,
1974: zx_rep_trx_detail_t dtl
1975: WHERE sup_site.vendor_site_id = NVL(dtl.shipping_tp_address_id, dtl.billing_tp_address_id)
1976: AND dtl.application_id = 200
1977: AND dtl.request_id = p_trl_global_variables_rec.request_id ;
1978:

Line 2680: FROM zx_rep_trx_detail_t dtl

2676: CLOSE reg_bank_count_cur;
2677:
2678: SELECT dtl.detail_tax_line_id
2679: BULK COLLECT INTO l_detail_tax_line_id_tbl
2680: FROM zx_rep_trx_detail_t dtl
2681: WHERE dtl.request_id = P_TRL_GLOBAL_VARIABLES_REC.request_id;
2682:
2683: IF (l_bank_id is NOT NULL
2684: OR l_bank_branch_id IS NOT NULL

Line 2742: zx_rep_trx_detail_t dtl

2738: FROM hr_all_organization_units ou,
2739: hr_organization_information oi,
2740: hr_locations loc,
2741: gl_sets_of_books sob,
2742: zx_rep_trx_detail_t dtl
2743: WHERE ou.organization_id = oi.organization_id
2744: AND ou.location_id = loc.location_id
2745: AND TO_NUMBER(oi.org_information1) = sob.set_of_books_id
2746: AND oi.org_information_context = 'Legal Entity Accounting'