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_LINES

Line 96: 'Inserting data into zx_lines_det_factors');

92:
93: IF (g_level_statement >= g_current_runtime_level ) THEN
94: FND_LOG.STRING(g_level_statement,
95: 'ZX.PLSQL.ZX_ON_FLY_TRX_UPGRADE_PKG.upgrade_trx_on_fly_po',
96: 'Inserting data into zx_lines_det_factors');
97: END IF;
98:
99: -- Insert data into zx_lines_det_factors
100: --

Line 99: -- Insert data into zx_lines_det_factors

95: 'ZX.PLSQL.ZX_ON_FLY_TRX_UPGRADE_PKG.upgrade_trx_on_fly_po',
96: 'Inserting data into zx_lines_det_factors');
97: END IF;
98:
99: -- Insert data into zx_lines_det_factors
100: --
101: IF p_upg_trx_info_rec.entity_code = 'PURCHASE_ORDER' THEN
102: INSERT INTO ZX_LINES_DET_FACTORS (
103: EVENT_ID

Line 102: INSERT INTO ZX_LINES_DET_FACTORS (

98:
99: -- Insert data into zx_lines_det_factors
100: --
101: IF p_upg_trx_info_rec.entity_code = 'PURCHASE_ORDER' THEN
102: INSERT INTO ZX_LINES_DET_FACTORS (
103: EVENT_ID
104: ,ACCOUNT_CCID
105: ,ACCOUNT_STRING
106: ,ADJUSTED_DOC_APPLICATION_ID

Line 507: (SELECT 1 FROM zx_lines_det_factors zxl

503: )
504: AND ptp.party_id = DECODE(l_multi_org_flag,'N',l_org_id,poll.org_id)
505: AND ptp.party_type_code = 'OU'
506: AND NOT EXISTS
507: (SELECT 1 FROM zx_lines_det_factors zxl
508: WHERE zxl.APPLICATION_ID = 201
509: AND zxl.EVENT_CLASS_CODE = 'PO_PA'
510: AND zxl.ENTITY_CODE = 'PURCHASE_ORDER'
511: AND zxl.TRX_ID = p_upg_trx_info_rec.trx_id

Line 527: 'Inserting data into zx_lines: tax code');

523:
524: IF (g_level_statement >= g_current_runtime_level ) THEN
525: FND_LOG.STRING(g_level_statement,
526: 'ZX.PLSQL.ZX_ON_FLY_TRX_UPGRADE_PKG.upgrade_trx_on_fly_po',
527: 'Inserting data into zx_lines: tax code');
528: END IF;
529:
530: -- Insert data into zx_lines
531: --

Line 530: -- Insert data into zx_lines

526: 'ZX.PLSQL.ZX_ON_FLY_TRX_UPGRADE_PKG.upgrade_trx_on_fly_po',
527: 'Inserting data into zx_lines: tax code');
528: END IF;
529:
530: -- Insert data into zx_lines
531: --
532: INSERT INTO ZX_LINES(
533: ADJUSTED_DOC_APPLICATION_ID
534: ,ADJUSTED_DOC_DATE

Line 532: INSERT INTO ZX_LINES(

528: END IF;
529:
530: -- Insert data into zx_lines
531: --
532: INSERT INTO ZX_LINES(
533: ADJUSTED_DOC_APPLICATION_ID
534: ,ADJUSTED_DOC_DATE
535: ,ADJUSTED_DOC_ENTITY_CODE
536: ,ADJUSTED_DOC_EVENT_CLASS_CODE

Line 1101: ,zx_lines_s.nextval TAX_LINE_ID

1097: ,NULL TAX_HOLD_RELEASED_CODE
1098: ,taxes.tax_id TAX_ID
1099: ,NULL TAX_JURISDICTION_CODE
1100: ,NULL TAX_JURISDICTION_ID
1101: ,zx_lines_s.nextval TAX_LINE_ID
1102: ,RANK() OVER
1103: (PARTITION BY poh.po_header_id
1104: ORDER BY poll.line_location_id,
1105: atc.tax_id) TAX_LINE_NUMBER

Line 1211: (SELECT 1 FROM zx_lines zxl

1207: AND status.tax(+) = rates.tax
1208: AND status.tax_status_code(+) = rates.tax_status_code
1209: AND status.content_owner_id(+) = rates.content_owner_id
1210: AND NOT EXISTS
1211: (SELECT 1 FROM zx_lines zxl
1212: WHERE zxl.APPLICATION_ID = 201
1213: AND zxl.EVENT_CLASS_CODE = 'PO_PA'
1214: AND zxl.ENTITY_CODE = 'PURCHASE_ORDER'
1215: AND zxl.TRX_ID = p_upg_trx_info_rec.trx_id

Line 1229: 'Inserting data into zx_lines');

1225:
1226: IF (g_level_statement >= g_current_runtime_level ) THEN
1227: FND_LOG.STRING(g_level_statement,
1228: 'ZX.PLSQL.ZX_ON_FLY_TRX_UPGRADE_PKG.upgrade_trx_on_fly_po',
1229: 'Inserting data into zx_lines');
1230: END IF;
1231:
1232: -- Insert data into zx_lines
1233: --

Line 1232: -- Insert data into zx_lines

1228: 'ZX.PLSQL.ZX_ON_FLY_TRX_UPGRADE_PKG.upgrade_trx_on_fly_po',
1229: 'Inserting data into zx_lines');
1230: END IF;
1231:
1232: -- Insert data into zx_lines
1233: --
1234: INSERT INTO ZX_LINES(
1235: ADJUSTED_DOC_APPLICATION_ID
1236: ,ADJUSTED_DOC_DATE

Line 1234: INSERT INTO ZX_LINES(

1230: END IF;
1231:
1232: -- Insert data into zx_lines
1233: --
1234: INSERT INTO ZX_LINES(
1235: ADJUSTED_DOC_APPLICATION_ID
1236: ,ADJUSTED_DOC_DATE
1237: ,ADJUSTED_DOC_ENTITY_CODE
1238: ,ADJUSTED_DOC_EVENT_CLASS_CODE

Line 1809: ,zx_lines_s.nextval TAX_LINE_ID

1805: ,NULL TAX_HOLD_RELEASED_CODE
1806: ,taxes.tax_id TAX_ID
1807: ,NULL TAX_JURISDICTION_CODE
1808: ,NULL TAX_JURISDICTION_ID
1809: ,zx_lines_s.nextval TAX_LINE_ID
1810: ,RANK() OVER
1811: (PARTITION BY poh.po_header_id
1812: ORDER BY poll.line_location_id,
1813: atg.tax_code_id,

Line 1930: (SELECT 1 FROM zx_lines zxl

1926: AND status.tax(+) = rates.tax
1927: AND status.tax_status_code(+) = rates.tax_status_code
1928: AND status.content_owner_id(+) = rates.content_owner_id
1929: AND NOT EXISTS
1930: (SELECT 1 FROM zx_lines zxl
1931: WHERE zxl.APPLICATION_ID = 201
1932: AND zxl.EVENT_CLASS_CODE = 'PO_PA'
1933: AND zxl.ENTITY_CODE = 'PURCHASE_ORDER'
1934: AND zxl.TRX_ID = p_upg_trx_info_rec.trx_id

Line 2326: FROM (SELECT /+ NO_EXPAND leading(poh) use_nl_with_index(zxl, ZX_LINES_U1) use_nl(pod) /

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,
2328: poll.last_update_date poll_last_update_date,
2329: fsp.set_of_books_id,
2330: zxl.*,

Line 2357: zx_lines zxl,

2353: pod.attribute14 p_attribute14,
2354: pod.attribute15 p_attribute15
2355: FROM po_headers_all poh,
2356: financials_system_params_all fsp,
2357: zx_lines zxl,
2358: po_line_locations_all poll,
2359: po_distributions_all pod
2360: WHERE poh.po_header_id = p_upg_trx_info_rec.trx_id
2361: AND NVL(poh.org_id, -99) = NVL(fsp.org_id, -99)

Line 2426: -- Insert data into zx_lines_det_factors

2422: END IF;
2423:
2424: ELSIF p_upg_trx_info_rec.entity_code = 'RELEASE' THEN
2425:
2426: -- Insert data into zx_lines_det_factors
2427: --
2428: INSERT INTO ZX_LINES_DET_FACTORS (
2429: EVENT_ID
2430: ,ACCOUNT_CCID

Line 2428: INSERT INTO ZX_LINES_DET_FACTORS (

2424: ELSIF p_upg_trx_info_rec.entity_code = 'RELEASE' THEN
2425:
2426: -- Insert data into zx_lines_det_factors
2427: --
2428: INSERT INTO ZX_LINES_DET_FACTORS (
2429: EVENT_ID
2430: ,ACCOUNT_CCID
2431: ,ACCOUNT_STRING
2432: ,ADJUSTED_DOC_APPLICATION_ID

Line 2842: (SELECT 1 FROM zx_lines_det_factors zxl

2838: )
2839: AND ptp.party_id = DECODE(l_multi_org_flag,'N',l_org_id,poll.org_id)
2840: AND ptp.party_type_code = 'OU'
2841: AND NOT EXISTS
2842: (SELECT 1 FROM zx_lines_det_factors zxl
2843: WHERE zxl.APPLICATION_ID = 201
2844: AND zxl.EVENT_CLASS_CODE = 'RELEASE'
2845: AND zxl.ENTITY_CODE = 'RELEASE'
2846: AND zxl.TRX_ID = p_upg_trx_info_rec.trx_id

Line 2863: 'Inserting data into zx_lines (Tax Code)');

2859:
2860: IF (g_level_statement >= g_current_runtime_level ) THEN
2861: FND_LOG.STRING(g_level_statement,
2862: 'ZX.PLSQL.ZX_ON_FLY_TRX_UPGRADE_PKG.upgrade_trx_on_fly_po',
2863: 'Inserting data into zx_lines (Tax Code)');
2864: END IF;
2865:
2866: -- Insert data into zx_lines
2867: --

Line 2866: -- Insert data into zx_lines

2862: 'ZX.PLSQL.ZX_ON_FLY_TRX_UPGRADE_PKG.upgrade_trx_on_fly_po',
2863: 'Inserting data into zx_lines (Tax Code)');
2864: END IF;
2865:
2866: -- Insert data into zx_lines
2867: --
2868: INSERT INTO ZX_LINES(
2869: ADJUSTED_DOC_APPLICATION_ID
2870: ,ADJUSTED_DOC_DATE

Line 2868: INSERT INTO ZX_LINES(

2864: END IF;
2865:
2866: -- Insert data into zx_lines
2867: --
2868: INSERT INTO ZX_LINES(
2869: ADJUSTED_DOC_APPLICATION_ID
2870: ,ADJUSTED_DOC_DATE
2871: ,ADJUSTED_DOC_ENTITY_CODE
2872: ,ADJUSTED_DOC_EVENT_CLASS_CODE

Line 3437: ,zx_lines_s.nextval TAX_LINE_ID

3433: ,NULL TAX_HOLD_RELEASED_CODE
3434: ,taxes.tax_id TAX_ID
3435: ,NULL TAX_JURISDICTION_CODE
3436: ,NULL TAX_JURISDICTION_ID
3437: ,zx_lines_s.nextval TAX_LINE_ID
3438: ,RANK() OVER
3439: (PARTITION BY poll.po_release_id
3440: ORDER BY poll.line_location_id,
3441: atc.tax_id) TAX_LINE_NUMBER

Line 3557: (SELECT 1 FROM zx_lines zxl

3553: AND status.tax(+) = rates.tax
3554: AND status.tax_status_code(+) = rates.tax_status_code
3555: AND status.content_owner_id(+) = rates.content_owner_id
3556: AND NOT EXISTS
3557: (SELECT 1 FROM zx_lines zxl
3558: WHERE zxl.APPLICATION_ID = 201
3559: AND zxl.EVENT_CLASS_CODE = 'RELEASE'
3560: AND zxl.ENTITY_CODE = 'RELEASE'
3561: AND zxl.TRX_ID = p_upg_trx_info_rec.trx_id

Line 3578: 'Inserting data into zx_lines(Tax Group)');

3574:
3575: IF (g_level_statement >= g_current_runtime_level ) THEN
3576: FND_LOG.STRING(g_level_statement,
3577: 'ZX.PLSQL.ZX_ON_FLY_TRX_UPGRADE_PKG.upgrade_trx_on_fly_po',
3578: 'Inserting data into zx_lines(Tax Group)');
3579: END IF;
3580:
3581: -- Insert data into zx_lines
3582: --

Line 3581: -- Insert data into zx_lines

3577: 'ZX.PLSQL.ZX_ON_FLY_TRX_UPGRADE_PKG.upgrade_trx_on_fly_po',
3578: 'Inserting data into zx_lines(Tax Group)');
3579: END IF;
3580:
3581: -- Insert data into zx_lines
3582: --
3583: INSERT INTO ZX_LINES(
3584: ADJUSTED_DOC_APPLICATION_ID
3585: ,ADJUSTED_DOC_DATE

Line 3583: INSERT INTO ZX_LINES(

3579: END IF;
3580:
3581: -- Insert data into zx_lines
3582: --
3583: INSERT INTO ZX_LINES(
3584: ADJUSTED_DOC_APPLICATION_ID
3585: ,ADJUSTED_DOC_DATE
3586: ,ADJUSTED_DOC_ENTITY_CODE
3587: ,ADJUSTED_DOC_EVENT_CLASS_CODE

Line 4158: ,zx_lines_s.nextval TAX_LINE_ID

4154: ,NULL TAX_HOLD_RELEASED_CODE
4155: ,taxes.tax_id TAX_ID
4156: ,NULL TAX_JURISDICTION_CODE
4157: ,NULL TAX_JURISDICTION_ID
4158: ,zx_lines_s.nextval TAX_LINE_ID
4159: ,RANK() OVER
4160: (PARTITION BY poll.po_release_id
4161: ORDER BY poll.line_location_id,
4162: atg.tax_code_id,

Line 4288: (SELECT 1 FROM zx_lines zxl

4284: AND status.tax(+) = rates.tax
4285: AND status.tax_status_code(+) = rates.tax_status_code
4286: AND status.content_owner_id(+) = rates.content_owner_id
4287: AND NOT EXISTS
4288: (SELECT 1 FROM zx_lines zxl
4289: WHERE zxl.APPLICATION_ID = 201
4290: AND zxl.EVENT_CLASS_CODE = 'RELEASE'
4291: AND zxl.ENTITY_CODE = 'RELEASE'
4292: AND zxl.TRX_ID = p_upg_trx_info_rec.trx_id

Line 4687: FROM (SELECT /+ NO_EXPAND leading(poh) use_nl_with_index(zxl, ZX_LINES_U1) use_nl(pod) /

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,
4689: poll.last_update_date poll_last_update_date,
4690: fsp.set_of_books_id,
4691: zxl.*,

Line 4719: zx_lines zxl,

4715: pod.attribute15 p_attribute15
4716: FROM po_line_locations_all poll,
4717: po_headers_all poh,
4718: financials_system_params_all fsp,
4719: zx_lines zxl,
4720: po_distributions_all pod
4721: WHERE poll.po_release_id = p_upg_trx_info_rec.trx_id
4722: AND poh.po_header_id = poll.po_header_id
4723: AND NVL(poh.org_id, -99) = NVL(fsp.org_id, -99)

Line 4856: 'Inserting data into zx_lines_det_factors');

4852:
4853: IF (g_level_statement >= g_current_runtime_level ) THEN
4854: FND_LOG.STRING(g_level_statement,
4855: 'ZX.PLSQL.ZX_ON_FLY_TRX_UPGRADE_PKG.upgrade_trx_on_fly_blk_po',
4856: 'Inserting data into zx_lines_det_factors');
4857: END IF;
4858: -- Insert data into zx_lines_det_factors
4859: --
4860: INSERT INTO ZX_LINES_DET_FACTORS (

Line 4858: -- Insert data into zx_lines_det_factors

4854: FND_LOG.STRING(g_level_statement,
4855: 'ZX.PLSQL.ZX_ON_FLY_TRX_UPGRADE_PKG.upgrade_trx_on_fly_blk_po',
4856: 'Inserting data into zx_lines_det_factors');
4857: END IF;
4858: -- Insert data into zx_lines_det_factors
4859: --
4860: INSERT INTO ZX_LINES_DET_FACTORS (
4861: EVENT_ID
4862: ,ACCOUNT_CCID

Line 4860: INSERT INTO ZX_LINES_DET_FACTORS (

4856: 'Inserting data into zx_lines_det_factors');
4857: END IF;
4858: -- Insert data into zx_lines_det_factors
4859: --
4860: INSERT INTO ZX_LINES_DET_FACTORS (
4861: EVENT_ID
4862: ,ACCOUNT_CCID
4863: ,ACCOUNT_STRING
4864: ,ADJUSTED_DOC_APPLICATION_ID

Line 5284: 'Inserting data into zx_lines(Tax Code)');

5280:
5281: IF (g_level_statement >= g_current_runtime_level ) THEN
5282: FND_LOG.STRING(g_level_statement,
5283: 'ZX.PLSQL.ZX_ON_FLY_TRX_UPGRADE_PKG.upgrade_trx_on_fly_blk_po',
5284: 'Inserting data into zx_lines(Tax Code)');
5285: END IF;
5286:
5287: -- Insert data into zx_lines
5288: --

Line 5287: -- Insert data into zx_lines

5283: 'ZX.PLSQL.ZX_ON_FLY_TRX_UPGRADE_PKG.upgrade_trx_on_fly_blk_po',
5284: 'Inserting data into zx_lines(Tax Code)');
5285: END IF;
5286:
5287: -- Insert data into zx_lines
5288: --
5289:
5290: INSERT INTO ZX_LINES(
5291: ADJUSTED_DOC_APPLICATION_ID

Line 5290: INSERT INTO ZX_LINES(

5286:
5287: -- Insert data into zx_lines
5288: --
5289:
5290: INSERT INTO ZX_LINES(
5291: ADJUSTED_DOC_APPLICATION_ID
5292: ,ADJUSTED_DOC_DATE
5293: ,ADJUSTED_DOC_ENTITY_CODE
5294: ,ADJUSTED_DOC_EVENT_CLASS_CODE

Line 5859: ,zx_lines_s.nextval TAX_LINE_ID

5855: ,NULL TAX_HOLD_RELEASED_CODE
5856: ,taxes.tax_id TAX_ID
5857: ,NULL TAX_JURISDICTION_CODE
5858: ,NULL TAX_JURISDICTION_ID
5859: ,zx_lines_s.nextval TAX_LINE_ID
5860: ,RANK() OVER
5861: (PARTITION BY poh.po_header_id
5862: ORDER BY poll.line_location_id,
5863: atc.tax_id) TAX_LINE_NUMBER

Line 5979: 'ZX_LINES Number of Rows Inserted(Tax Code) = ' || TO_CHAR(SQL%ROWCOUNT));

5975:
5976: IF (g_level_statement >= g_current_runtime_level ) THEN
5977: FND_LOG.STRING(g_level_statement,
5978: 'ZX.PLSQL.ZX_ON_FLY_TRX_UPGRADE_PO_PKG.upgrade_trx_on_fly_blk_po',
5979: 'ZX_LINES Number of Rows Inserted(Tax Code) = ' || TO_CHAR(SQL%ROWCOUNT));
5980: END IF;
5981:
5982: IF (g_level_statement >= g_current_runtime_level ) THEN
5983: FND_LOG.STRING(g_level_statement,

Line 5985: 'Inserting data into zx_lines(Tax Group)');

5981:
5982: IF (g_level_statement >= g_current_runtime_level ) THEN
5983: FND_LOG.STRING(g_level_statement,
5984: 'ZX.PLSQL.ZX_ON_FLY_TRX_UPGRADE_PKG.upgrade_trx_on_fly_blk_po',
5985: 'Inserting data into zx_lines(Tax Group)');
5986: END IF;
5987:
5988: -- Insert data into zx_lines
5989: --

Line 5988: -- Insert data into zx_lines

5984: 'ZX.PLSQL.ZX_ON_FLY_TRX_UPGRADE_PKG.upgrade_trx_on_fly_blk_po',
5985: 'Inserting data into zx_lines(Tax Group)');
5986: END IF;
5987:
5988: -- Insert data into zx_lines
5989: --
5990:
5991: INSERT INTO ZX_LINES(
5992: ADJUSTED_DOC_APPLICATION_ID

Line 5991: INSERT INTO ZX_LINES(

5987:
5988: -- Insert data into zx_lines
5989: --
5990:
5991: INSERT INTO ZX_LINES(
5992: ADJUSTED_DOC_APPLICATION_ID
5993: ,ADJUSTED_DOC_DATE
5994: ,ADJUSTED_DOC_ENTITY_CODE
5995: ,ADJUSTED_DOC_EVENT_CLASS_CODE

Line 6566: ,zx_lines_s.nextval TAX_LINE_ID

6562: ,NULL TAX_HOLD_RELEASED_CODE
6563: ,taxes.tax_id TAX_ID
6564: ,NULL TAX_JURISDICTION_CODE
6565: ,NULL TAX_JURISDICTION_ID
6566: ,zx_lines_s.nextval TAX_LINE_ID
6567: ,RANK() OVER
6568: (PARTITION BY poh.po_header_id
6569: ORDER BY poll.line_location_id,
6570: atg.tax_code_id,

Line 6695: 'ZX_LINES Number of Rows Inserted(Tax Group) = ' || TO_CHAR(SQL%ROWCOUNT));

6691:
6692: IF (g_level_statement >= g_current_runtime_level ) THEN
6693: FND_LOG.STRING(g_level_statement,
6694: 'ZX.PLSQL.ZX_ON_FLY_TRX_UPGRADE_PO_PKG.upgrade_trx_on_fly_blk_po',
6695: 'ZX_LINES Number of Rows Inserted(Tax Group) = ' || TO_CHAR(SQL%ROWCOUNT));
6696: END IF;
6697:
6698: -- COMMIT;
6699:

Line 7077: FROM (SELECT /+ NO_EXPAND leading(zxvalerr, poh) use_nl_with_index(zxl, ZX_LINES_U1) use_nl(pod) /

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,
7079: poll.last_update_date poll_last_update_date,
7080: fsp.set_of_books_id,
7081: zxl.*,

Line 7114: zx_lines zxl,

7110: and other_doc_event_class_code = 'PO_PA'
7111: ) zxvalerr, --Bug 5187701
7112: po_headers_all poh,
7113: financials_system_params_all fsp,
7114: zx_lines zxl,
7115: po_line_locations_all poll,
7116: po_distributions_all pod
7117: WHERE poh.po_header_id = zxvalerr.other_doc_trx_id
7118: AND NVL(poh.org_id, -99) = NVL(fsp.org_id, -99)

Line 7172: -- Insert data into zx_lines_det_factors

7168: END IF;
7169:
7170: -- bug 5166217 : Do bulk migration for RELEASE
7171: --
7172: -- Insert data into zx_lines_det_factors
7173: --
7174: INSERT INTO ZX_LINES_DET_FACTORS (
7175: EVENT_ID
7176: ,ACCOUNT_CCID

Line 7174: INSERT INTO ZX_LINES_DET_FACTORS (

7170: -- bug 5166217 : Do bulk migration for RELEASE
7171: --
7172: -- Insert data into zx_lines_det_factors
7173: --
7174: INSERT INTO ZX_LINES_DET_FACTORS (
7175: EVENT_ID
7176: ,ACCOUNT_CCID
7177: ,ACCOUNT_STRING
7178: ,ADJUSTED_DOC_APPLICATION_ID

Line 7605: 'Inserting data into zx_lines(Tax Code)');

7601:
7602: IF (g_level_statement >= g_current_runtime_level ) THEN
7603: FND_LOG.STRING(g_level_statement,
7604: 'ZX.PLSQL.ZX_ON_FLY_TRX_UPGRADE_PKG.upgrade_trx_on_fly_blk_po',
7605: 'Inserting data into zx_lines(Tax Code)');
7606: END IF;
7607:
7608: -- Insert data into zx_lines
7609: --

Line 7608: -- Insert data into zx_lines

7604: 'ZX.PLSQL.ZX_ON_FLY_TRX_UPGRADE_PKG.upgrade_trx_on_fly_blk_po',
7605: 'Inserting data into zx_lines(Tax Code)');
7606: END IF;
7607:
7608: -- Insert data into zx_lines
7609: --
7610:
7611: INSERT INTO ZX_LINES(
7612: ADJUSTED_DOC_APPLICATION_ID

Line 7611: INSERT INTO ZX_LINES(

7607:
7608: -- Insert data into zx_lines
7609: --
7610:
7611: INSERT INTO ZX_LINES(
7612: ADJUSTED_DOC_APPLICATION_ID
7613: ,ADJUSTED_DOC_DATE
7614: ,ADJUSTED_DOC_ENTITY_CODE
7615: ,ADJUSTED_DOC_EVENT_CLASS_CODE

Line 8180: ,zx_lines_s.nextval TAX_LINE_ID

8176: ,NULL TAX_HOLD_RELEASED_CODE
8177: ,taxes.tax_id TAX_ID
8178: ,NULL TAX_JURISDICTION_CODE
8179: ,NULL TAX_JURISDICTION_ID
8180: ,zx_lines_s.nextval TAX_LINE_ID
8181: ,RANK() OVER
8182: (PARTITION BY poll.po_release_id
8183: ORDER BY poll.line_location_id,
8184: atc.tax_id) TAX_LINE_NUMBER

Line 8309: 'ZX_LINES Number of Rows Inserted(Tax Code) = ' || TO_CHAR(SQL%ROWCOUNT));

8305:
8306: IF (g_level_statement >= g_current_runtime_level ) THEN
8307: FND_LOG.STRING(g_level_statement,
8308: 'ZX.PLSQL.ZX_ON_FLY_TRX_UPGRADE_PO_PKG.upgrade_trx_on_fly_blk_po',
8309: 'ZX_LINES Number of Rows Inserted(Tax Code) = ' || TO_CHAR(SQL%ROWCOUNT));
8310: END IF;
8311:
8312: IF (g_level_statement >= g_current_runtime_level ) THEN
8313: FND_LOG.STRING(g_level_statement,

Line 8315: 'Inserting data into zx_lines(Tax Group)');

8311:
8312: IF (g_level_statement >= g_current_runtime_level ) THEN
8313: FND_LOG.STRING(g_level_statement,
8314: 'ZX.PLSQL.ZX_ON_FLY_TRX_UPGRADE_PKG.upgrade_trx_on_fly_blk_po',
8315: 'Inserting data into zx_lines(Tax Group)');
8316: END IF;
8317:
8318: -- Insert data into zx_lines
8319: --

Line 8318: -- Insert data into zx_lines

8314: 'ZX.PLSQL.ZX_ON_FLY_TRX_UPGRADE_PKG.upgrade_trx_on_fly_blk_po',
8315: 'Inserting data into zx_lines(Tax Group)');
8316: END IF;
8317:
8318: -- Insert data into zx_lines
8319: --
8320:
8321: INSERT INTO ZX_LINES(
8322: ADJUSTED_DOC_APPLICATION_ID

Line 8321: INSERT INTO ZX_LINES(

8317:
8318: -- Insert data into zx_lines
8319: --
8320:
8321: INSERT INTO ZX_LINES(
8322: ADJUSTED_DOC_APPLICATION_ID
8323: ,ADJUSTED_DOC_DATE
8324: ,ADJUSTED_DOC_ENTITY_CODE
8325: ,ADJUSTED_DOC_EVENT_CLASS_CODE

Line 8896: ,zx_lines_s.nextval TAX_LINE_ID

8892: ,NULL TAX_HOLD_RELEASED_CODE
8893: ,taxes.tax_id TAX_ID
8894: ,NULL TAX_JURISDICTION_CODE
8895: ,NULL TAX_JURISDICTION_ID
8896: ,zx_lines_s.nextval TAX_LINE_ID
8897: ,RANK() OVER
8898: (PARTITION BY poll.po_release_id
8899: ORDER BY poll.line_location_id,
8900: atg.tax_code_id,

Line 9035: 'ZX_LINES Number of Rows Inserted(Tax Group) = ' || TO_CHAR(SQL%ROWCOUNT));

9031:
9032: IF (g_level_statement >= g_current_runtime_level ) THEN
9033: FND_LOG.STRING(g_level_statement,
9034: 'ZX.PLSQL.ZX_ON_FLY_TRX_UPGRADE_PO_PKG.upgrade_trx_on_fly_blk_po',
9035: 'ZX_LINES Number of Rows Inserted(Tax Group) = ' || TO_CHAR(SQL%ROWCOUNT));
9036: END IF;
9037:
9038: -- COMMIT;
9039:

Line 9416: FROM (SELECT /+ NO_EXPAND leading(zxvalerr, poh) use_nl_with_index(zxl, ZX_LINES_U1) use_nl(pod) /

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,
9418: poll.last_update_date poll_last_update_date,
9419: fsp.set_of_books_id,
9420: zxl.*,

Line 9454: zx_lines zxl,

9450: zxvalerr,
9451: po_line_locations_all poll,
9452: po_headers_all poh,
9453: financials_system_params_all fsp,
9454: zx_lines zxl,
9455: po_distributions_all pod
9456: WHERE poll.po_release_id = zxvalerr.other_doc_trx_id
9457: AND poh.po_header_id = poll.po_header_id
9458: AND NVL(poh.org_id, -99) = NVL(fsp.org_id, -99)