APPS.ZX_ON_DEMAND_TRX_UPGRADE_PKG dependencies on ZX_PO_REC_DIST

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

5371: SYSDATE LAST_UPDATE_DATE,
5372: 1 LAST_UPDATE_LOGIN,
5373: 1 LAST_UPDATED_BY,
5374: 1 OBJECT_VERSION_NUMBER
5375: FROM (SELECT /*+ use_nl_with_index(recdist ZX_PO_REC_DIST_N1) */
5376: pohzd.*,
5377: recdist.rec_rate d_rec_rate
5378: FROM (SELECT /*+ NO_EXPAND leading(poh) use_nl_with_index(zxl, ZX_LINES_U1) use_nl(pod) */
5379: poh.po_header_id,

Line 5436: zx_po_rec_dist recdist

5432: AND zxl.trx_line_id = poh.line_location_id
5433: AND pod.po_header_id = poh.po_header_id
5434: AND pod.line_location_id = poh.line_location_id
5435: ) pohzd,
5436: zx_po_rec_dist recdist
5437: WHERE recdist.po_header_id(+) = pohzd.trx_id
5438: AND recdist.po_line_location_id(+) = pohzd.trx_line_id
5439: AND recdist.po_distribution_id(+) = pohzd.p_po_distribution_id
5440: AND recdist.tax_rate_id(+) = pohzd.tax_rate_id