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_TDS_TAX_LINES_POPU_PKG dependencies on ZX_LINES_DET_FACTORS

Line 1744: -- bug 8470599 forcing the driving table in select clause from zx_lines_det_factors

1740: END IF;
1741:
1742: p_return_status := FND_API.G_RET_STS_SUCCESS;
1743:
1744: -- bug 8470599 forcing the driving table in select clause from zx_lines_det_factors
1745: INSERT INTO zx_detail_tax_lines_gt
1746: ( tax_line_id,
1747: internal_organization_id,
1748: application_id,

Line 2351: zx_lines_det_factors G

2347: 1,
2348: L.legal_reporting_status,
2349: L.account_source_tax_rate_id
2350: FROM ZX_LINES L,
2351: zx_lines_det_factors G
2352: WHERE G.application_id = p_event_class_rec.application_id AND
2353: G.entity_code = p_event_class_rec.entity_code AND
2354: G.event_class_code = p_event_class_rec.event_class_code AND
2355: -- G.trx_id = p_event_class_rec.trx_id AND

Line 2453: -- bug 8470599 forcing the driving table in select clause from zx_lines_det_factors

2449:
2450: -- Fetch back canceled tax lines with frozen tax distributions
2451: --
2452:
2453: -- bug 8470599 forcing the driving table in select clause from zx_lines_det_factors
2454: INSERT INTO zx_detail_tax_lines_gt
2455: ( tax_line_id,
2456: internal_organization_id,
2457: application_id,

Line 3058: zx_lines_det_factors G

3054: 1,
3055: legal_reporting_status,
3056: L.account_source_tax_rate_id
3057: FROM zx_lines L,
3058: zx_lines_det_factors G
3059: WHERE G.application_id = p_event_class_rec.application_id
3060: AND G.entity_code = p_event_class_rec.entity_code
3061: AND G.event_class_code = p_event_class_rec.event_class_code
3062: AND G.trx_id = p_event_class_rec.trx_id

Line 3234: -- bug 8470599 forcing the driving table in select clause from zx_lines_det_factors

3230: 'ZX.PLSQL.ZX_TDS_TAX_LINES_POPU_PKG.process_frozen_tax_lines',
3231: 'Number of Rows Updated: ' || SQL%ROWCOUNT);
3232: END IF;
3233:
3234: -- bug 8470599 forcing the driving table in select clause from zx_lines_det_factors
3235: INSERT INTO zx_detail_tax_lines_gt
3236: ( tax_line_id,
3237: internal_organization_id,
3238: application_id,

Line 3855: zx_lines_det_factors G

3851: DECODE(L.legal_reporting_status, '111111111111111',
3852: '000000000000000', L.legal_reporting_status),
3853: L.account_source_tax_rate_id
3854: FROM zx_lines L,
3855: zx_lines_det_factors G
3856: WHERE G.application_id = p_event_class_rec.application_id
3857: AND G.entity_code = p_event_class_rec.entity_code
3858: AND G.event_class_code = p_event_class_rec.event_class_code
3859: -- AND G.trx_id = p_event_class_rec.trx_id

Line 3950: -- bug 8470599 forcing the driving table in select clause from zx_lines_det_factors

3946: END IF;
3947:
3948: p_return_status := FND_API.G_RET_STS_SUCCESS;
3949:
3950: -- bug 8470599 forcing the driving table in select clause from zx_lines_det_factors
3951: INSERT INTO zx_detail_tax_lines_gt
3952: ( tax_line_id,
3953: internal_organization_id,
3954: application_id,

Line 4560: zx_lines_det_factors G

4556: decode(L.legal_reporting_status,'111111111111111',
4557: '000000000000000',L.legal_reporting_status),
4558: L.account_source_tax_rate_id
4559: FROM ZX_LINES L,
4560: zx_lines_det_factors G
4561: WHERE G.application_id = p_event_class_rec.application_id AND
4562: G.entity_code = p_event_class_rec.entity_code AND
4563: G.event_class_code = p_event_class_rec.event_class_code AND
4564: -- G.trx_id = p_event_class_rec.trx_id AND

Line 4651: -- bug 8470599 forcing the driving table in select clause from zx_lines_det_factors

4647: END IF;
4648:
4649: p_return_status := FND_API.G_RET_STS_SUCCESS;
4650:
4651: -- bug 8470599 forcing the driving table in select clause from zx_lines_det_factors
4652: INSERT INTO zx_detail_tax_lines_gt
4653: ( tax_line_id,
4654: internal_organization_id,
4655: application_id,

Line 5253: zx_lines_det_factors G

5249: decode(L.legal_reporting_status, '111111111111111',
5250: '000000000000000', L.legal_reporting_status),
5251: L.account_source_tax_rate_id
5252: FROM ZX_LINES L,
5253: zx_lines_det_factors G
5254: WHERE G.application_id = p_event_class_rec.application_id AND
5255: G.entity_code = p_event_class_rec.entity_code AND
5256: G.event_class_code = p_event_class_rec.event_class_code AND
5257: -- G.trx_id = p_event_class_rec.trx_id AND

Line 5359: zx_lines_det_factors trx_line

5355: tax_line.tax_id,
5356: tax_line.tax_hold_released_code,
5357: tax_line.Rounding_Rule_Code
5358: FROM ZX_DETAIL_TAX_LINES_GT tax_line,
5359: zx_lines_det_factors trx_line
5360: WHERE tax_line.application_id = p_event_class_rec.application_id
5361: AND tax_line.entity_code = p_event_class_rec.entity_code
5362: AND tax_line.event_class_code = p_event_class_rec.event_class_code
5363: AND tax_line.trx_id = p_event_class_rec.trx_id

Line 5417: (SELECT /+ index(LINE ZX_LINES_DET_FACTORS_U1) / 1

5413: AND gt.offset_link_to_tax_line_id IS NULL
5414: AND gt.orig_tax_amt_tax_curr IS NOT NULL
5415: AND gt.mrc_tax_line_flag = 'N'
5416: AND EXISTS
5417: (SELECT /*+ index(LINE ZX_LINES_DET_FACTORS_U1) */ 1
5418: FROM zx_lines_det_factors line
5419: WHERE line.application_id = p_event_class_rec.application_id
5420: AND line.entity_code = p_event_class_rec.entity_code
5421: AND line.event_class_code = p_event_class_rec.event_class_code

Line 5418: FROM zx_lines_det_factors line

5414: AND gt.orig_tax_amt_tax_curr IS NOT NULL
5415: AND gt.mrc_tax_line_flag = 'N'
5416: AND EXISTS
5417: (SELECT /*+ index(LINE ZX_LINES_DET_FACTORS_U1) */ 1
5418: FROM zx_lines_det_factors line
5419: WHERE line.application_id = p_event_class_rec.application_id
5420: AND line.entity_code = p_event_class_rec.entity_code
5421: AND line.event_class_code = p_event_class_rec.event_class_code
5422: AND line.event_id = p_event_class_rec.event_id