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_REC_NREC_DIST

Line 1550: FROM zx_rec_nrec_dist

1546: trx_line_id,
1547: trx_line_dist_id,
1548: g_transaction_rec.first_pty_org_id,
1549: tax_line_id
1550: FROM zx_rec_nrec_dist
1551: WHERE trx_id = p_transaction_id;
1552:
1553: END insert_into_rev_dist_lines_gt;
1554:

Line 2551: | PROCEDURE Insert rows into ZX_TAX_DIST_ID_GT from zx_rec_nrec_dist |

2547: END insert_itm_distributions_gt;
2548:
2549:
2550: /* ========================================================================*
2551: | PROCEDURE Insert rows into ZX_TAX_DIST_ID_GT from zx_rec_nrec_dist |
2552: * ========================================================================*/
2553: PROCEDURE insert_rows_tax_dist_id_gt( p_trx_id IN NUMBER)
2554: IS
2555: BEGIN

Line 2562: FROM ZX_REC_NREC_DIST

2558: TAX_DIST_ID
2559: )
2560: SELECT
2561: REC_NREC_TAX_DIST_ID
2562: FROM ZX_REC_NREC_DIST
2563: WHERE TRX_ID = p_trx_id;
2564:
2565: END insert_rows_tax_dist_id_gt;
2566:

Line 6708: from ZX_REC_NREC_DIST

6704: FOR i in g_suite_rec_tbl.application_id.FIRST..g_suite_rec_tbl.application_id.LAST LOOP
6705:
6706: select object_version_number
6707: into l_object_version_number
6708: from ZX_REC_NREC_DIST
6709: where application_id =g_suite_rec_tbl.application_id(i)
6710: and entity_code = g_suite_rec_tbl.entity_code(i)
6711: and event_class_code = g_suite_rec_tbl.event_class_code(i)
6712: and trx_id = g_suite_rec_tbl.trx_id(i)

Line 6913: from ZX_REC_NREC_DIST

6909: FOR i in g_suite_rec_tbl.application_id.FIRST..g_suite_rec_tbl.application_id.LAST LOOP
6910:
6911: select object_version_number
6912: into l_object_version_number
6913: from ZX_REC_NREC_DIST
6914: where application_id =g_suite_rec_tbl.application_id(i)
6915: and entity_code = g_suite_rec_tbl.entity_code(i)
6916: and event_class_code = g_suite_rec_tbl.event_class_code(i)
6917: and trx_id = g_suite_rec_tbl.trx_id(i)

Line 8215: | ZX_REC_NREC_DIST tables, then Bulk |

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: *==========================================================================*/
8219:

Line 8510: -- Insert ZX_REC_NREC_DIST data

8506: AND zx_lines_summary.tax_rate_id(+) = zx_rates_b.tax_rate_id;
8507:
8508:
8509: --------------------------------------------------
8510: -- Insert ZX_REC_NREC_DIST data
8511: --------------------------------------------------
8512: /*select count(*) into l_dummy from zx_rec_nrec_dist where trx_id =p_transaction_id;
8513: write_message('The number of rows in zx_rec_nrec_dist for transaction id '||to_char(p_transaction_id)||' are '||to_char(l_dummy));*/
8514: INSERT INTO ZX_TEST_API_GT(

Line 8512: /select count() into l_dummy from zx_rec_nrec_dist where trx_id =p_transaction_id;

8508:
8509: --------------------------------------------------
8510: -- Insert ZX_REC_NREC_DIST data
8511: --------------------------------------------------
8512: /*select count(*) into l_dummy from zx_rec_nrec_dist where trx_id =p_transaction_id;
8513: write_message('The number of rows in zx_rec_nrec_dist for transaction id '||to_char(p_transaction_id)||' are '||to_char(l_dummy));*/
8514: INSERT INTO ZX_TEST_API_GT(
8515: SUITE_NUMBER ,
8516: CASE_NUMBER ,

Line 8513: write_message('The number of rows in zx_rec_nrec_dist for transaction id '||to_char(p_transaction_id)||' are '||to_char(l_dummy));*/

8509: --------------------------------------------------
8510: -- Insert ZX_REC_NREC_DIST data
8511: --------------------------------------------------
8512: /*select count(*) into l_dummy from zx_rec_nrec_dist where trx_id =p_transaction_id;
8513: write_message('The number of rows in zx_rec_nrec_dist for transaction id '||to_char(p_transaction_id)||' are '||to_char(l_dummy));*/
8514: INSERT INTO ZX_TEST_API_GT(
8515: SUITE_NUMBER ,
8516: CASE_NUMBER ,
8517: TRX_ID ,

Line 8569: zx_rec_nrec_dist.trx_line_id , --zx_rec_nrec_dist.TRX_LINE_NUMBER

8565: SELECT p_suite ,
8566: p_case ,
8567: p_transaction_id ,
8568: null , --TRX_NUMBER
8569: zx_rec_nrec_dist.trx_line_id , --zx_rec_nrec_dist.TRX_LINE_NUMBER
8570: null , --TRX_DATE
8571: null , --TRX_CURRENCY_CODE
8572: zx_rec_nrec_dist.SUMMARY_TAX_LINE_ID ,
8573: zx_rec_nrec_dist.TAX_LINE_ID ,

Line 8572: zx_rec_nrec_dist.SUMMARY_TAX_LINE_ID ,

8568: null , --TRX_NUMBER
8569: zx_rec_nrec_dist.trx_line_id , --zx_rec_nrec_dist.TRX_LINE_NUMBER
8570: null , --TRX_DATE
8571: null , --TRX_CURRENCY_CODE
8572: zx_rec_nrec_dist.SUMMARY_TAX_LINE_ID ,
8573: zx_rec_nrec_dist.TAX_LINE_ID ,
8574: zx_rec_nrec_dist.TAX_REGIME_CODE ,
8575: null , --TAX_JURISDICTION_ID
8576: zx_rec_nrec_dist.TAX ,

Line 8573: zx_rec_nrec_dist.TAX_LINE_ID ,

8569: zx_rec_nrec_dist.trx_line_id , --zx_rec_nrec_dist.TRX_LINE_NUMBER
8570: null , --TRX_DATE
8571: null , --TRX_CURRENCY_CODE
8572: zx_rec_nrec_dist.SUMMARY_TAX_LINE_ID ,
8573: zx_rec_nrec_dist.TAX_LINE_ID ,
8574: zx_rec_nrec_dist.TAX_REGIME_CODE ,
8575: null , --TAX_JURISDICTION_ID
8576: zx_rec_nrec_dist.TAX ,
8577: zx_rec_nrec_dist.TAX_STATUS_CODE ,

Line 8574: zx_rec_nrec_dist.TAX_REGIME_CODE ,

8570: null , --TRX_DATE
8571: null , --TRX_CURRENCY_CODE
8572: zx_rec_nrec_dist.SUMMARY_TAX_LINE_ID ,
8573: zx_rec_nrec_dist.TAX_LINE_ID ,
8574: zx_rec_nrec_dist.TAX_REGIME_CODE ,
8575: null , --TAX_JURISDICTION_ID
8576: zx_rec_nrec_dist.TAX ,
8577: zx_rec_nrec_dist.TAX_STATUS_CODE ,
8578: zx_rec_nrec_dist.TAX_RATE_ID ,

Line 8576: zx_rec_nrec_dist.TAX ,

8572: zx_rec_nrec_dist.SUMMARY_TAX_LINE_ID ,
8573: zx_rec_nrec_dist.TAX_LINE_ID ,
8574: zx_rec_nrec_dist.TAX_REGIME_CODE ,
8575: null , --TAX_JURISDICTION_ID
8576: zx_rec_nrec_dist.TAX ,
8577: zx_rec_nrec_dist.TAX_STATUS_CODE ,
8578: zx_rec_nrec_dist.TAX_RATE_ID ,
8579: zx_rec_nrec_dist.TAX_RATE_CODE ,
8580: zx_rec_nrec_dist.TAX_RATE ,

Line 8577: zx_rec_nrec_dist.TAX_STATUS_CODE ,

8573: zx_rec_nrec_dist.TAX_LINE_ID ,
8574: zx_rec_nrec_dist.TAX_REGIME_CODE ,
8575: null , --TAX_JURISDICTION_ID
8576: zx_rec_nrec_dist.TAX ,
8577: zx_rec_nrec_dist.TAX_STATUS_CODE ,
8578: zx_rec_nrec_dist.TAX_RATE_ID ,
8579: zx_rec_nrec_dist.TAX_RATE_CODE ,
8580: zx_rec_nrec_dist.TAX_RATE ,
8581: zx_rec_nrec_dist.REC_NREC_TAX_AMT , --TAX_AMT --BUG 4376481, Is this the Tax Amt?

Line 8578: zx_rec_nrec_dist.TAX_RATE_ID ,

8574: zx_rec_nrec_dist.TAX_REGIME_CODE ,
8575: null , --TAX_JURISDICTION_ID
8576: zx_rec_nrec_dist.TAX ,
8577: zx_rec_nrec_dist.TAX_STATUS_CODE ,
8578: zx_rec_nrec_dist.TAX_RATE_ID ,
8579: zx_rec_nrec_dist.TAX_RATE_CODE ,
8580: zx_rec_nrec_dist.TAX_RATE ,
8581: zx_rec_nrec_dist.REC_NREC_TAX_AMT , --TAX_AMT --BUG 4376481, Is this the Tax Amt?
8582: zx_rec_nrec_dist.TAXABLE_AMT ,

Line 8579: zx_rec_nrec_dist.TAX_RATE_CODE ,

8575: null , --TAX_JURISDICTION_ID
8576: zx_rec_nrec_dist.TAX ,
8577: zx_rec_nrec_dist.TAX_STATUS_CODE ,
8578: zx_rec_nrec_dist.TAX_RATE_ID ,
8579: zx_rec_nrec_dist.TAX_RATE_CODE ,
8580: zx_rec_nrec_dist.TAX_RATE ,
8581: zx_rec_nrec_dist.REC_NREC_TAX_AMT , --TAX_AMT --BUG 4376481, Is this the Tax Amt?
8582: zx_rec_nrec_dist.TAXABLE_AMT ,
8583: null , --REC_TAX_AMT

Line 8580: zx_rec_nrec_dist.TAX_RATE ,

8576: zx_rec_nrec_dist.TAX ,
8577: zx_rec_nrec_dist.TAX_STATUS_CODE ,
8578: zx_rec_nrec_dist.TAX_RATE_ID ,
8579: zx_rec_nrec_dist.TAX_RATE_CODE ,
8580: zx_rec_nrec_dist.TAX_RATE ,
8581: zx_rec_nrec_dist.REC_NREC_TAX_AMT , --TAX_AMT --BUG 4376481, Is this the Tax Amt?
8582: zx_rec_nrec_dist.TAXABLE_AMT ,
8583: null , --REC_TAX_AMT
8584: null , --NREC_TAX_AMT

Line 8581: zx_rec_nrec_dist.REC_NREC_TAX_AMT , --TAX_AMT --BUG 4376481, Is this the Tax Amt?

8577: zx_rec_nrec_dist.TAX_STATUS_CODE ,
8578: zx_rec_nrec_dist.TAX_RATE_ID ,
8579: zx_rec_nrec_dist.TAX_RATE_CODE ,
8580: zx_rec_nrec_dist.TAX_RATE ,
8581: zx_rec_nrec_dist.REC_NREC_TAX_AMT , --TAX_AMT --BUG 4376481, Is this the Tax Amt?
8582: zx_rec_nrec_dist.TAXABLE_AMT ,
8583: null , --REC_TAX_AMT
8584: null , --NREC_TAX_AMT
8585: null , --zx_rec_nrec_dist.TAX_AMT_FUNCL_CURR

Line 8582: zx_rec_nrec_dist.TAXABLE_AMT ,

8578: zx_rec_nrec_dist.TAX_RATE_ID ,
8579: zx_rec_nrec_dist.TAX_RATE_CODE ,
8580: zx_rec_nrec_dist.TAX_RATE ,
8581: zx_rec_nrec_dist.REC_NREC_TAX_AMT , --TAX_AMT --BUG 4376481, Is this the Tax Amt?
8582: zx_rec_nrec_dist.TAXABLE_AMT ,
8583: null , --REC_TAX_AMT
8584: null , --NREC_TAX_AMT
8585: null , --zx_rec_nrec_dist.TAX_AMT_FUNCL_CURR
8586: null , --TOTAL_REC_TAX_AMT

Line 8585: null , --zx_rec_nrec_dist.TAX_AMT_FUNCL_CURR

8581: zx_rec_nrec_dist.REC_NREC_TAX_AMT , --TAX_AMT --BUG 4376481, Is this the Tax Amt?
8582: zx_rec_nrec_dist.TAXABLE_AMT ,
8583: null , --REC_TAX_AMT
8584: null , --NREC_TAX_AMT
8585: null , --zx_rec_nrec_dist.TAX_AMT_FUNCL_CURR
8586: null , --TOTAL_REC_TAX_AMT
8587: null , --TOTAL_NREC_TAX_AMT
8588: null , --TOTAL_REC_TAX_AMT_FUNCL_CURR
8589: null , --TOTAL_NREC_TAX_AMT_FUNCL_CURR

Line 8590: null , --zx_rec_nrec_dist.SELF_ASSESSED_FLAG

8586: null , --TOTAL_REC_TAX_AMT
8587: null , --TOTAL_NREC_TAX_AMT
8588: null , --TOTAL_REC_TAX_AMT_FUNCL_CURR
8589: null , --TOTAL_NREC_TAX_AMT_FUNCL_CURR
8590: null , --zx_rec_nrec_dist.SELF_ASSESSED_FLAG
8591: null , --MANUALLY_ENTERED_FLAG
8592: null , --LINE_AMT_INCLUDES_TAX_FLAG
8593: null , --TAXABLE_AMT_FUNCL_CURR
8594: null , --REC_TAX_AMT_FUNCL_CURR

Line 8610: zx_rec_nrec_dist.EVENT_CLASS_CODE ,

8606: null , --TAX_RATE_NAME
8607: null , --TAX_RATE_TYPE
8608: null , --TAX_DETERMINE_DATE
8609: null , --CANCEL_FLAG
8610: zx_rec_nrec_dist.EVENT_CLASS_CODE ,
8611: zx_rec_nrec_dist.EVENT_TYPE_CODE ,
8612: p_service ,
8613: 'N' , --ERROR_FLAG
8614: g_party_rec.prod_family_grp_code||' DIST' --ERROR_MESSAGE

Line 8611: zx_rec_nrec_dist.EVENT_TYPE_CODE ,

8607: null , --TAX_RATE_TYPE
8608: null , --TAX_DETERMINE_DATE
8609: null , --CANCEL_FLAG
8610: zx_rec_nrec_dist.EVENT_CLASS_CODE ,
8611: zx_rec_nrec_dist.EVENT_TYPE_CODE ,
8612: p_service ,
8613: 'N' , --ERROR_FLAG
8614: g_party_rec.prod_family_grp_code||' DIST' --ERROR_MESSAGE
8615: FROM zx_rec_nrec_dist,

Line 8615: FROM zx_rec_nrec_dist,

8611: zx_rec_nrec_dist.EVENT_TYPE_CODE ,
8612: p_service ,
8613: 'N' , --ERROR_FLAG
8614: g_party_rec.prod_family_grp_code||' DIST' --ERROR_MESSAGE
8615: FROM zx_rec_nrec_dist,
8616: zx_rates_b
8617: WHERE trx_id = p_transaction_id
8618: AND application_id = l_application_id
8619: AND entity_code = l_entity_code

Line 8621: AND zx_rec_nrec_dist.tax_rate_id(+) = zx_rates_b.tax_rate_id;

8617: WHERE trx_id = p_transaction_id
8618: AND application_id = l_application_id
8619: AND entity_code = l_entity_code
8620: AND event_class_code = l_event_class_code
8621: AND zx_rec_nrec_dist.tax_rate_id(+) = zx_rates_b.tax_rate_id;
8622:
8623: ELSIF p_error_flag = 'Y' THEN
8624: Write_Message('Error messages will be inserted in the Report Table');
8625: -------------------------------------------------------------------

Line 9349: FROM zx_rec_nrec_dist

9345: TAX_DIST_ID
9346: )
9347: (SELECT
9348: REC_NREC_TAX_DIST_ID
9349: FROM zx_rec_nrec_dist
9350: WHERE tax_id in (SELECT tax_id
9351: FROM zx_lines l
9352: WHERE l.application_id = g_suite_rec_tbl.APPLICATION_ID(i)
9353: AND l.entity_code = g_suite_rec_tbl.ENTITY_CODE(i)

Line 9390: FROM zx_rec_nrec_dist d

9386: TAX_DIST_ID
9387: )
9388: (SELECT rec_nrec_tax_dist_id
9389: REC_NREC_TAX_DIST_ID
9390: FROM zx_rec_nrec_dist d
9391: WHERE d.application_id = g_suite_rec_tbl.APPLICATION_ID(i)
9392: AND d.entity_code = g_suite_rec_tbl.ENTITY_CODE(i)
9393: AND d.event_class_code = g_suite_rec_tbl.EVENT_CLASS_CODE(i)
9394: AND d.trx_id = g_suite_rec_tbl.TRX_ID(i)

Line 9427: FROM zx_rec_nrec_dist

9423: TAX_DIST_ID
9424: )
9425: (SELECT
9426: REC_NREC_TAX_DIST_ID
9427: FROM zx_rec_nrec_dist
9428: WHERE tax_id in (SELECT tax_id
9429: FROM zx_lines l
9430: WHERE l.application_id = g_suite_rec_tbl.APPLICATION_ID(i)
9431: AND l.entity_code = g_suite_rec_tbl.ENTITY_CODE(i)