APPS.ZX_ON_FLY_TRX_UPGRADE_PO_PKG dependencies on ZX_PO_REC_DIST

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

2319: ,SYSDATE LAST_UPDATE_DATE
2320: ,1 LAST_UPDATE_LOGIN
2321: ,1 LAST_UPDATED_BY
2322: ,1 OBJECT_VERSION_NUMBER
2323: FROM (SELECT /*+ use_nl_with_index(recdist ZX_PO_REC_DIST_N1) */
2324: pohzd.*,
2325: recdist.rec_rate d_rec_rate
2326: FROM (SELECT /*+ NO_EXPAND leading(poh) use_nl_with_index(zxl, ZX_LINES_U1) use_nl(pod) */
2327: poh.po_header_id,

Line 2380: zx_po_rec_dist recdist

2376: )
2377: AND pod.po_header_id = poll.po_header_id
2378: AND pod.line_location_id = poll.line_location_id
2379: ) pohzd,
2380: zx_po_rec_dist recdist
2381: WHERE recdist.po_header_id(+) = pohzd.trx_id
2382: AND recdist.po_line_location_id(+) = pohzd.trx_line_id
2383: AND recdist.po_distribution_id(+) = pohzd.p_po_distribution_id
2384: AND recdist.tax_rate_id(+) = pohzd.tax_rate_id

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

4680: ,SYSDATE LAST_UPDATE_DATE
4681: ,1 LAST_UPDATE_LOGIN
4682: ,1 LAST_UPDATED_BY
4683: ,1 OBJECT_VERSION_NUMBER
4684: FROM (SELECT /*+ use_nl_with_index(recdist ZX_PO_REC_DIST_N1) */
4685: pohzd.*,
4686: recdist.rec_rate d_rec_rate
4687: FROM (SELECT /*+ NO_EXPAND leading(poh) use_nl_with_index(zxl, ZX_LINES_U1) use_nl(pod) */
4688: poh.po_header_id,

Line 4742: zx_po_rec_dist recdist

4738: )
4739: AND pod.po_header_id = poll.po_header_id
4740: AND pod.line_location_id = poll.line_location_id
4741: ) pohzd,
4742: zx_po_rec_dist recdist
4743: WHERE recdist.po_header_id(+) = pohzd.trx_id
4744: AND recdist.po_line_location_id(+) = pohzd.trx_line_id
4745: AND recdist.po_distribution_id(+) = pohzd.p_po_distribution_id
4746: AND recdist.tax_rate_id(+) = pohzd.tax_rate_id

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

7070: ,SYSDATE LAST_UPDATE_DATE
7071: ,1 LAST_UPDATE_LOGIN
7072: ,1 LAST_UPDATED_BY
7073: ,1 OBJECT_VERSION_NUMBER
7074: FROM (SELECT /*+ use_nl_with_index(recdist ZX_PO_REC_DIST_N1) */
7075: pohzd.*,
7076: recdist.rec_rate d_rec_rate
7077: FROM (SELECT /*+ NO_EXPAND leading(zxvalerr, poh) use_nl_with_index(zxl, ZX_LINES_U1) use_nl(pod) */
7078: poh.po_header_id,

Line 7137: zx_po_rec_dist recdist

7133: )
7134: AND pod.po_header_id = poll.po_header_id
7135: AND pod.line_location_id = poll.line_location_id
7136: ) pohzd,
7137: zx_po_rec_dist recdist
7138: WHERE recdist.po_header_id(+) = pohzd.trx_id
7139: AND recdist.po_line_location_id(+) = pohzd.trx_line_id
7140: AND recdist.po_distribution_id(+) = pohzd.p_po_distribution_id
7141: AND recdist.tax_rate_id(+) = pohzd.tax_rate_id

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

9409: ,SYSDATE LAST_UPDATE_DATE
9410: ,1 LAST_UPDATE_LOGIN
9411: ,1 LAST_UPDATED_BY
9412: ,1 OBJECT_VERSION_NUMBER
9413: FROM (SELECT /*+ use_nl_with_index(recdist ZX_PO_REC_DIST_N1) */
9414: pohzd.*,
9415: recdist.rec_rate d_rec_rate
9416: FROM (SELECT /*+ NO_EXPAND leading(zxvalerr, poh) use_nl_with_index(zxl, ZX_LINES_U1) use_nl(pod) */
9417: poh.po_header_id,

Line 9477: zx_po_rec_dist recdist

9473: )
9474: AND pod.po_header_id = poll.po_header_id
9475: AND pod.line_location_id = poll.line_location_id
9476: ) pohzd,
9477: zx_po_rec_dist recdist
9478: WHERE recdist.po_header_id(+) = pohzd.trx_id
9479: AND recdist.po_line_location_id(+) = pohzd.trx_line_id
9480: AND recdist.po_distribution_id(+) = pohzd.p_po_distribution_id
9481: AND recdist.tax_rate_id(+) = pohzd.tax_rate_id