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_TEST_API dependencies on ZX_LINES_SUMMARY

Line 6260: from zx_lines_summary

6256: FOR i in g_suite_rec_tbl.application_id.FIRST..g_suite_rec_tbl.application_id.LAST LOOP
6257:
6258: select object_version_number
6259: into l_object_version_number
6260: from zx_lines_summary
6261: where application_id =g_suite_rec_tbl.application_id(i)
6262: and entity_code = g_suite_rec_tbl.entity_code(i)
6263: and event_class_code = g_suite_rec_tbl.event_class_code(i)
6264: and trx_id = g_suite_rec_tbl.trx_id(i)

Line 6399: from zx_lines_summary

6395: FOR i in g_suite_rec_tbl.application_id.FIRST..g_suite_rec_tbl.application_id.LAST LOOP
6396:
6397: select object_version_number
6398: into l_object_version_number
6399: from zx_lines_summary
6400: where application_id =g_suite_rec_tbl.application_id(i)
6401: and entity_code = g_suite_rec_tbl.entity_code(i)
6402: and event_class_code = g_suite_rec_tbl.event_class_code(i)
6403: and trx_id = g_suite_rec_tbl.trx_id(i)

Line 6565: from zx_lines_summary

6561: FOR i in l_start_row..l_end_row LOOP
6562:
6563: select object_version_number
6564: into l_object_version_number
6565: from zx_lines_summary
6566: where application_id =g_suite_rec_tbl.application_id(i)
6567: and entity_code = g_suite_rec_tbl.entity_code(i)
6568: and event_class_code = g_suite_rec_tbl.event_class_code(i)
6569: and trx_id = g_suite_rec_tbl.trx_id(i)

Line 8214: | from ZX_LINES,ZX_LINES_SUMMARY and |

8210: /*==========================================================================*
8211: | PROCEDURE Populate_Report_Table : Populates the Report Table to display |
8212: | the results of the Suite. |
8213: | First, it has to fetch the information |
8214: | from ZX_LINES,ZX_LINES_SUMMARY and |
8215: | ZX_REC_NREC_DIST tables, then Bulk |
8216: | Collect into memory structures and then|
8217: | Bulk insert into the temporary table. |
8218: *==========================================================================*/

Line 8338: zx_lines.SUMMARY_TAX_LINE_ID ,

8334: zx_lines.TRX_NUMBER ,
8335: zx_lines.trx_line_id , --zx_lines.TRX_LINE_NUMBER,
8336: zx_lines.TRX_DATE ,
8337: zx_lines.TRX_CURRENCY_CODE ,
8338: zx_lines.SUMMARY_TAX_LINE_ID ,
8339: zx_lines.TAX_LINE_ID ,
8340: zx_lines.TAX_REGIME_CODE ,
8341: zx_lines.TAX_JURISDICTION_ID ,
8342: zx_lines.TAX ,

Line 8393: -- Insert ZX_LINES_SUMMARY data

8389: trx_line_id;
8390:
8391:
8392: --------------------------------------------------
8393: -- Insert ZX_LINES_SUMMARY data
8394: --------------------------------------------------
8395: select count(*) into l_dummy from zx_lines_summary where trx_id =p_transaction_id;
8396: write_message('The number of rows in ZX_LINES_SUMMARY for transaction id '
8397: ||to_char(p_transaction_id)||' are '||to_char(l_dummy));

Line 8395: select count(*) into l_dummy from zx_lines_summary where trx_id =p_transaction_id;

8391:
8392: --------------------------------------------------
8393: -- Insert ZX_LINES_SUMMARY data
8394: --------------------------------------------------
8395: select count(*) into l_dummy from zx_lines_summary where trx_id =p_transaction_id;
8396: write_message('The number of rows in ZX_LINES_SUMMARY for transaction id '
8397: ||to_char(p_transaction_id)||' are '||to_char(l_dummy));
8398:
8399: INSERT INTO ZX_TEST_API_GT(

Line 8396: write_message('The number of rows in ZX_LINES_SUMMARY for transaction id '

8392: --------------------------------------------------
8393: -- Insert ZX_LINES_SUMMARY data
8394: --------------------------------------------------
8395: select count(*) into l_dummy from zx_lines_summary where trx_id =p_transaction_id;
8396: write_message('The number of rows in ZX_LINES_SUMMARY for transaction id '
8397: ||to_char(p_transaction_id)||' are '||to_char(l_dummy));
8398:
8399: INSERT INTO ZX_TEST_API_GT(
8400: SUITE_NUMBER ,

Line 8453: zx_lines_summary.TRX_NUMBER ,

8449: ERROR_MESSAGE )
8450: select p_suite ,
8451: p_case ,
8452: p_transaction_id ,
8453: zx_lines_summary.TRX_NUMBER ,
8454: null, --TRX_LINE_NUMBER ,
8455: null, --TRX_DATE ,
8456: null, --TRX_CURRENCY_CODE ,
8457: zx_lines_summary.SUMMARY_TAX_LINE_ID ,

Line 8457: zx_lines_summary.SUMMARY_TAX_LINE_ID ,

8453: zx_lines_summary.TRX_NUMBER ,
8454: null, --TRX_LINE_NUMBER ,
8455: null, --TRX_DATE ,
8456: null, --TRX_CURRENCY_CODE ,
8457: zx_lines_summary.SUMMARY_TAX_LINE_ID ,
8458: null, --TAX_LINE_ID ,
8459: zx_lines_summary.TAX_REGIME_CODE ,
8460: null, --zx_lines_summary.TAX_JURISDICTION_ID, Commented for V6 Changes.
8461: zx_lines_summary.TAX ,

Line 8459: zx_lines_summary.TAX_REGIME_CODE ,

8455: null, --TRX_DATE ,
8456: null, --TRX_CURRENCY_CODE ,
8457: zx_lines_summary.SUMMARY_TAX_LINE_ID ,
8458: null, --TAX_LINE_ID ,
8459: zx_lines_summary.TAX_REGIME_CODE ,
8460: null, --zx_lines_summary.TAX_JURISDICTION_ID, Commented for V6 Changes.
8461: zx_lines_summary.TAX ,
8462: zx_lines_summary.TAX_STATUS_CODE ,
8463: zx_lines_summary.TAX_RATE_ID ,

Line 8460: null, --zx_lines_summary.TAX_JURISDICTION_ID, Commented for V6 Changes.

8456: null, --TRX_CURRENCY_CODE ,
8457: zx_lines_summary.SUMMARY_TAX_LINE_ID ,
8458: null, --TAX_LINE_ID ,
8459: zx_lines_summary.TAX_REGIME_CODE ,
8460: null, --zx_lines_summary.TAX_JURISDICTION_ID, Commented for V6 Changes.
8461: zx_lines_summary.TAX ,
8462: zx_lines_summary.TAX_STATUS_CODE ,
8463: zx_lines_summary.TAX_RATE_ID ,
8464: zx_lines_summary.TAX_RATE_CODE ,

Line 8461: zx_lines_summary.TAX ,

8457: zx_lines_summary.SUMMARY_TAX_LINE_ID ,
8458: null, --TAX_LINE_ID ,
8459: zx_lines_summary.TAX_REGIME_CODE ,
8460: null, --zx_lines_summary.TAX_JURISDICTION_ID, Commented for V6 Changes.
8461: zx_lines_summary.TAX ,
8462: zx_lines_summary.TAX_STATUS_CODE ,
8463: zx_lines_summary.TAX_RATE_ID ,
8464: zx_lines_summary.TAX_RATE_CODE ,
8465: zx_lines_summary.TAX_RATE ,

Line 8462: zx_lines_summary.TAX_STATUS_CODE ,

8458: null, --TAX_LINE_ID ,
8459: zx_lines_summary.TAX_REGIME_CODE ,
8460: null, --zx_lines_summary.TAX_JURISDICTION_ID, Commented for V6 Changes.
8461: zx_lines_summary.TAX ,
8462: zx_lines_summary.TAX_STATUS_CODE ,
8463: zx_lines_summary.TAX_RATE_ID ,
8464: zx_lines_summary.TAX_RATE_CODE ,
8465: zx_lines_summary.TAX_RATE ,
8466: zx_lines_summary.TAX_AMT ,

Line 8463: zx_lines_summary.TAX_RATE_ID ,

8459: zx_lines_summary.TAX_REGIME_CODE ,
8460: null, --zx_lines_summary.TAX_JURISDICTION_ID, Commented for V6 Changes.
8461: zx_lines_summary.TAX ,
8462: zx_lines_summary.TAX_STATUS_CODE ,
8463: zx_lines_summary.TAX_RATE_ID ,
8464: zx_lines_summary.TAX_RATE_CODE ,
8465: zx_lines_summary.TAX_RATE ,
8466: zx_lines_summary.TAX_AMT ,
8467: null, --TAXABLE_AMT ,

Line 8464: zx_lines_summary.TAX_RATE_CODE ,

8460: null, --zx_lines_summary.TAX_JURISDICTION_ID, Commented for V6 Changes.
8461: zx_lines_summary.TAX ,
8462: zx_lines_summary.TAX_STATUS_CODE ,
8463: zx_lines_summary.TAX_RATE_ID ,
8464: zx_lines_summary.TAX_RATE_CODE ,
8465: zx_lines_summary.TAX_RATE ,
8466: zx_lines_summary.TAX_AMT ,
8467: null, --TAXABLE_AMT ,
8468: null, --REC_TAX_AMT ,

Line 8465: zx_lines_summary.TAX_RATE ,

8461: zx_lines_summary.TAX ,
8462: zx_lines_summary.TAX_STATUS_CODE ,
8463: zx_lines_summary.TAX_RATE_ID ,
8464: zx_lines_summary.TAX_RATE_CODE ,
8465: zx_lines_summary.TAX_RATE ,
8466: zx_lines_summary.TAX_AMT ,
8467: null, --TAXABLE_AMT ,
8468: null, --REC_TAX_AMT ,
8469: null, --NREC_TAX_AMT ,

Line 8466: zx_lines_summary.TAX_AMT ,

8462: zx_lines_summary.TAX_STATUS_CODE ,
8463: zx_lines_summary.TAX_RATE_ID ,
8464: zx_lines_summary.TAX_RATE_CODE ,
8465: zx_lines_summary.TAX_RATE ,
8466: zx_lines_summary.TAX_AMT ,
8467: null, --TAXABLE_AMT ,
8468: null, --REC_TAX_AMT ,
8469: null, --NREC_TAX_AMT ,
8470: zx_lines_summary.TAX_AMT_FUNCL_CURR ,

Line 8470: zx_lines_summary.TAX_AMT_FUNCL_CURR ,

8466: zx_lines_summary.TAX_AMT ,
8467: null, --TAXABLE_AMT ,
8468: null, --REC_TAX_AMT ,
8469: null, --NREC_TAX_AMT ,
8470: zx_lines_summary.TAX_AMT_FUNCL_CURR ,
8471: zx_lines_summary.TOTAL_REC_TAX_AMT ,
8472: zx_lines_summary.TOTAL_NREC_TAX_AMT ,
8473: zx_lines_summary.TOTAL_REC_TAX_AMT_FUNCL_CURR ,
8474: zx_lines_summary.TOTAL_NREC_TAX_AMT_FUNCL_CURR ,

Line 8471: zx_lines_summary.TOTAL_REC_TAX_AMT ,

8467: null, --TAXABLE_AMT ,
8468: null, --REC_TAX_AMT ,
8469: null, --NREC_TAX_AMT ,
8470: zx_lines_summary.TAX_AMT_FUNCL_CURR ,
8471: zx_lines_summary.TOTAL_REC_TAX_AMT ,
8472: zx_lines_summary.TOTAL_NREC_TAX_AMT ,
8473: zx_lines_summary.TOTAL_REC_TAX_AMT_FUNCL_CURR ,
8474: zx_lines_summary.TOTAL_NREC_TAX_AMT_FUNCL_CURR ,
8475: zx_lines_summary.SELF_ASSESSED_FLAG ,

Line 8472: zx_lines_summary.TOTAL_NREC_TAX_AMT ,

8468: null, --REC_TAX_AMT ,
8469: null, --NREC_TAX_AMT ,
8470: zx_lines_summary.TAX_AMT_FUNCL_CURR ,
8471: zx_lines_summary.TOTAL_REC_TAX_AMT ,
8472: zx_lines_summary.TOTAL_NREC_TAX_AMT ,
8473: zx_lines_summary.TOTAL_REC_TAX_AMT_FUNCL_CURR ,
8474: zx_lines_summary.TOTAL_NREC_TAX_AMT_FUNCL_CURR ,
8475: zx_lines_summary.SELF_ASSESSED_FLAG ,
8476: zx_lines_summary.MANUALLY_ENTERED_FLAG ,

Line 8473: zx_lines_summary.TOTAL_REC_TAX_AMT_FUNCL_CURR ,

8469: null, --NREC_TAX_AMT ,
8470: zx_lines_summary.TAX_AMT_FUNCL_CURR ,
8471: zx_lines_summary.TOTAL_REC_TAX_AMT ,
8472: zx_lines_summary.TOTAL_NREC_TAX_AMT ,
8473: zx_lines_summary.TOTAL_REC_TAX_AMT_FUNCL_CURR ,
8474: zx_lines_summary.TOTAL_NREC_TAX_AMT_FUNCL_CURR ,
8475: zx_lines_summary.SELF_ASSESSED_FLAG ,
8476: zx_lines_summary.MANUALLY_ENTERED_FLAG ,
8477: null, --LINE_AMT_INCLUDES_TAX_FLAG ,

Line 8474: zx_lines_summary.TOTAL_NREC_TAX_AMT_FUNCL_CURR ,

8470: zx_lines_summary.TAX_AMT_FUNCL_CURR ,
8471: zx_lines_summary.TOTAL_REC_TAX_AMT ,
8472: zx_lines_summary.TOTAL_NREC_TAX_AMT ,
8473: zx_lines_summary.TOTAL_REC_TAX_AMT_FUNCL_CURR ,
8474: zx_lines_summary.TOTAL_NREC_TAX_AMT_FUNCL_CURR ,
8475: zx_lines_summary.SELF_ASSESSED_FLAG ,
8476: zx_lines_summary.MANUALLY_ENTERED_FLAG ,
8477: null, --LINE_AMT_INCLUDES_TAX_FLAG ,
8478: null, --TAXABLE_AMT_FUNCL_CURR ,

Line 8475: zx_lines_summary.SELF_ASSESSED_FLAG ,

8471: zx_lines_summary.TOTAL_REC_TAX_AMT ,
8472: zx_lines_summary.TOTAL_NREC_TAX_AMT ,
8473: zx_lines_summary.TOTAL_REC_TAX_AMT_FUNCL_CURR ,
8474: zx_lines_summary.TOTAL_NREC_TAX_AMT_FUNCL_CURR ,
8475: zx_lines_summary.SELF_ASSESSED_FLAG ,
8476: zx_lines_summary.MANUALLY_ENTERED_FLAG ,
8477: null, --LINE_AMT_INCLUDES_TAX_FLAG ,
8478: null, --TAXABLE_AMT_FUNCL_CURR ,
8479: null, --REC_TAX_AMT_FUNCL_CURR ,

Line 8476: zx_lines_summary.MANUALLY_ENTERED_FLAG ,

8472: zx_lines_summary.TOTAL_NREC_TAX_AMT ,
8473: zx_lines_summary.TOTAL_REC_TAX_AMT_FUNCL_CURR ,
8474: zx_lines_summary.TOTAL_NREC_TAX_AMT_FUNCL_CURR ,
8475: zx_lines_summary.SELF_ASSESSED_FLAG ,
8476: zx_lines_summary.MANUALLY_ENTERED_FLAG ,
8477: null, --LINE_AMT_INCLUDES_TAX_FLAG ,
8478: null, --TAXABLE_AMT_FUNCL_CURR ,
8479: null, --REC_TAX_AMT_FUNCL_CURR ,
8480: null, --NREC_TAX_AMT_FUNCL_CURR ,

Line 8481: zx_lines_summary.TAX_AMT_INCLUDED_FLAG ,

8477: null, --LINE_AMT_INCLUDES_TAX_FLAG ,
8478: null, --TAXABLE_AMT_FUNCL_CURR ,
8479: null, --REC_TAX_AMT_FUNCL_CURR ,
8480: null, --NREC_TAX_AMT_FUNCL_CURR ,
8481: zx_lines_summary.TAX_AMT_INCLUDED_FLAG ,
8482: null, --TAX_EXEMPTION_ID ,
8483: null, --EXEMPTION_RATE ,
8484: null, --EXEMPT_REASON_CODE ,
8485: null, --TAX_APPORTIONMENT_LINE_NUMBER ,

Line 8490: zx_lines_summary.TAX_JURISDICTION_CODE ,

8486: null, --TAX_REGISTRATION_NUMBER ,
8487: null, --TAX_HOLD_CODE ,
8488: null, --TAX_HOLD_RELEASED_CODE ,
8489: null, --LINE_AMT ,
8490: zx_lines_summary.TAX_JURISDICTION_CODE ,
8491: zx_rates_b.tax_rate_code, --null, --TAX_RATE_NAME ,
8492: zx_rates_b.rate_type_code, --null, --TAX_RATE_TYPE ,
8493: null, --TAX_DETERMINE_DATE ,
8494: zx_lines_summary.CANCEL_FLAG ,

Line 8494: zx_lines_summary.CANCEL_FLAG ,

8490: zx_lines_summary.TAX_JURISDICTION_CODE ,
8491: zx_rates_b.tax_rate_code, --null, --TAX_RATE_NAME ,
8492: zx_rates_b.rate_type_code, --null, --TAX_RATE_TYPE ,
8493: null, --TAX_DETERMINE_DATE ,
8494: zx_lines_summary.CANCEL_FLAG ,
8495: zx_lines_summary.EVENT_CLASS_CODE ,
8496: null, --EVENT_TYPE_CODE ,
8497: p_service ,
8498: 'N', --ERROR_FLAG ,

Line 8495: zx_lines_summary.EVENT_CLASS_CODE ,

8491: zx_rates_b.tax_rate_code, --null, --TAX_RATE_NAME ,
8492: zx_rates_b.rate_type_code, --null, --TAX_RATE_TYPE ,
8493: null, --TAX_DETERMINE_DATE ,
8494: zx_lines_summary.CANCEL_FLAG ,
8495: zx_lines_summary.EVENT_CLASS_CODE ,
8496: null, --EVENT_TYPE_CODE ,
8497: p_service ,
8498: 'N', --ERROR_FLAG ,
8499: g_party_rec.prod_family_grp_code||' SUMMARY' --ERROR_MESSAGE

Line 8500: FROM ZX_LINES_SUMMARY,

8496: null, --EVENT_TYPE_CODE ,
8497: p_service ,
8498: 'N', --ERROR_FLAG ,
8499: g_party_rec.prod_family_grp_code||' SUMMARY' --ERROR_MESSAGE
8500: FROM ZX_LINES_SUMMARY,
8501: ZX_RATES_B
8502: WHERE trx_id = p_transaction_id
8503: AND application_id = l_application_id
8504: AND entity_code = l_entity_code

Line 8506: AND zx_lines_summary.tax_rate_id(+) = zx_rates_b.tax_rate_id;

8502: WHERE trx_id = p_transaction_id
8503: AND application_id = l_application_id
8504: AND entity_code = l_entity_code
8505: AND event_class_code = l_event_class_code
8506: AND zx_lines_summary.tax_rate_id(+) = zx_rates_b.tax_rate_id;
8507:
8508:
8509: --------------------------------------------------
8510: -- Insert ZX_REC_NREC_DIST data