eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.ZX_ON_FLY_TRX_UPGRADE_PO_PKG dependencies on ZX_REC_NREC_DIST

Line 1950: 'Inserting data into zx_rec_nrec_dist');

1946:
1947: IF (g_level_statement >= g_current_runtime_level ) THEN
1948: FND_LOG.STRING(g_level_statement,
1949: 'ZX.PLSQL.ZX_ON_FLY_TRX_UPGRADE_PKG.upgrade_trx_on_fly_po',
1950: 'Inserting data into zx_rec_nrec_dist');
1951: END IF;
1952:
1953: -- Insert data into zx_rec_nrec_dist
1954: --

Line 1953: -- Insert data into zx_rec_nrec_dist

1949: 'ZX.PLSQL.ZX_ON_FLY_TRX_UPGRADE_PKG.upgrade_trx_on_fly_po',
1950: 'Inserting data into zx_rec_nrec_dist');
1951: END IF;
1952:
1953: -- Insert data into zx_rec_nrec_dist
1954: --
1955: INSERT INTO ZX_REC_NREC_DIST(
1956: TAX_LINE_ID
1957: ,REC_NREC_TAX_DIST_ID

Line 1955: INSERT INTO ZX_REC_NREC_DIST(

1951: END IF;
1952:
1953: -- Insert data into zx_rec_nrec_dist
1954: --
1955: INSERT INTO ZX_REC_NREC_DIST(
1956: TAX_LINE_ID
1957: ,REC_NREC_TAX_DIST_ID
1958: ,REC_NREC_TAX_DIST_NUMBER
1959: ,APPLICATION_ID

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 2407: (SELECT 1 FROM zx_rec_nrec_dist zxdist

2403: AND rates.record_type_code(+) = 'MIGRATED'
2404: AND rates.percentage_rate(+) = NVL(NVL(pohzd.p_recovery_rate, pohzd.d_rec_rate),0)
2405: AND rates.tax_rate_code(+) NOT LIKE 'AD_HOC_RECOVERY%'
2406: AND NOT EXISTS
2407: (SELECT 1 FROM zx_rec_nrec_dist zxdist
2408: WHERE zxdist.application_id = 201
2409: AND zxdist.entity_code = 'PURCHASE_ORDER'
2410: AND zxdist.event_class_code = 'PO_PA'
2411: AND zxdist.trx_id = p_upg_trx_info_rec.trx_id

Line 4312: 'Inserting data into zx_rec_nrec_dist');

4308:
4309: IF (g_level_statement >= g_current_runtime_level ) THEN
4310: FND_LOG.STRING(g_level_statement,
4311: 'ZX.PLSQL.ZX_ON_FLY_TRX_UPGRADE_PKG.upgrade_trx_on_fly_po',
4312: 'Inserting data into zx_rec_nrec_dist');
4313: END IF;
4314:
4315: -- Insert data into zx_rec_nrec_dist
4316: --

Line 4315: -- Insert data into zx_rec_nrec_dist

4311: 'ZX.PLSQL.ZX_ON_FLY_TRX_UPGRADE_PKG.upgrade_trx_on_fly_po',
4312: 'Inserting data into zx_rec_nrec_dist');
4313: END IF;
4314:
4315: -- Insert data into zx_rec_nrec_dist
4316: --
4317: INSERT INTO ZX_REC_NREC_DIST(
4318: TAX_LINE_ID
4319: ,REC_NREC_TAX_DIST_ID

Line 4317: INSERT INTO ZX_REC_NREC_DIST(

4313: END IF;
4314:
4315: -- Insert data into zx_rec_nrec_dist
4316: --
4317: INSERT INTO ZX_REC_NREC_DIST(
4318: TAX_LINE_ID
4319: ,REC_NREC_TAX_DIST_ID
4320: ,REC_NREC_TAX_DIST_NUMBER
4321: ,APPLICATION_ID

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 4769: (SELECT 1 FROM zx_rec_nrec_dist zxdist

4765: AND rates.record_type_code(+) = 'MIGRATED'
4766: AND rates.percentage_rate(+) = NVL(NVL(pohzd.p_recovery_rate, pohzd.d_rec_rate),0)
4767: AND rates.tax_rate_code(+) NOT LIKE 'AD_HOC_RECOVERY%'
4768: AND NOT EXISTS
4769: (SELECT 1 FROM zx_rec_nrec_dist zxdist
4770: WHERE zxdist.application_id = 201
4771: AND zxdist.entity_code = 'RELEASE'
4772: AND zxdist.event_class_code = 'RELEASE'
4773: AND zxdist.trx_id = p_upg_trx_info_rec.trx_id

Line 6703: 'Inserting data into zx_rec_nrec_dist');

6699:
6700: IF (g_level_statement >= g_current_runtime_level ) THEN
6701: FND_LOG.STRING(g_level_statement,
6702: 'ZX.PLSQL.ZX_ON_FLY_TRX_UPGRADE_PKG.upgrade_trx_on_fly_blk_po',
6703: 'Inserting data into zx_rec_nrec_dist');
6704: END IF;
6705:
6706: -- Insert data into zx_rec_nrec_dist
6707: --

Line 6706: -- Insert data into zx_rec_nrec_dist

6702: 'ZX.PLSQL.ZX_ON_FLY_TRX_UPGRADE_PKG.upgrade_trx_on_fly_blk_po',
6703: 'Inserting data into zx_rec_nrec_dist');
6704: END IF;
6705:
6706: -- Insert data into zx_rec_nrec_dist
6707: --
6708: INSERT INTO ZX_REC_NREC_DIST(
6709: TAX_LINE_ID
6710: ,REC_NREC_TAX_DIST_ID

Line 6708: INSERT INTO ZX_REC_NREC_DIST(

6704: END IF;
6705:
6706: -- Insert data into zx_rec_nrec_dist
6707: --
6708: INSERT INTO ZX_REC_NREC_DIST(
6709: TAX_LINE_ID
6710: ,REC_NREC_TAX_DIST_ID
6711: ,REC_NREC_TAX_DIST_NUMBER
6712: ,APPLICATION_ID

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 9043: 'Inserting data into zx_rec_nrec_dist');

9039:
9040: IF (g_level_statement >= g_current_runtime_level ) THEN
9041: FND_LOG.STRING(g_level_statement,
9042: 'ZX.PLSQL.ZX_ON_FLY_TRX_UPGRADE_PKG.upgrade_trx_on_fly_blk_po',
9043: 'Inserting data into zx_rec_nrec_dist');
9044: END IF;
9045:
9046: -- Insert data into zx_rec_nrec_dist
9047: --

Line 9046: -- Insert data into zx_rec_nrec_dist

9042: 'ZX.PLSQL.ZX_ON_FLY_TRX_UPGRADE_PKG.upgrade_trx_on_fly_blk_po',
9043: 'Inserting data into zx_rec_nrec_dist');
9044: END IF;
9045:
9046: -- Insert data into zx_rec_nrec_dist
9047: --
9048: INSERT INTO ZX_REC_NREC_DIST(
9049: TAX_LINE_ID
9050: ,REC_NREC_TAX_DIST_ID

Line 9048: INSERT INTO ZX_REC_NREC_DIST(

9044: END IF;
9045:
9046: -- Insert data into zx_rec_nrec_dist
9047: --
9048: INSERT INTO ZX_REC_NREC_DIST(
9049: TAX_LINE_ID
9050: ,REC_NREC_TAX_DIST_ID
9051: ,REC_NREC_TAX_DIST_NUMBER
9052: ,APPLICATION_ID

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