DBA Data[Home] [Help]

APPS.ZX_ON_FLY_TRX_UPGRADE_PO_PKG dependencies on ZX_REC_NREC_DIST_S

Line 2095: ,zx_rec_nrec_dist_s.nextval REC_NREC_TAX_DIST_ID

2091: ,LAST_UPDATED_BY
2092: ,OBJECT_VERSION_NUMBER)
2093: SELECT /*+ NO_EXPAND leading(pohzd) use_nl(fc, rates)*/
2094: pohzd.tax_line_id TAX_LINE_ID
2095: ,zx_rec_nrec_dist_s.nextval REC_NREC_TAX_DIST_ID
2096: ,DECODE(tmp.rec_flag,
2097: 'Y', (RANK() OVER (PARTITION BY pohzd.po_header_id,
2098: pohzd.p_po_distribution_id
2099: ORDER BY

Line 4457: ,zx_rec_nrec_dist_s.NEXTVAL REC_NREC_TAX_DIST_ID

4453: ,LAST_UPDATED_BY
4454: ,OBJECT_VERSION_NUMBER)
4455: SELECT /*+ NO_EXPAND leading(pohzd) use_nl(fc, rates)*/
4456: pohzd.tax_line_id TAX_LINE_ID
4457: ,zx_rec_nrec_dist_s.NEXTVAL REC_NREC_TAX_DIST_ID
4458: ,DECODE(tmp.rec_flag,
4459: 'Y', (RANK() OVER (PARTITION BY pohzd.trx_id,
4460: pohzd.p_po_distribution_id
4461: ORDER BY

Line 6848: ,zx_rec_nrec_dist_s.nextval REC_NREC_TAX_DIST_ID

6844: ,LAST_UPDATED_BY
6845: ,OBJECT_VERSION_NUMBER)
6846: SELECT /*+ NO_EXPAND leading(pohzd) use_nl(fc, rates)*/
6847: pohzd.tax_line_id TAX_LINE_ID
6848: ,zx_rec_nrec_dist_s.nextval REC_NREC_TAX_DIST_ID
6849: ,DECODE(tmp.rec_flag,
6850: 'Y', (RANK() OVER (PARTITION BY pohzd.po_header_id,
6851: pohzd.p_po_distribution_id
6852: ORDER BY

Line 9188: ,zx_rec_nrec_dist_s.NEXTVAL REC_NREC_TAX_DIST_ID

9184: ,LAST_UPDATED_BY
9185: ,OBJECT_VERSION_NUMBER)
9186: SELECT /*+ NO_EXPAND leading(pohzd) use_nl(fc, rates)*/
9187: pohzd.tax_line_id TAX_LINE_ID
9188: ,zx_rec_nrec_dist_s.NEXTVAL REC_NREC_TAX_DIST_ID
9189: ,DECODE(tmp.rec_flag,
9190: 'Y', (RANK() OVER (PARTITION BY pohzd.trx_id,
9191: pohzd.p_po_distribution_id
9192: ORDER BY