APPS.ZX_ON_FLY_TRX_UPGRADE_PO_PKG dependencies on ZX_PO_REC_DIST

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

2264: ,SYSDATE LAST_UPDATE_DATE
2265: ,1 LAST_UPDATE_LOGIN
2266: ,1 LAST_UPDATED_BY
2267: ,1 OBJECT_VERSION_NUMBER
2268: FROM (SELECT /*+ use_nl_with_index(recdist ZX_PO_REC_DIST_N1) */
2269: pohzd.*,
2270: recdist.rec_rate d_rec_rate
2271: FROM (SELECT /*+ NO_EXPAND leading(poh) use_nl_with_index(zxl, ZX_LINES_U1) use_nl(pod) */
2272: poh.po_header_id,

Line 2324: zx_po_rec_dist recdist

2320: )
2321: AND pod.po_header_id = poll.po_header_id
2322: AND pod.line_location_id = poll.line_location_id
2323: ) pohzd,
2324: zx_po_rec_dist recdist
2325: WHERE recdist.po_header_id(+) = pohzd.trx_id
2326: AND recdist.po_line_location_id(+) = pohzd.trx_line_id
2327: AND recdist.po_distribution_id(+) = pohzd.p_po_distribution_id
2328: AND recdist.tax_rate_id(+) = pohzd.tax_rate_id

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

4597: ,SYSDATE LAST_UPDATE_DATE
4598: ,1 LAST_UPDATE_LOGIN
4599: ,1 LAST_UPDATED_BY
4600: ,1 OBJECT_VERSION_NUMBER
4601: FROM (SELECT /*+ use_nl_with_index(recdist ZX_PO_REC_DIST_N1) */
4602: pohzd.*,
4603: recdist.rec_rate d_rec_rate
4604: FROM (SELECT /*+ NO_EXPAND leading(poh) use_nl_with_index(zxl, ZX_LINES_U1) use_nl(pod) */
4605: poh.po_header_id,

Line 4658: zx_po_rec_dist recdist

4654: )
4655: AND pod.po_header_id = poll.po_header_id
4656: AND pod.line_location_id = poll.line_location_id
4657: ) pohzd,
4658: zx_po_rec_dist recdist
4659: WHERE recdist.po_header_id(+) = pohzd.trx_id
4660: AND recdist.po_line_location_id(+) = pohzd.trx_line_id
4661: AND recdist.po_distribution_id(+) = pohzd.p_po_distribution_id
4662: AND recdist.tax_rate_id(+) = pohzd.tax_rate_id

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

6961: ,SYSDATE LAST_UPDATE_DATE
6962: ,1 LAST_UPDATE_LOGIN
6963: ,1 LAST_UPDATED_BY
6964: ,1 OBJECT_VERSION_NUMBER
6965: FROM (SELECT /*+ use_nl_with_index(recdist ZX_PO_REC_DIST_N1) */
6966: pohzd.*,
6967: recdist.rec_rate d_rec_rate
6968: FROM (SELECT /*+ NO_EXPAND leading(poh) use_nl_with_index(zxl, ZX_LINES_U1) use_nl(pod) */
6969: poh.po_header_id,

Line 7027: zx_po_rec_dist recdist

7023: )
7024: AND pod.po_header_id = poll.po_header_id
7025: AND pod.line_location_id = poll.line_location_id
7026: ) pohzd,
7027: zx_po_rec_dist recdist
7028: WHERE recdist.po_header_id(+) = pohzd.trx_id
7029: AND recdist.po_line_location_id(+) = pohzd.trx_line_id
7030: AND recdist.po_distribution_id(+) = pohzd.p_po_distribution_id
7031: AND recdist.tax_rate_id(+) = pohzd.tax_rate_id

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

9274: ,SYSDATE LAST_UPDATE_DATE
9275: ,1 LAST_UPDATE_LOGIN
9276: ,1 LAST_UPDATED_BY
9277: ,1 OBJECT_VERSION_NUMBER
9278: FROM (SELECT /*+ use_nl_with_index(recdist ZX_PO_REC_DIST_N1) */
9279: pohzd.*,
9280: recdist.rec_rate d_rec_rate
9281: FROM (SELECT /*+ NO_EXPAND leading(poh) use_nl_with_index(zxl, ZX_LINES_U1) use_nl(pod) */
9282: poh.po_header_id,

Line 9341: zx_po_rec_dist recdist

9337: )
9338: AND pod.po_header_id = poll.po_header_id
9339: AND pod.line_location_id = poll.line_location_id
9340: ) pohzd,
9341: zx_po_rec_dist recdist
9342: WHERE recdist.po_header_id(+) = pohzd.trx_id
9343: AND recdist.po_line_location_id(+) = pohzd.trx_line_id
9344: AND recdist.po_distribution_id(+) = pohzd.p_po_distribution_id
9345: AND recdist.tax_rate_id(+) = pohzd.tax_rate_id