APPS.ZX_ON_DEMAND_TRX_UPGRADE_PKG dependencies on ZX_PO_REC_DIST

Line 6201: FROM (SELECT /*+ use_nl_with_index(recdist ZX_PO_REC_DIST_N1) */

6197: SYSDATE LAST_UPDATE_DATE,
6198: 1 LAST_UPDATE_LOGIN,
6199: 1 LAST_UPDATED_BY,
6200: 1 OBJECT_VERSION_NUMBER
6201: FROM (SELECT /*+ use_nl_with_index(recdist ZX_PO_REC_DIST_N1) */
6202: pohzd.*,
6203: recdist.rec_rate d_rec_rate
6204: FROM (SELECT /*+ NO_EXPAND leading(poh) ordered use_nl_with_index(zxl, ZX_LINES_U1) use_nl(pod) */
6205: poh.po_header_id,

Line 6295: zx_po_rec_dist recdist

6291: AND zxl.trx_line_id = poh.line_location_id
6292: AND pod.po_header_id = poh.po_header_id
6293: AND pod.line_location_id = poh.line_location_id
6294: ) pohzd,
6295: zx_po_rec_dist recdist
6296: WHERE recdist.po_header_id(+) = pohzd.trx_id
6297: AND recdist.po_line_location_id(+) = pohzd.trx_line_id
6298: AND recdist.po_distribution_id(+) = pohzd.p_po_distribution_id
6299: AND recdist.tax_rate_id(+) = pohzd.tax_rate_id