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

Line 823: FROM zx_rec_nrec_dist zxdist

819: -- Populate recoverable/nonrecoverable tax columns in distributions table
820: UPDATE po_distributions_all pd
821: SET pd.recoverable_tax =
822: (SELECT SUM(zxdist.rec_nrec_tax_amt)
823: FROM zx_rec_nrec_dist zxdist
824: WHERE zxdist.trx_line_dist_id = pd.po_distribution_id
825: AND zxdist.recoverable_flag = 'Y'
826: AND zxdist.application_id = PO_CONSTANTS_SV.APPLICATION_ID
827: AND ( (zxdist.entity_code = PO_CONSTANTS_SV.PO_ENTITY_CODE

Line 838: FROM zx_rec_nrec_dist zxdist

834: PO_CONSTANTS_SV.REL_EVENT_CLASS_CODE
835: AND zxdist.trx_id = pd.po_release_id)))
836: ,pd.nonrecoverable_tax =
837: (SELECT SUM(zxdist.rec_nrec_tax_amt)
838: FROM zx_rec_nrec_dist zxdist
839: WHERE zxdist.trx_line_dist_id = pd.po_distribution_id
840: AND zxdist.recoverable_flag = 'N'
841: AND zxdist.application_id = PO_CONSTANTS_SV.APPLICATION_ID
842: AND ( (zxdist.entity_code = PO_CONSTANTS_SV.PO_ENTITY_CODE

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 1971: FROM zx_rec_nrec_dist zxdist

1967: -- Populate recoverable/nonrecoverable tax columns in distributions table
1968: UPDATE po_distributions_all pd
1969: SET pd.recoverable_tax =
1970: (SELECT SUM(zxdist.rec_nrec_tax_amt)
1971: FROM zx_rec_nrec_dist zxdist
1972: WHERE zxdist.trx_line_dist_id = pd.po_distribution_id
1973: AND zxdist.recoverable_flag = 'Y'
1974: AND zxdist.application_id = PO_CONSTANTS_SV.APPLICATION_ID
1975: AND zxdist.entity_code = PO_CONSTANTS_SV.PO_ENTITY_CODE

Line 1979: FROM zx_rec_nrec_dist zxdist

1975: AND zxdist.entity_code = PO_CONSTANTS_SV.PO_ENTITY_CODE
1976: AND zxdist.event_class_code = PO_CONSTANTS_SV.PO_EVENT_CLASS_CODE)
1977: ,pd.nonrecoverable_tax =
1978: (SELECT SUM(zxdist.rec_nrec_tax_amt)
1979: FROM zx_rec_nrec_dist zxdist
1980: WHERE zxdist.trx_line_dist_id = pd.po_distribution_id
1981: AND zxdist.recoverable_flag = 'N'
1982: AND zxdist.application_id = PO_CONSTANTS_SV.APPLICATION_ID
1983: AND zxdist.entity_code = PO_CONSTANTS_SV.PO_ENTITY_CODE

Line 2206: FROM zx_rec_nrec_dist zxdist

2202: -- Populate recoverable/nonrecoverable tax columns in distributions table
2203: UPDATE po_distributions_all pd
2204: SET pd.recoverable_tax =
2205: (SELECT SUM(zxdist.rec_nrec_tax_amt)
2206: FROM zx_rec_nrec_dist zxdist
2207: WHERE zxdist.trx_line_dist_id = pd.po_distribution_id
2208: AND zxdist.recoverable_flag = 'Y'
2209: AND zxdist.application_id = PO_CONSTANTS_SV.APPLICATION_ID
2210: AND zxdist.entity_code = PO_CONSTANTS_SV.REL_ENTITY_CODE

Line 2214: FROM zx_rec_nrec_dist zxdist

2210: AND zxdist.entity_code = PO_CONSTANTS_SV.REL_ENTITY_CODE
2211: AND zxdist.event_class_code = PO_CONSTANTS_SV.REL_EVENT_CLASS_CODE)
2212: ,pd.nonrecoverable_tax =
2213: (SELECT SUM(zxdist.rec_nrec_tax_amt)
2214: FROM zx_rec_nrec_dist zxdist
2215: WHERE zxdist.trx_line_dist_id = pd.po_distribution_id
2216: AND zxdist.recoverable_flag = 'N'
2217: AND zxdist.application_id = PO_CONSTANTS_SV.APPLICATION_ID
2218: AND zxdist.entity_code = PO_CONSTANTS_SV.REL_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