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 1484: FROM zx_rec_nrec_dist_gt zxdist

1480: -- Populate recoverable/nonrecoverable tax columns in distributions table
1481: UPDATE po_req_distributions_all prd
1482: SET prd.recoverable_tax =
1483: (SELECT SUM(zxdist.rec_nrec_tax_amt)
1484: FROM zx_rec_nrec_dist_gt zxdist
1485: WHERE zxdist.trx_line_dist_id = prd.distribution_id
1486: AND zxdist.recoverable_flag = 'Y'
1487: AND zxdist.application_id = PO_CONSTANTS_SV.APPLICATION_ID
1488: AND zxdist.entity_code = PO_CONSTANTS_SV.REQ_ENTITY_CODE

Line 1492: FROM zx_rec_nrec_dist_gt zxdist

1488: AND zxdist.entity_code = PO_CONSTANTS_SV.REQ_ENTITY_CODE
1489: AND zxdist.event_class_code = PO_CONSTANTS_SV.REQ_EVENT_CLASS_CODE)
1490: ,prd.nonrecoverable_tax =
1491: (SELECT SUM(zxdist.rec_nrec_tax_amt)
1492: FROM zx_rec_nrec_dist_gt zxdist
1493: WHERE zxdist.trx_line_dist_id = prd.distribution_id
1494: AND zxdist.recoverable_flag = 'N'
1495: AND zxdist.application_id = PO_CONSTANTS_SV.APPLICATION_ID
1496: AND zxdist.entity_code = PO_CONSTANTS_SV.REQ_ENTITY_CODE

Line 2243: FROM zx_rec_nrec_dist_gt zxdist

2239: -- Populate recoverable/nonrecoverable tax columns in distributions table
2240: UPDATE po_req_distributions_all prd
2241: SET prd.recoverable_tax =
2242: (SELECT SUM(zxdist.rec_nrec_tax_amt)
2243: FROM zx_rec_nrec_dist_gt zxdist
2244: WHERE zxdist.trx_line_dist_id = prd.distribution_id
2245: AND zxdist.recoverable_flag = 'Y'
2246: AND zxdist.application_id = PO_CONSTANTS_SV.APPLICATION_ID
2247: AND zxdist.entity_code = PO_CONSTANTS_SV.REQ_ENTITY_CODE

Line 2251: FROM zx_rec_nrec_dist_gt zxdist

2247: AND zxdist.entity_code = PO_CONSTANTS_SV.REQ_ENTITY_CODE
2248: AND zxdist.event_class_code = PO_CONSTANTS_SV.REQ_EVENT_CLASS_CODE)
2249: ,prd.nonrecoverable_tax =
2250: (SELECT SUM(zxdist.rec_nrec_tax_amt)
2251: FROM zx_rec_nrec_dist_gt zxdist
2252: WHERE zxdist.trx_line_dist_id = prd.distribution_id
2253: AND zxdist.recoverable_flag = 'N'
2254: AND zxdist.application_id = PO_CONSTANTS_SV.APPLICATION_ID
2255: AND zxdist.entity_code = PO_CONSTANTS_SV.REQ_ENTITY_CODE