DBA Data[Home] [Help]

APPS.ZX_ON_FLY_TRX_UPGRADE_PO_PKG dependencies on ZX_REC_NREC_DIST_S

Line 2065: ,zx_rec_nrec_dist_s.nextval REC_NREC_TAX_DIST_ID

2061: ,LAST_UPDATED_BY
2062: ,OBJECT_VERSION_NUMBER)
2063: SELECT /*+ NO_EXPAND leading(pohzd) use_nl(fc, rates)*/
2064: pohzd.tax_line_id TAX_LINE_ID
2065: ,zx_rec_nrec_dist_s.nextval REC_NREC_TAX_DIST_ID
2066: ,DECODE(tmp.rec_flag,
2067: 'Y', (RANK() OVER (PARTITION BY pohzd.po_header_id,
2068: pohzd.p_po_distribution_id
2069: ORDER BY

Line 4399: ,zx_rec_nrec_dist_s.NEXTVAL REC_NREC_TAX_DIST_ID

4395: ,LAST_UPDATED_BY
4396: ,OBJECT_VERSION_NUMBER)
4397: SELECT /*+ NO_EXPAND leading(pohzd) use_nl(fc, rates)*/
4398: pohzd.tax_line_id TAX_LINE_ID
4399: ,zx_rec_nrec_dist_s.NEXTVAL REC_NREC_TAX_DIST_ID
4400: ,DECODE(tmp.rec_flag,
4401: 'Y', (RANK() OVER (PARTITION BY pohzd.trx_id,
4402: pohzd.p_po_distribution_id
4403: ORDER BY

Line 6762: ,zx_rec_nrec_dist_s.nextval REC_NREC_TAX_DIST_ID

6758: ,LAST_UPDATED_BY
6759: ,OBJECT_VERSION_NUMBER)
6760: SELECT /*+ NO_EXPAND leading(pohzd) use_nl(fc, rates)*/
6761: pohzd.tax_line_id TAX_LINE_ID
6762: ,zx_rec_nrec_dist_s.nextval REC_NREC_TAX_DIST_ID
6763: ,DECODE(tmp.rec_flag,
6764: 'Y', (RANK() OVER (PARTITION BY pohzd.po_header_id,
6765: pohzd.p_po_distribution_id
6766: ORDER BY

Line 9076: ,zx_rec_nrec_dist_s.NEXTVAL REC_NREC_TAX_DIST_ID

9072: ,LAST_UPDATED_BY
9073: ,OBJECT_VERSION_NUMBER)
9074: SELECT /*+ NO_EXPAND leading(pohzd) use_nl(fc, rates)*/
9075: pohzd.tax_line_id TAX_LINE_ID
9076: ,zx_rec_nrec_dist_s.NEXTVAL REC_NREC_TAX_DIST_ID
9077: ,DECODE(tmp.rec_flag,
9078: 'Y', (RANK() OVER (PARTITION BY pohzd.trx_id,
9079: pohzd.p_po_distribution_id
9080: ORDER BY