APPS.ZX_JE_EXTRACT_PKG dependencies on ZX_REP_TRX_DETAIL_T

Line 322: FROM zx_rep_trx_detail_t itf1

318: )
319: )
320: AND rep_type.reporting_type_code= 'EMEA_VAT_REPORTING_TYPE'),
321: itf1.TAX_LINE_ID
322: FROM zx_rep_trx_detail_t itf1
323: WHERE itf1.application_id = 222
324: AND itf1.extract_source_ledger = 'AR'
325: AND itf1.event_class_code IN ('INVOICE','DEBIT_MEMO','CREDIT_MEMO','APP','ADJ')
326: AND itf1.request_id = P_TRL_GLOBAL_VARIABLES_REC.REQUEST_ID;

Line 359: UPDATE zx_rep_trx_detail_t dtl

355: END IF;
356:
357: BEGIN
358: -- Directly populate the tax line id from Base Doc on which application is done.
359: UPDATE zx_rep_trx_detail_t dtl
360: set dtl.tax_line_id = (select min (tax_line_id)
361: from zx_lines lines
362: where lines.application_id = 222
363: and lines.trx_id = dtl.ADJUSTED_DOC_TRX_ID

Line 375: UPDATE zx_rep_trx_detail_t dtl

371: and dtl.APPLICATION_ID =222
372: and dtl.APPLIED_FROM_ENTITY_CODE = 'APP';
373:
374: -- Directly populate the tax line id from Adjustment Doc
375: UPDATE zx_rep_trx_detail_t dtl
376: set dtl.tax_line_id = (select min (tax_line_id)
377: from zx_lines lines
378: where lines.application_id = 222
379: and lines.trx_id = dtl.ADJUSTED_DOC_TRX_ID

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

389:
390: EXCEPTION WHEN OTHERS THEN
391: IF ( g_level_statement>= g_current_runtime_level ) THEN
392: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_JE_EXTRACT.POPULATE_JE_AR',
393: 'Error in updating tax line id zx_rep_trx_detail_t: Error Message : '||substrb(SQLERRM,1,120) );
394: END IF;
395: END;
396:
397:

Line 400: FROM zx_rep_trx_detail_t itf1

396:
397:
398: SELECT detail_tax_line_id
399: BULK COLLECT INTO l_detail_tax_line_id_tbl
400: FROM zx_rep_trx_detail_t itf1
401: WHERE itf1.application_id = 222
402: AND itf1.extract_source_ledger = 'AR'
403: AND itf1.event_class_code IN ('INVOICE','DEBIT_MEMO','CREDIT_MEMO','APP','ADJ')
404: AND itf1.request_id = P_TRL_GLOBAL_VARIABLES_REC.REQUEST_ID;

Line 473: FROM zx_rep_trx_detail_t itf1

469: fnd_global.user_id,
470: sysdate,
471: fnd_global.login_id,
472: P_TRL_GLOBAL_VARIABLES_REC.REQUEST_ID
473: FROM zx_rep_trx_detail_t itf1
474: WHERE itf1.application_id = 222
475: AND itf1.extract_source_ledger = 'AR'
476: AND itf1.event_class_code IN ('INVOICE','DEBIT_MEMO','CREDIT_MEMO','APP','ADJ')
477: AND itf1.request_id = P_TRL_GLOBAL_VARIABLES_REC.REQUEST_ID;

Line 910: zx_rep_trx_detail_t itf1

906: AND rep_type.reporting_type_code= 'EMEA_VAT_REPORTING_TYPE'),
907: itf1.tax_line_id
908: FROM financials_system_params_all fsp,
909: hr_locations_all hr_loc,
910: zx_rep_trx_detail_t itf1
911: WHERE
912: itf1.application_id = 200
913: AND itf1.entity_code = 'AP_INVOICES'
914: AND itf1.ledger_id = fsp.set_of_books_id

Line 940: FROM zx_rep_trx_detail_t itf1

936:
937:
938: SELECT detail_tax_line_id
939: BULK COLLECT INTO l_tax_line_id_tbl
940: FROM zx_rep_trx_detail_t itf1
941: WHERE itf1.request_id = P_TRL_GLOBAL_VARIABLES_REC.REQUEST_ID;
942:
943:
944: IF l_tax_line_id_tbl.count <> 0 THEN

Line 1004: zx_rep_trx_detail_t itf1

1000: sysdate,
1001: fnd_global.login_id,
1002: P_TRL_GLOBAL_VARIABLES_REC.REQUEST_ID
1003: FROM ap_invoices_all ap_inv,
1004: zx_rep_trx_detail_t itf1
1005: WHERE itf1.trx_id = ap_inv.invoice_id
1006: and itf1.application_id = 200
1007: and itf1.entity_code = 'AP_INVOICES'
1008: and itf1.ledger_id = ap_inv.set_of_books_id

Line 1385: FROM zx_rep_trx_detail_t itf1

1381: )
1382: )
1383: )
1384: AND rep_type.reporting_type_code= 'EMEA_VAT_REPORTING_TYPE')
1385: FROM zx_rep_trx_detail_t itf1
1386: WHERE itf1.application_id = 101
1387: AND itf1.entity_code = 'GL_JE_LINES'
1388: AND itf1.request_id = P_TRL_GLOBAL_VARIABLES_REC.REQUEST_ID;
1389:

Line 1405: FROM zx_rep_trx_detail_t itf1

1401: END IF;
1402:
1403: SELECT detail_tax_line_id
1404: BULK COLLECT INTO l_detail_tax_line_id_tbl
1405: FROM zx_rep_trx_detail_t itf1
1406: WHERE itf1.request_id = P_TRL_GLOBAL_VARIABLES_REC.REQUEST_ID;
1407:
1408: IF (g_level_statement >= g_current_runtime_level ) THEN
1409: FND_LOG.STRING(g_level_statement,

Line 1435: FROM zx_rep_trx_detail_t itf1

1431: sysdate,
1432: fnd_global.login_id,
1433: itf1.tax_type_code, --gjl.tax_type_code,
1434: P_TRL_GLOBAL_VARIABLES_REC.REQUEST_ID
1435: FROM zx_rep_trx_detail_t itf1
1436: WHERE itf1.application_id = 101
1437: AND itf1.request_id = P_TRL_GLOBAL_VARIABLES_REC.REQUEST_ID
1438: AND EXISTS (SELECT 1
1439: FROM gl_je_lines gjl