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.PO_TAX_INTERFACE_PVT dependencies on ZX_REC_NREC_DIST_GT

Line 1653: FROM zx_rec_nrec_dist_gt zxdist

1649: -- Populate recoverable/nonrecoverable tax columns in distributions table
1650: UPDATE po_req_distributions_all prd
1651: SET prd.recoverable_tax =
1652: (SELECT SUM(zxdist.rec_nrec_tax_amt)
1653: FROM zx_rec_nrec_dist_gt zxdist
1654: WHERE zxdist.trx_line_dist_id = prd.distribution_id
1655: AND zxdist.recoverable_flag = 'Y'
1656: AND zxdist.application_id = PO_CONSTANTS_SV.APPLICATION_ID
1657: AND zxdist.entity_code = PO_CONSTANTS_SV.REQ_ENTITY_CODE

Line 1661: FROM zx_rec_nrec_dist_gt zxdist

1657: AND zxdist.entity_code = PO_CONSTANTS_SV.REQ_ENTITY_CODE
1658: AND zxdist.event_class_code = PO_CONSTANTS_SV.REQ_EVENT_CLASS_CODE)
1659: ,prd.nonrecoverable_tax =
1660: (SELECT SUM(zxdist.rec_nrec_tax_amt)
1661: FROM zx_rec_nrec_dist_gt zxdist
1662: WHERE zxdist.trx_line_dist_id = prd.distribution_id
1663: AND zxdist.recoverable_flag = 'N'
1664: AND zxdist.application_id = PO_CONSTANTS_SV.APPLICATION_ID
1665: AND zxdist.entity_code = PO_CONSTANTS_SV.REQ_ENTITY_CODE

Line 2428: FROM zx_rec_nrec_dist_gt zxdist

2424: -- Populate recoverable/nonrecoverable tax columns in distributions table
2425: UPDATE po_req_distributions_all prd
2426: SET prd.recoverable_tax =
2427: (SELECT SUM(zxdist.rec_nrec_tax_amt)
2428: FROM zx_rec_nrec_dist_gt zxdist
2429: WHERE zxdist.trx_line_dist_id = prd.distribution_id
2430: AND zxdist.recoverable_flag = 'Y'
2431: AND zxdist.application_id = PO_CONSTANTS_SV.APPLICATION_ID
2432: AND zxdist.entity_code = PO_CONSTANTS_SV.REQ_ENTITY_CODE

Line 2436: FROM zx_rec_nrec_dist_gt zxdist

2432: AND zxdist.entity_code = PO_CONSTANTS_SV.REQ_ENTITY_CODE
2433: AND zxdist.event_class_code = PO_CONSTANTS_SV.REQ_EVENT_CLASS_CODE)
2434: ,prd.nonrecoverable_tax =
2435: (SELECT SUM(zxdist.rec_nrec_tax_amt)
2436: FROM zx_rec_nrec_dist_gt zxdist
2437: WHERE zxdist.trx_line_dist_id = prd.distribution_id
2438: AND zxdist.recoverable_flag = 'N'
2439: AND zxdist.application_id = PO_CONSTANTS_SV.APPLICATION_ID
2440: AND zxdist.entity_code = PO_CONSTANTS_SV.REQ_ENTITY_CODE