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 61: 'Inserting data into zx_lines_det_factors');

57:
58: IF (g_level_statement >= g_current_runtime_level ) THEN
59: FND_LOG.STRING(g_level_statement,
60: 'ZX.PLSQL.ZX_ON_FLY_TRX_UPGRADE_PKG.upgrade_trx_on_fly_po',
61: 'Inserting data into zx_lines_det_factors');
62: END IF;
63:
64: -- Insert data into zx_lines_det_factors
65: --

Line 64: -- Insert data into zx_lines_det_factors

60: 'ZX.PLSQL.ZX_ON_FLY_TRX_UPGRADE_PKG.upgrade_trx_on_fly_po',
61: 'Inserting data into zx_lines_det_factors');
62: END IF;
63:
64: -- Insert data into zx_lines_det_factors
65: --
66: IF p_upg_trx_info_rec.entity_code = 'PURCHASE_ORDER' THEN
67: INSERT INTO ZX_LINES_DET_FACTORS (
68: EVENT_ID

Line 67: INSERT INTO ZX_LINES_DET_FACTORS (

63:
64: -- Insert data into zx_lines_det_factors
65: --
66: IF p_upg_trx_info_rec.entity_code = 'PURCHASE_ORDER' THEN
67: INSERT INTO ZX_LINES_DET_FACTORS (
68: EVENT_ID
69: ,ACCOUNT_CCID
70: ,ACCOUNT_STRING
71: ,ADJUSTED_DOC_APPLICATION_ID

Line 473: (SELECT 1 FROM zx_lines_det_factors zxl

469: )
470: AND ptp.party_id = DECODE(l_multi_org_flag,'N',l_org_id,poll.org_id)
471: AND ptp.party_type_code = 'OU'
472: AND NOT EXISTS
473: (SELECT 1 FROM zx_lines_det_factors zxl
474: WHERE zxl.APPLICATION_ID = 201
475: AND zxl.EVENT_CLASS_CODE = 'PO_PA'
476: AND zxl.ENTITY_CODE = 'PURCHASE_ORDER'
477: AND zxl.TRX_ID = p_upg_trx_info_rec.trx_id

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

489:
490: IF (g_level_statement >= g_current_runtime_level ) THEN
491: FND_LOG.STRING(g_level_statement,
492: 'ZX.PLSQL.ZX_ON_FLY_TRX_UPGRADE_PKG.upgrade_trx_on_fly_po',
493: 'Inserting data into zx_lines: tax code');
494: END IF;
495:
496: -- Insert data into zx_lines
497: --

Line 496: -- Insert data into zx_lines

492: 'ZX.PLSQL.ZX_ON_FLY_TRX_UPGRADE_PKG.upgrade_trx_on_fly_po',
493: 'Inserting data into zx_lines: tax code');
494: END IF;
495:
496: -- Insert data into zx_lines
497: --
498: INSERT INTO ZX_LINES(
499: ADJUSTED_DOC_APPLICATION_ID
500: ,ADJUSTED_DOC_DATE

Line 498: INSERT INTO ZX_LINES(

494: END IF;
495:
496: -- Insert data into zx_lines
497: --
498: INSERT INTO ZX_LINES(
499: ADJUSTED_DOC_APPLICATION_ID
500: ,ADJUSTED_DOC_DATE
501: ,ADJUSTED_DOC_ENTITY_CODE
502: ,ADJUSTED_DOC_EVENT_CLASS_CODE

Line 1068: ,zx_lines_s.nextval TAX_LINE_ID

1064: ,NULL TAX_HOLD_RELEASED_CODE
1065: ,taxes.tax_id TAX_ID
1066: ,NULL TAX_JURISDICTION_CODE
1067: ,NULL TAX_JURISDICTION_ID
1068: ,zx_lines_s.nextval TAX_LINE_ID
1069: ,RANK() OVER
1070: (PARTITION BY poh.po_header_id
1071: ORDER BY poll.line_location_id,
1072: atc.tax_id) TAX_LINE_NUMBER

Line 1181: (SELECT 1 FROM zx_lines zxl

1177: AND status.tax(+) = rates.tax
1178: AND status.tax_status_code(+) = rates.tax_status_code
1179: AND status.content_owner_id(+) = rates.content_owner_id
1180: AND NOT EXISTS
1181: (SELECT 1 FROM zx_lines zxl
1182: WHERE zxl.APPLICATION_ID = 201
1183: AND zxl.EVENT_CLASS_CODE = 'PO_PA'
1184: AND zxl.ENTITY_CODE = 'PURCHASE_ORDER'
1185: AND zxl.TRX_ID = p_upg_trx_info_rec.trx_id

Line 1199: 'Inserting data into zx_lines');

1195:
1196: IF (g_level_statement >= g_current_runtime_level ) THEN
1197: FND_LOG.STRING(g_level_statement,
1198: 'ZX.PLSQL.ZX_ON_FLY_TRX_UPGRADE_PKG.upgrade_trx_on_fly_po',
1199: 'Inserting data into zx_lines');
1200: END IF;
1201:
1202: -- Insert data into zx_lines
1203: --

Line 1202: -- Insert data into zx_lines

1198: 'ZX.PLSQL.ZX_ON_FLY_TRX_UPGRADE_PKG.upgrade_trx_on_fly_po',
1199: 'Inserting data into zx_lines');
1200: END IF;
1201:
1202: -- Insert data into zx_lines
1203: --
1204: INSERT INTO ZX_LINES(
1205: ADJUSTED_DOC_APPLICATION_ID
1206: ,ADJUSTED_DOC_DATE

Line 1204: INSERT INTO ZX_LINES(

1200: END IF;
1201:
1202: -- Insert data into zx_lines
1203: --
1204: INSERT INTO ZX_LINES(
1205: ADJUSTED_DOC_APPLICATION_ID
1206: ,ADJUSTED_DOC_DATE
1207: ,ADJUSTED_DOC_ENTITY_CODE
1208: ,ADJUSTED_DOC_EVENT_CLASS_CODE

Line 1780: ,zx_lines_s.nextval TAX_LINE_ID

1776: ,NULL TAX_HOLD_RELEASED_CODE
1777: ,taxes.tax_id TAX_ID
1778: ,NULL TAX_JURISDICTION_CODE
1779: ,NULL TAX_JURISDICTION_ID
1780: ,zx_lines_s.nextval TAX_LINE_ID
1781: ,RANK() OVER
1782: (PARTITION BY poh.po_header_id
1783: ORDER BY poll.line_location_id,
1784: atg.tax_code_id,

Line 1900: (SELECT 1 FROM zx_lines zxl

1896: AND status.tax(+) = rates.tax
1897: AND status.tax_status_code(+) = rates.tax_status_code
1898: AND status.content_owner_id(+) = rates.content_owner_id
1899: AND NOT EXISTS
1900: (SELECT 1 FROM zx_lines zxl
1901: WHERE zxl.APPLICATION_ID = 201
1902: AND zxl.EVENT_CLASS_CODE = 'PO_PA'
1903: AND zxl.ENTITY_CODE = 'PURCHASE_ORDER'
1904: AND zxl.TRX_ID = p_upg_trx_info_rec.trx_id

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

2267: ,1 OBJECT_VERSION_NUMBER
2268: FROM (SELECT /*+ use_nl_with_index(recdist ZX_PO_REC_DIST_N1) */
2269: pohzd.*,
2270: recdist.rec_rate d_rec_rate
2271: FROM (SELECT /*+ NO_EXPAND leading(poh) use_nl_with_index(zxl, ZX_LINES_U1) use_nl(pod) */
2272: poh.po_header_id,
2273: fsp.set_of_books_id,
2274: zxl.*,
2275: pod.po_distribution_id p_po_distribution_id,

Line 2301: zx_lines zxl,

2297: pod.attribute14 p_attribute14,
2298: pod.attribute15 p_attribute15
2299: FROM po_headers_all poh,
2300: financials_system_params_all fsp,
2301: zx_lines zxl,
2302: po_line_locations_all poll,
2303: po_distributions_all pod
2304: WHERE poh.po_header_id = p_upg_trx_info_rec.trx_id
2305: AND NVL(poh.org_id, -99) = NVL(fsp.org_id, -99)

Line 2364: -- Insert data into zx_lines_det_factors

2360: END IF;
2361:
2362: ELSIF p_upg_trx_info_rec.entity_code = 'RELEASE' THEN
2363:
2364: -- Insert data into zx_lines_det_factors
2365: --
2366: INSERT INTO ZX_LINES_DET_FACTORS (
2367: EVENT_ID
2368: ,ACCOUNT_CCID

Line 2366: INSERT INTO ZX_LINES_DET_FACTORS (

2362: ELSIF p_upg_trx_info_rec.entity_code = 'RELEASE' THEN
2363:
2364: -- Insert data into zx_lines_det_factors
2365: --
2366: INSERT INTO ZX_LINES_DET_FACTORS (
2367: EVENT_ID
2368: ,ACCOUNT_CCID
2369: ,ACCOUNT_STRING
2370: ,ADJUSTED_DOC_APPLICATION_ID

Line 2781: (SELECT 1 FROM zx_lines_det_factors zxl

2777: )
2778: AND ptp.party_id = DECODE(l_multi_org_flag,'N',l_org_id,poll.org_id)
2779: AND ptp.party_type_code = 'OU'
2780: AND NOT EXISTS
2781: (SELECT 1 FROM zx_lines_det_factors zxl
2782: WHERE zxl.APPLICATION_ID = 201
2783: AND zxl.EVENT_CLASS_CODE = 'RELEASE'
2784: AND zxl.ENTITY_CODE = 'RELEASE'
2785: AND zxl.TRX_ID = p_upg_trx_info_rec.trx_id

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

2798:
2799: IF (g_level_statement >= g_current_runtime_level ) THEN
2800: FND_LOG.STRING(g_level_statement,
2801: 'ZX.PLSQL.ZX_ON_FLY_TRX_UPGRADE_PKG.upgrade_trx_on_fly_po',
2802: 'Inserting data into zx_lines (Tax Code)');
2803: END IF;
2804:
2805: -- Insert data into zx_lines
2806: --

Line 2805: -- Insert data into zx_lines

2801: 'ZX.PLSQL.ZX_ON_FLY_TRX_UPGRADE_PKG.upgrade_trx_on_fly_po',
2802: 'Inserting data into zx_lines (Tax Code)');
2803: END IF;
2804:
2805: -- Insert data into zx_lines
2806: --
2807: INSERT INTO ZX_LINES(
2808: ADJUSTED_DOC_APPLICATION_ID
2809: ,ADJUSTED_DOC_DATE

Line 2807: INSERT INTO ZX_LINES(

2803: END IF;
2804:
2805: -- Insert data into zx_lines
2806: --
2807: INSERT INTO ZX_LINES(
2808: ADJUSTED_DOC_APPLICATION_ID
2809: ,ADJUSTED_DOC_DATE
2810: ,ADJUSTED_DOC_ENTITY_CODE
2811: ,ADJUSTED_DOC_EVENT_CLASS_CODE

Line 3377: ,zx_lines_s.nextval TAX_LINE_ID

3373: ,NULL TAX_HOLD_RELEASED_CODE
3374: ,taxes.tax_id TAX_ID
3375: ,NULL TAX_JURISDICTION_CODE
3376: ,NULL TAX_JURISDICTION_ID
3377: ,zx_lines_s.nextval TAX_LINE_ID
3378: ,RANK() OVER
3379: (PARTITION BY poll.po_release_id
3380: ORDER BY poll.line_location_id,
3381: atc.tax_id) TAX_LINE_NUMBER

Line 3499: (SELECT 1 FROM zx_lines zxl

3495: AND status.tax(+) = rates.tax
3496: AND status.tax_status_code(+) = rates.tax_status_code
3497: AND status.content_owner_id(+) = rates.content_owner_id
3498: AND NOT EXISTS
3499: (SELECT 1 FROM zx_lines zxl
3500: WHERE zxl.APPLICATION_ID = 201
3501: AND zxl.EVENT_CLASS_CODE = 'RELEASE'
3502: AND zxl.ENTITY_CODE = 'RELEASE'
3503: AND zxl.TRX_ID = p_upg_trx_info_rec.trx_id

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

3516:
3517: IF (g_level_statement >= g_current_runtime_level ) THEN
3518: FND_LOG.STRING(g_level_statement,
3519: 'ZX.PLSQL.ZX_ON_FLY_TRX_UPGRADE_PKG.upgrade_trx_on_fly_po',
3520: 'Inserting data into zx_lines(Tax Group)');
3521: END IF;
3522:
3523: -- Insert data into zx_lines
3524: --

Line 3523: -- Insert data into zx_lines

3519: 'ZX.PLSQL.ZX_ON_FLY_TRX_UPGRADE_PKG.upgrade_trx_on_fly_po',
3520: 'Inserting data into zx_lines(Tax Group)');
3521: END IF;
3522:
3523: -- Insert data into zx_lines
3524: --
3525: INSERT INTO ZX_LINES(
3526: ADJUSTED_DOC_APPLICATION_ID
3527: ,ADJUSTED_DOC_DATE

Line 3525: INSERT INTO ZX_LINES(

3521: END IF;
3522:
3523: -- Insert data into zx_lines
3524: --
3525: INSERT INTO ZX_LINES(
3526: ADJUSTED_DOC_APPLICATION_ID
3527: ,ADJUSTED_DOC_DATE
3528: ,ADJUSTED_DOC_ENTITY_CODE
3529: ,ADJUSTED_DOC_EVENT_CLASS_CODE

Line 4101: ,zx_lines_s.nextval TAX_LINE_ID

4097: ,NULL TAX_HOLD_RELEASED_CODE
4098: ,taxes.tax_id TAX_ID
4099: ,NULL TAX_JURISDICTION_CODE
4100: ,NULL TAX_JURISDICTION_ID
4101: ,zx_lines_s.nextval TAX_LINE_ID
4102: ,RANK() OVER
4103: (PARTITION BY poll.po_release_id
4104: ORDER BY poll.line_location_id,
4105: atg.tax_code_id,

Line 4230: (SELECT 1 FROM zx_lines zxl

4226: AND status.tax(+) = rates.tax
4227: AND status.tax_status_code(+) = rates.tax_status_code
4228: AND status.content_owner_id(+) = rates.content_owner_id
4229: AND NOT EXISTS
4230: (SELECT 1 FROM zx_lines zxl
4231: WHERE zxl.APPLICATION_ID = 201
4232: AND zxl.EVENT_CLASS_CODE = 'RELEASE'
4233: AND zxl.ENTITY_CODE = 'RELEASE'
4234: AND zxl.TRX_ID = p_upg_trx_info_rec.trx_id

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

4600: ,1 OBJECT_VERSION_NUMBER
4601: FROM (SELECT /*+ use_nl_with_index(recdist ZX_PO_REC_DIST_N1) */
4602: pohzd.*,
4603: recdist.rec_rate d_rec_rate
4604: FROM (SELECT /*+ NO_EXPAND leading(poh) use_nl_with_index(zxl, ZX_LINES_U1) use_nl(pod) */
4605: poh.po_header_id,
4606: fsp.set_of_books_id,
4607: zxl.*,
4608: pod.po_distribution_id p_po_distribution_id,

Line 4635: zx_lines zxl,

4631: pod.attribute15 p_attribute15
4632: FROM po_line_locations_all poll,
4633: po_headers_all poh,
4634: financials_system_params_all fsp,
4635: zx_lines zxl,
4636: po_distributions_all pod
4637: WHERE poll.po_release_id = p_upg_trx_info_rec.trx_id
4638: AND poh.po_header_id = poll.po_header_id
4639: AND NVL(poh.org_id, -99) = NVL(fsp.org_id, -99)

Line 4766: 'Inserting data into zx_lines_det_factors');

4762:
4763: IF (g_level_statement >= g_current_runtime_level ) THEN
4764: FND_LOG.STRING(g_level_statement,
4765: 'ZX.PLSQL.ZX_ON_FLY_TRX_UPGRADE_PKG.upgrade_trx_on_fly_blk_po',
4766: 'Inserting data into zx_lines_det_factors');
4767: END IF;
4768: -- Insert data into zx_lines_det_factors
4769: --
4770: INSERT INTO ZX_LINES_DET_FACTORS (

Line 4768: -- Insert data into zx_lines_det_factors

4764: FND_LOG.STRING(g_level_statement,
4765: 'ZX.PLSQL.ZX_ON_FLY_TRX_UPGRADE_PKG.upgrade_trx_on_fly_blk_po',
4766: 'Inserting data into zx_lines_det_factors');
4767: END IF;
4768: -- Insert data into zx_lines_det_factors
4769: --
4770: INSERT INTO ZX_LINES_DET_FACTORS (
4771: EVENT_ID
4772: ,ACCOUNT_CCID

Line 4770: INSERT INTO ZX_LINES_DET_FACTORS (

4766: 'Inserting data into zx_lines_det_factors');
4767: END IF;
4768: -- Insert data into zx_lines_det_factors
4769: --
4770: INSERT INTO ZX_LINES_DET_FACTORS (
4771: EVENT_ID
4772: ,ACCOUNT_CCID
4773: ,ACCOUNT_STRING
4774: ,ADJUSTED_DOC_APPLICATION_ID

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

5191:
5192: IF (g_level_statement >= g_current_runtime_level ) THEN
5193: FND_LOG.STRING(g_level_statement,
5194: 'ZX.PLSQL.ZX_ON_FLY_TRX_UPGRADE_PKG.upgrade_trx_on_fly_blk_po',
5195: 'Inserting data into zx_lines(Tax Code)');
5196: END IF;
5197:
5198: -- Insert data into zx_lines
5199: --

Line 5198: -- Insert data into zx_lines

5194: 'ZX.PLSQL.ZX_ON_FLY_TRX_UPGRADE_PKG.upgrade_trx_on_fly_blk_po',
5195: 'Inserting data into zx_lines(Tax Code)');
5196: END IF;
5197:
5198: -- Insert data into zx_lines
5199: --
5200:
5201: INSERT INTO ZX_LINES(
5202: ADJUSTED_DOC_APPLICATION_ID

Line 5201: INSERT INTO ZX_LINES(

5197:
5198: -- Insert data into zx_lines
5199: --
5200:
5201: INSERT INTO ZX_LINES(
5202: ADJUSTED_DOC_APPLICATION_ID
5203: ,ADJUSTED_DOC_DATE
5204: ,ADJUSTED_DOC_ENTITY_CODE
5205: ,ADJUSTED_DOC_EVENT_CLASS_CODE

Line 5771: ,zx_lines_s.nextval TAX_LINE_ID

5767: ,NULL TAX_HOLD_RELEASED_CODE
5768: ,taxes.tax_id TAX_ID
5769: ,NULL TAX_JURISDICTION_CODE
5770: ,NULL TAX_JURISDICTION_ID
5771: ,zx_lines_s.nextval TAX_LINE_ID
5772: ,RANK() OVER
5773: (PARTITION BY poh.po_header_id
5774: ORDER BY poll.line_location_id,
5775: atc.tax_id) TAX_LINE_NUMBER

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

5889:
5890: IF (g_level_statement >= g_current_runtime_level ) THEN
5891: FND_LOG.STRING(g_level_statement,
5892: 'ZX.PLSQL.ZX_ON_FLY_TRX_UPGRADE_PO_PKG.upgrade_trx_on_fly_blk_po',
5893: 'ZX_LINES Number of Rows Inserted(Tax Code) = ' || TO_CHAR(SQL%ROWCOUNT));
5894: END IF;
5895:
5896: IF (g_level_statement >= g_current_runtime_level ) THEN
5897: FND_LOG.STRING(g_level_statement,

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

5895:
5896: IF (g_level_statement >= g_current_runtime_level ) THEN
5897: FND_LOG.STRING(g_level_statement,
5898: 'ZX.PLSQL.ZX_ON_FLY_TRX_UPGRADE_PKG.upgrade_trx_on_fly_blk_po',
5899: 'Inserting data into zx_lines(Tax Group)');
5900: END IF;
5901:
5902: -- Insert data into zx_lines
5903: --

Line 5902: -- Insert data into zx_lines

5898: 'ZX.PLSQL.ZX_ON_FLY_TRX_UPGRADE_PKG.upgrade_trx_on_fly_blk_po',
5899: 'Inserting data into zx_lines(Tax Group)');
5900: END IF;
5901:
5902: -- Insert data into zx_lines
5903: --
5904:
5905: INSERT INTO ZX_LINES(
5906: ADJUSTED_DOC_APPLICATION_ID

Line 5905: INSERT INTO ZX_LINES(

5901:
5902: -- Insert data into zx_lines
5903: --
5904:
5905: INSERT INTO ZX_LINES(
5906: ADJUSTED_DOC_APPLICATION_ID
5907: ,ADJUSTED_DOC_DATE
5908: ,ADJUSTED_DOC_ENTITY_CODE
5909: ,ADJUSTED_DOC_EVENT_CLASS_CODE

Line 6481: ,zx_lines_s.nextval TAX_LINE_ID

6477: ,NULL TAX_HOLD_RELEASED_CODE
6478: ,taxes.tax_id TAX_ID
6479: ,NULL TAX_JURISDICTION_CODE
6480: ,NULL TAX_JURISDICTION_ID
6481: ,zx_lines_s.nextval TAX_LINE_ID
6482: ,RANK() OVER
6483: (PARTITION BY poh.po_header_id
6484: ORDER BY poll.line_location_id,
6485: atg.tax_code_id,

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

6605:
6606: IF (g_level_statement >= g_current_runtime_level ) THEN
6607: FND_LOG.STRING(g_level_statement,
6608: 'ZX.PLSQL.ZX_ON_FLY_TRX_UPGRADE_PO_PKG.upgrade_trx_on_fly_blk_po',
6609: 'ZX_LINES Number of Rows Inserted(Tax Group) = ' || TO_CHAR(SQL%ROWCOUNT));
6610: END IF;
6611:
6612: -- COMMIT;
6613:

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

6964: ,1 OBJECT_VERSION_NUMBER
6965: FROM (SELECT /*+ use_nl_with_index(recdist ZX_PO_REC_DIST_N1) */
6966: pohzd.*,
6967: recdist.rec_rate d_rec_rate
6968: FROM (SELECT /*+ NO_EXPAND leading(poh) use_nl_with_index(zxl, ZX_LINES_U1) use_nl(pod) */
6969: poh.po_header_id,
6970: fsp.set_of_books_id,
6971: zxl.*,
6972: pod.po_distribution_id p_po_distribution_id,

Line 7004: zx_lines zxl,

7000: and other_doc_event_class_code = 'PO_PA'
7001: ) zxvalerr, --Bug 5187701
7002: po_headers_all poh,
7003: financials_system_params_all fsp,
7004: zx_lines zxl,
7005: po_line_locations_all poll,
7006: po_distributions_all pod
7007: WHERE poh.po_header_id = zxvalerr.other_doc_trx_id
7008: AND NVL(poh.org_id, -99) = NVL(fsp.org_id, -99)

Line 7056: -- Insert data into zx_lines_det_factors

7052: END IF;
7053:
7054: -- bug 5166217 : Do bulk migration for RELEASE
7055: --
7056: -- Insert data into zx_lines_det_factors
7057: --
7058: INSERT INTO ZX_LINES_DET_FACTORS (
7059: EVENT_ID
7060: ,ACCOUNT_CCID

Line 7058: INSERT INTO ZX_LINES_DET_FACTORS (

7054: -- bug 5166217 : Do bulk migration for RELEASE
7055: --
7056: -- Insert data into zx_lines_det_factors
7057: --
7058: INSERT INTO ZX_LINES_DET_FACTORS (
7059: EVENT_ID
7060: ,ACCOUNT_CCID
7061: ,ACCOUNT_STRING
7062: ,ADJUSTED_DOC_APPLICATION_ID

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

7486:
7487: IF (g_level_statement >= g_current_runtime_level ) THEN
7488: FND_LOG.STRING(g_level_statement,
7489: 'ZX.PLSQL.ZX_ON_FLY_TRX_UPGRADE_PKG.upgrade_trx_on_fly_blk_po',
7490: 'Inserting data into zx_lines(Tax Code)');
7491: END IF;
7492:
7493: -- Insert data into zx_lines
7494: --

Line 7493: -- Insert data into zx_lines

7489: 'ZX.PLSQL.ZX_ON_FLY_TRX_UPGRADE_PKG.upgrade_trx_on_fly_blk_po',
7490: 'Inserting data into zx_lines(Tax Code)');
7491: END IF;
7492:
7493: -- Insert data into zx_lines
7494: --
7495:
7496: INSERT INTO ZX_LINES(
7497: ADJUSTED_DOC_APPLICATION_ID

Line 7496: INSERT INTO ZX_LINES(

7492:
7493: -- Insert data into zx_lines
7494: --
7495:
7496: INSERT INTO ZX_LINES(
7497: ADJUSTED_DOC_APPLICATION_ID
7498: ,ADJUSTED_DOC_DATE
7499: ,ADJUSTED_DOC_ENTITY_CODE
7500: ,ADJUSTED_DOC_EVENT_CLASS_CODE

Line 8066: ,zx_lines_s.nextval TAX_LINE_ID

8062: ,NULL TAX_HOLD_RELEASED_CODE
8063: ,taxes.tax_id TAX_ID
8064: ,NULL TAX_JURISDICTION_CODE
8065: ,NULL TAX_JURISDICTION_ID
8066: ,zx_lines_s.nextval TAX_LINE_ID
8067: ,RANK() OVER
8068: (PARTITION BY poll.po_release_id
8069: ORDER BY poll.line_location_id,
8070: atc.tax_id) TAX_LINE_NUMBER

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

8193:
8194: IF (g_level_statement >= g_current_runtime_level ) THEN
8195: FND_LOG.STRING(g_level_statement,
8196: 'ZX.PLSQL.ZX_ON_FLY_TRX_UPGRADE_PO_PKG.upgrade_trx_on_fly_blk_po',
8197: 'ZX_LINES Number of Rows Inserted(Tax Code) = ' || TO_CHAR(SQL%ROWCOUNT));
8198: END IF;
8199:
8200: IF (g_level_statement >= g_current_runtime_level ) THEN
8201: FND_LOG.STRING(g_level_statement,

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

8199:
8200: IF (g_level_statement >= g_current_runtime_level ) THEN
8201: FND_LOG.STRING(g_level_statement,
8202: 'ZX.PLSQL.ZX_ON_FLY_TRX_UPGRADE_PKG.upgrade_trx_on_fly_blk_po',
8203: 'Inserting data into zx_lines(Tax Group)');
8204: END IF;
8205:
8206: -- Insert data into zx_lines
8207: --

Line 8206: -- Insert data into zx_lines

8202: 'ZX.PLSQL.ZX_ON_FLY_TRX_UPGRADE_PKG.upgrade_trx_on_fly_blk_po',
8203: 'Inserting data into zx_lines(Tax Group)');
8204: END IF;
8205:
8206: -- Insert data into zx_lines
8207: --
8208:
8209: INSERT INTO ZX_LINES(
8210: ADJUSTED_DOC_APPLICATION_ID

Line 8209: INSERT INTO ZX_LINES(

8205:
8206: -- Insert data into zx_lines
8207: --
8208:
8209: INSERT INTO ZX_LINES(
8210: ADJUSTED_DOC_APPLICATION_ID
8211: ,ADJUSTED_DOC_DATE
8212: ,ADJUSTED_DOC_ENTITY_CODE
8213: ,ADJUSTED_DOC_EVENT_CLASS_CODE

Line 8785: ,zx_lines_s.nextval TAX_LINE_ID

8781: ,NULL TAX_HOLD_RELEASED_CODE
8782: ,taxes.tax_id TAX_ID
8783: ,NULL TAX_JURISDICTION_CODE
8784: ,NULL TAX_JURISDICTION_ID
8785: ,zx_lines_s.nextval TAX_LINE_ID
8786: ,RANK() OVER
8787: (PARTITION BY poll.po_release_id
8788: ORDER BY poll.line_location_id,
8789: atg.tax_code_id,

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

8919:
8920: IF (g_level_statement >= g_current_runtime_level ) THEN
8921: FND_LOG.STRING(g_level_statement,
8922: 'ZX.PLSQL.ZX_ON_FLY_TRX_UPGRADE_PO_PKG.upgrade_trx_on_fly_blk_po',
8923: 'ZX_LINES Number of Rows Inserted(Tax Group) = ' || TO_CHAR(SQL%ROWCOUNT));
8924: END IF;
8925:
8926: -- COMMIT;
8927:

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

9277: ,1 OBJECT_VERSION_NUMBER
9278: FROM (SELECT /*+ use_nl_with_index(recdist ZX_PO_REC_DIST_N1) */
9279: pohzd.*,
9280: recdist.rec_rate d_rec_rate
9281: FROM (SELECT /*+ NO_EXPAND leading(poh) use_nl_with_index(zxl, ZX_LINES_U1) use_nl(pod) */
9282: poh.po_header_id,
9283: fsp.set_of_books_id,
9284: zxl.*,
9285: pod.po_distribution_id p_po_distribution_id,

Line 9318: zx_lines zxl,

9314: zxvalerr,
9315: po_line_locations_all poll,
9316: po_headers_all poh,
9317: financials_system_params_all fsp,
9318: zx_lines zxl,
9319: po_distributions_all pod
9320: WHERE poll.po_release_id = zxvalerr.other_doc_trx_id
9321: AND poh.po_header_id = poll.po_header_id
9322: AND NVL(poh.org_id, -99) = NVL(fsp.org_id, -99)