DBA Data[Home] [Help]

APPS.PO_TAX_INTERFACE_PVT dependencies on ZX_REC_NREC_DIST

Line 755: FROM zx_rec_nrec_dist zxdist

751: -- Populate recoverable/nonrecoverable tax columns in distributions table
752: UPDATE po_distributions_all pd
753: SET pd.recoverable_tax =
754: (SELECT SUM(zxdist.rec_nrec_tax_amt)
755: FROM zx_rec_nrec_dist zxdist
756: WHERE zxdist.trx_line_dist_id = pd.po_distribution_id
757: AND zxdist.recoverable_flag = 'Y'
758: AND zxdist.application_id = PO_CONSTANTS_SV.APPLICATION_ID
759: AND ( (zxdist.entity_code = PO_CONSTANTS_SV.PO_ENTITY_CODE

Line 770: FROM zx_rec_nrec_dist zxdist

766: PO_CONSTANTS_SV.REL_EVENT_CLASS_CODE
767: AND zxdist.trx_id = pd.po_release_id)))
768: ,pd.nonrecoverable_tax =
769: (SELECT SUM(zxdist.rec_nrec_tax_amt)
770: FROM zx_rec_nrec_dist zxdist
771: WHERE zxdist.trx_line_dist_id = pd.po_distribution_id
772: AND zxdist.recoverable_flag = 'N'
773: AND zxdist.application_id = PO_CONSTANTS_SV.APPLICATION_ID
774: AND ( (zxdist.entity_code = PO_CONSTANTS_SV.PO_ENTITY_CODE

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

1798: -- Populate recoverable/nonrecoverable tax columns in distributions table
1799: UPDATE po_distributions_all pd
1800: SET pd.recoverable_tax =
1801: (SELECT SUM(zxdist.rec_nrec_tax_amt)
1802: FROM zx_rec_nrec_dist zxdist
1803: WHERE zxdist.trx_line_dist_id = pd.po_distribution_id
1804: AND zxdist.recoverable_flag = 'Y'
1805: AND zxdist.application_id = PO_CONSTANTS_SV.APPLICATION_ID
1806: AND zxdist.entity_code = PO_CONSTANTS_SV.PO_ENTITY_CODE

Line 1810: FROM zx_rec_nrec_dist zxdist

1806: AND zxdist.entity_code = PO_CONSTANTS_SV.PO_ENTITY_CODE
1807: AND zxdist.event_class_code = PO_CONSTANTS_SV.PO_EVENT_CLASS_CODE)
1808: ,pd.nonrecoverable_tax =
1809: (SELECT SUM(zxdist.rec_nrec_tax_amt)
1810: FROM zx_rec_nrec_dist zxdist
1811: WHERE zxdist.trx_line_dist_id = pd.po_distribution_id
1812: AND zxdist.recoverable_flag = 'N'
1813: AND zxdist.application_id = PO_CONSTANTS_SV.APPLICATION_ID
1814: AND zxdist.entity_code = PO_CONSTANTS_SV.PO_ENTITY_CODE

Line 2021: FROM zx_rec_nrec_dist zxdist

2017: -- Populate recoverable/nonrecoverable tax columns in distributions table
2018: UPDATE po_distributions_all pd
2019: SET pd.recoverable_tax =
2020: (SELECT SUM(zxdist.rec_nrec_tax_amt)
2021: FROM zx_rec_nrec_dist zxdist
2022: WHERE zxdist.trx_line_dist_id = pd.po_distribution_id
2023: AND zxdist.recoverable_flag = 'Y'
2024: AND zxdist.application_id = PO_CONSTANTS_SV.APPLICATION_ID
2025: AND zxdist.entity_code = PO_CONSTANTS_SV.REL_ENTITY_CODE

Line 2029: FROM zx_rec_nrec_dist zxdist

2025: AND zxdist.entity_code = PO_CONSTANTS_SV.REL_ENTITY_CODE
2026: AND zxdist.event_class_code = PO_CONSTANTS_SV.REL_EVENT_CLASS_CODE)
2027: ,pd.nonrecoverable_tax =
2028: (SELECT SUM(zxdist.rec_nrec_tax_amt)
2029: FROM zx_rec_nrec_dist zxdist
2030: WHERE zxdist.trx_line_dist_id = pd.po_distribution_id
2031: AND zxdist.recoverable_flag = 'N'
2032: AND zxdist.application_id = PO_CONSTANTS_SV.APPLICATION_ID
2033: AND zxdist.entity_code = PO_CONSTANTS_SV.REL_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