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

1916:
1917: IF (g_level_statement >= g_current_runtime_level ) THEN
1918: FND_LOG.STRING(g_level_statement,
1919: 'ZX.PLSQL.ZX_ON_FLY_TRX_UPGRADE_PKG.upgrade_trx_on_fly_po',
1920: 'Inserting data into zx_rec_nrec_dist');
1921: END IF;
1922:
1923: -- Insert data into zx_rec_nrec_dist
1924: --

Line 1923: -- Insert data into zx_rec_nrec_dist

1919: 'ZX.PLSQL.ZX_ON_FLY_TRX_UPGRADE_PKG.upgrade_trx_on_fly_po',
1920: 'Inserting data into zx_rec_nrec_dist');
1921: END IF;
1922:
1923: -- Insert data into zx_rec_nrec_dist
1924: --
1925: INSERT INTO ZX_REC_NREC_DIST(
1926: TAX_LINE_ID
1927: ,REC_NREC_TAX_DIST_ID

Line 1925: INSERT INTO ZX_REC_NREC_DIST(

1921: END IF;
1922:
1923: -- Insert data into zx_rec_nrec_dist
1924: --
1925: INSERT INTO ZX_REC_NREC_DIST(
1926: TAX_LINE_ID
1927: ,REC_NREC_TAX_DIST_ID
1928: ,REC_NREC_TAX_DIST_NUMBER
1929: ,APPLICATION_ID

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

2341: AND rates.record_type_code(+) = 'MIGRATED'
2342: AND rates.percentage_rate(+) = NVL(NVL(pohzd.p_recovery_rate, pohzd.d_rec_rate),0)
2343: AND rates.tax_rate_code(+) NOT LIKE 'AD_HOC_RECOVERY%'
2344: AND NOT EXISTS
2345: (SELECT 1 FROM zx_rec_nrec_dist zxdist
2346: WHERE zxdist.application_id = 201
2347: AND zxdist.entity_code = 'PURCHASE_ORDER'
2348: AND zxdist.event_class_code = 'PO_PA'
2349: AND zxdist.trx_id = p_upg_trx_info_rec.trx_id

Line 4254: 'Inserting data into zx_rec_nrec_dist');

4250:
4251: IF (g_level_statement >= g_current_runtime_level ) THEN
4252: FND_LOG.STRING(g_level_statement,
4253: 'ZX.PLSQL.ZX_ON_FLY_TRX_UPGRADE_PKG.upgrade_trx_on_fly_po',
4254: 'Inserting data into zx_rec_nrec_dist');
4255: END IF;
4256:
4257: -- Insert data into zx_rec_nrec_dist
4258: --

Line 4257: -- Insert data into zx_rec_nrec_dist

4253: 'ZX.PLSQL.ZX_ON_FLY_TRX_UPGRADE_PKG.upgrade_trx_on_fly_po',
4254: 'Inserting data into zx_rec_nrec_dist');
4255: END IF;
4256:
4257: -- Insert data into zx_rec_nrec_dist
4258: --
4259: INSERT INTO ZX_REC_NREC_DIST(
4260: TAX_LINE_ID
4261: ,REC_NREC_TAX_DIST_ID

Line 4259: INSERT INTO ZX_REC_NREC_DIST(

4255: END IF;
4256:
4257: -- Insert data into zx_rec_nrec_dist
4258: --
4259: INSERT INTO ZX_REC_NREC_DIST(
4260: TAX_LINE_ID
4261: ,REC_NREC_TAX_DIST_ID
4262: ,REC_NREC_TAX_DIST_NUMBER
4263: ,APPLICATION_ID

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

4675: AND rates.record_type_code(+) = 'MIGRATED'
4676: AND rates.percentage_rate(+) = NVL(NVL(pohzd.p_recovery_rate, pohzd.d_rec_rate),0)
4677: AND rates.tax_rate_code(+) NOT LIKE 'AD_HOC_RECOVERY%'
4678: AND NOT EXISTS
4679: (SELECT 1 FROM zx_rec_nrec_dist zxdist
4680: WHERE zxdist.application_id = 201
4681: AND zxdist.entity_code = 'RELEASE'
4682: AND zxdist.event_class_code = 'RELEASE'
4683: AND zxdist.trx_id = p_upg_trx_info_rec.trx_id

Line 6617: 'Inserting data into zx_rec_nrec_dist');

6613:
6614: IF (g_level_statement >= g_current_runtime_level ) THEN
6615: FND_LOG.STRING(g_level_statement,
6616: 'ZX.PLSQL.ZX_ON_FLY_TRX_UPGRADE_PKG.upgrade_trx_on_fly_blk_po',
6617: 'Inserting data into zx_rec_nrec_dist');
6618: END IF;
6619:
6620: -- Insert data into zx_rec_nrec_dist
6621: --

Line 6620: -- Insert data into zx_rec_nrec_dist

6616: 'ZX.PLSQL.ZX_ON_FLY_TRX_UPGRADE_PKG.upgrade_trx_on_fly_blk_po',
6617: 'Inserting data into zx_rec_nrec_dist');
6618: END IF;
6619:
6620: -- Insert data into zx_rec_nrec_dist
6621: --
6622: INSERT INTO ZX_REC_NREC_DIST(
6623: TAX_LINE_ID
6624: ,REC_NREC_TAX_DIST_ID

Line 6622: INSERT INTO ZX_REC_NREC_DIST(

6618: END IF;
6619:
6620: -- Insert data into zx_rec_nrec_dist
6621: --
6622: INSERT INTO ZX_REC_NREC_DIST(
6623: TAX_LINE_ID
6624: ,REC_NREC_TAX_DIST_ID
6625: ,REC_NREC_TAX_DIST_NUMBER
6626: ,APPLICATION_ID

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

8927:
8928: IF (g_level_statement >= g_current_runtime_level ) THEN
8929: FND_LOG.STRING(g_level_statement,
8930: 'ZX.PLSQL.ZX_ON_FLY_TRX_UPGRADE_PKG.upgrade_trx_on_fly_blk_po',
8931: 'Inserting data into zx_rec_nrec_dist');
8932: END IF;
8933:
8934: -- Insert data into zx_rec_nrec_dist
8935: --

Line 8934: -- Insert data into zx_rec_nrec_dist

8930: 'ZX.PLSQL.ZX_ON_FLY_TRX_UPGRADE_PKG.upgrade_trx_on_fly_blk_po',
8931: 'Inserting data into zx_rec_nrec_dist');
8932: END IF;
8933:
8934: -- Insert data into zx_rec_nrec_dist
8935: --
8936: INSERT INTO ZX_REC_NREC_DIST(
8937: TAX_LINE_ID
8938: ,REC_NREC_TAX_DIST_ID

Line 8936: INSERT INTO ZX_REC_NREC_DIST(

8932: END IF;
8933:
8934: -- Insert data into zx_rec_nrec_dist
8935: --
8936: INSERT INTO ZX_REC_NREC_DIST(
8937: TAX_LINE_ID
8938: ,REC_NREC_TAX_DIST_ID
8939: ,REC_NREC_TAX_DIST_NUMBER
8940: ,APPLICATION_ID

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