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_DEMAND_TRX_UPGRADE_PKG dependencies on ZX_LINES

Line 480: /* Insert All Taxable Lines into ZX_LINES_DET_FACTORS. Incase there are No taxable lines,

476: END IF;
477:
478: x_retcode := CONC_SUCCESS;
479:
480: /* Insert All Taxable Lines into ZX_LINES_DET_FACTORS. Incase there are No taxable lines,
481: (link_to_cust_trx_line_id is null, hence insert dummy lines in ZX_LINES_DET_FACTORS with
482: trx_line_id = -9999) */
483:
484: INSERT ALL

Line 481: (link_to_cust_trx_line_id is null, hence insert dummy lines in ZX_LINES_DET_FACTORS with

477:
478: x_retcode := CONC_SUCCESS;
479:
480: /* Insert All Taxable Lines into ZX_LINES_DET_FACTORS. Incase there are No taxable lines,
481: (link_to_cust_trx_line_id is null, hence insert dummy lines in ZX_LINES_DET_FACTORS with
482: trx_line_id = -9999) */
483:
484: INSERT ALL
485: WHEN trx_line_type IN ('LINE' ,'CB') THEN

Line 486: INTO ZX_LINES_DET_FACTORS(

482: trx_line_id = -9999) */
483:
484: INSERT ALL
485: WHEN trx_line_type IN ('LINE' ,'CB') THEN
486: INTO ZX_LINES_DET_FACTORS(
487: INTERNAL_ORGANIZATION_ID
488: ,APPLICATION_ID
489: ,ENTITY_CODE
490: ,EVENT_CLASS_CODE

Line 851: INTO ZX_LINES (

847: ,LAST_UPDATED_BY
848: ,LAST_UPDATE_LOGIN
849: )
850: WHEN (trx_line_type = 'TAX') THEN
851: INTO ZX_LINES (
852: TAX_LINE_ID
853: ,INTERNAL_ORGANIZATION_ID
854: ,APPLICATION_ID
855: ,ENTITY_CODE

Line 1767: -- zx_lines columns start from here

1763: --NULL TRX_LINE_PRECISION,
1764: --NULL TRX_LINE_MAU,
1765: --NULL TRX_LINE_CURRENCY_CONV_TYPE,
1766:
1767: -- zx_lines columns start from here
1768:
1769: custtrxl.tax_line_id TAX_LINE_ID,
1770: DECODE(custtrxl.line_type,
1771: 'TAX', RANK() OVER (

Line 2245: (SELECT 1 FROM zx_lines_det_factors zxl

2241: AND rates.tax_status_code = status.tax_status_code(+)
2242: AND rates.content_owner_id = status.content_owner_id(+)
2243: AND NVL(arsysparam.tax_code, '!') <> 'Localization'
2244: AND NOT EXISTS
2245: (SELECT 1 FROM zx_lines_det_factors zxl
2246: WHERE zxl.APPLICATION_ID = 222
2247: AND zxl.EVENT_CLASS_CODE = DECODE(types.type,
2248: 'INV','INVOICE',
2249: 'CM', 'CREDIT_MEMO',

Line 2304: -- Insert data into zx_lines_det_factors and zx_lines_summary

2300: END IF;
2301:
2302: x_retcode := CONC_SUCCESS;
2303:
2304: -- Insert data into zx_lines_det_factors and zx_lines_summary
2305: --
2306: INSERT ALL
2307: WHEN AP_LINE_LOOKUP_CODE IN ('ITEM', 'PREPAY','FREIGHT','MISCELLANEOUS') OR
2308: TAX_ONLY_LINE_FLAG = 'Y'

Line 2310: INTO ZX_LINES_DET_FACTORS (

2306: INSERT ALL
2307: WHEN AP_LINE_LOOKUP_CODE IN ('ITEM', 'PREPAY','FREIGHT','MISCELLANEOUS') OR
2308: TAX_ONLY_LINE_FLAG = 'Y'
2309: THEN
2310: INTO ZX_LINES_DET_FACTORS (
2311: --EVENT_ID
2312: OBJECT_VERSION_NUMBER
2313: ,INTERNAL_ORGANIZATION_ID
2314: ,APPLICATION_ID

Line 2545: INTO ZX_LINES_SUMMARY (

2541: ,BILL_THIRD_PTY_ACCT_ID
2542: ,BILL_THIRD_PTY_ACCT_SITE_ID
2543: )
2544: WHEN AP_LINE_LOOKUP_CODE = 'TAX' THEN
2545: INTO ZX_LINES_SUMMARY (
2546: SUMMARY_TAX_LINE_ID
2547: ,INTERNAL_ORGANIZATION_ID
2548: ,APPLICATION_ID
2549: ,ENTITY_CODE

Line 3022: (SELECT 1 FROM zx_lines_Det_Factors zxdet

3018: AND ptp.party_type_code = 'OU'
3019: AND ptp.party_id = DECODE(l_multi_org_flag,'N',l_org_id,lines.org_id)
3020: AND NVL(inv.historical_flag, 'N') = 'Y'
3021: AND NOT EXISTS
3022: (SELECT 1 FROM zx_lines_Det_Factors zxdet
3023: WHERE zxdet.APPLICATION_ID = 200
3024: AND zxdet.ENTITY_CODE = 'AP_INVOICES'
3025: AND zxdet.event_class_code = DECODE(inv.INVOICE_TYPE_LOOKUP_CODE,
3026: 'STANDARD', 'STANDARD INVOICES',

Line 3041: -- Insert data into zx_lines and zx_rec_nrec_dist

3037: 'INTEREST INVOICE', 'INTEREST INVOICES','NA')
3038: AND zxdet.TRX_ID = inv.invoice_id);
3039:
3040:
3041: -- Insert data into zx_lines and zx_rec_nrec_dist
3042: --
3043: INSERT ALL
3044: INTO ZX_REC_NREC_DIST(
3045: TAX_LINE_ID

Line 3185: ZX_LINES_S.NEXTVAL

3181: ,ACCOUNT_SOURCE_TAX_RATE_ID
3182: ,RECOVERY_RATE_ID
3183: )
3184: VALUES(
3185: ZX_LINES_S.NEXTVAL
3186: ,REC_NREC_TAX_DIST_ID
3187: ,REC_NREC_TAX_DIST_NUMBER
3188: ,200
3189: ,CONTENT_OWNER_ID

Line 3324: INTO ZX_LINES(

3320: ,DEF_REC_SETTLEMENT_OPTION_CODE
3321: ,ACCOUNT_SOURCE_TAX_RATE_ID
3322: ,RECOVERY_RATE_ID
3323: )
3324: INTO ZX_LINES(
3325: TAX_LINE_ID
3326: ,TAX_LINE_NUMBER
3327: ,APPLICATION_ID
3328: ,CONTENT_OWNER_ID

Line 3482: ZX_LINES_S.NEXTVAL

3478: ,LEGAL_REPORTING_STATUS
3479: ,ACCOUNT_SOURCE_TAX_RATE_ID
3480: )
3481: VALUES (
3482: ZX_LINES_S.NEXTVAL
3483: ,TAX_LINE_NUMBER
3484: ,200
3485: ,CONTENT_OWNER_ID
3486: ,CURRENCY_CONVERSION_DATE

Line 3935: (SELECT 1 FROM zx_lines zxl

3931: AND ptp.party_type_code = 'OU'
3932: AND ptp.party_id = DECODE(l_multi_org_flag,'N', l_org_id, ap_dists.org_id)
3933: AND NVL(inv.historical_flag, 'N') = 'Y'
3934: AND NOT EXISTS
3935: (SELECT 1 FROM zx_lines zxl
3936: WHERE zxl.application_id = 200
3937: AND zxl.event_class_code = DECODE(inv.INVOICE_TYPE_LOOKUP_CODE,
3938: 'STANDARD', 'STANDARD INVOICES',
3939: 'CREDIT' , 'STANDARD INVOICES',

Line 4005: INSERT INTO ZX_LINES_DET_FACTORS (

4001: ZX_PO_REC_PKG.get_rec_info(
4002: p_start_rowid => p_start_rowid,
4003: p_end_rowid => p_end_rowid);
4004:
4005: INSERT INTO ZX_LINES_DET_FACTORS (
4006: -- ,EVENT_ID
4007: -- ,ACCOUNT_CCID
4008: -- ,ACCOUNT_STRING
4009: -- ,ADJUSTED_DOC_APPLICATION_ID

Line 4416: (SELECT 1 FROM zx_lines_Det_Factors zxdet

4412: AND ptp.party_id = DECODE(l_multi_org_flag,'N',l_org_id,poll.org_id)
4413: AND ptp.party_type_code = 'OU'
4414: AND hr.location_id(+) = poll.ship_to_location_id
4415: AND NOT EXISTS
4416: (SELECT 1 FROM zx_lines_Det_Factors zxdet
4417: WHERE zxdet.APPLICATION_ID = 201
4418: AND zxdet.ENTITY_CODE = NVL2(poll.po_release_id, 'RELEASE', 'PURCHASE_ORDER')
4419: AND zxdet.EVENT_CLASS_CODE = NVL2(poll.po_release_id, 'RELEASE', 'PO_PA')
4420: AND zxdet.TRX_ID = NVL(poll.po_release_id,poh.po_header_id)

Line 4423: -- insert into zx_lines for tax code

4419: AND zxdet.EVENT_CLASS_CODE = NVL2(poll.po_release_id, 'RELEASE', 'PO_PA')
4420: AND zxdet.TRX_ID = NVL(poll.po_release_id,poh.po_header_id)
4421: );
4422:
4423: -- insert into zx_lines for tax code
4424: --
4425: INSERT INTO ZX_LINES(
4426: -- ,ADJUSTED_DOC_APPLICATION_ID
4427: -- ,ADJUSTED_DOC_DATE

Line 4425: INSERT INTO ZX_LINES(

4421: );
4422:
4423: -- insert into zx_lines for tax code
4424: --
4425: INSERT INTO ZX_LINES(
4426: -- ,ADJUSTED_DOC_APPLICATION_ID
4427: -- ,ADJUSTED_DOC_DATE
4428: -- ,ADJUSTED_DOC_ENTITY_CODE
4429: -- ,ADJUSTED_DOC_EVENT_CLASS_CODE

Line 5003: zx_lines_s.nextval TAX_LINE_ID,

4999: -- NULL TAX_HOLD_RELEASED_CODE,
5000: taxes.tax_id TAX_ID,
5001: -- NULL TAX_JURISDICTION_CODE,
5002: -- NULL TAX_JURISDICTION_ID,
5003: zx_lines_s.nextval TAX_LINE_ID,
5004: RANK() OVER
5005: (PARTITION BY
5006: NVL(poll.po_release_id,
5007: poh.po_header_id)

Line 5116: (SELECT 1 FROM zx_lines zxl

5112: AND status.tax(+) = rates.tax
5113: AND status.content_owner_id(+) = rates.content_owner_id
5114: AND status.tax_status_code(+) = rates.tax_status_code
5115: AND NOT EXISTS
5116: (SELECT 1 FROM zx_lines zxl
5117: WHERE zxl.APPLICATION_ID = 201
5118: AND zxl.EVENT_CLASS_CODE = NVL2(poll.po_release_id, 'RELEASE', 'PO_PA')
5119: AND zxl.TRX_ID = NVL(poll.po_release_id, poh.po_header_id)
5120: AND zxl.ENTITY_CODE = NVL2(poll.po_release_id, 'RELEASE','PURCHASE_ORDER'));

Line 5122: -- insert into zx_lines tax group

5118: AND zxl.EVENT_CLASS_CODE = NVL2(poll.po_release_id, 'RELEASE', 'PO_PA')
5119: AND zxl.TRX_ID = NVL(poll.po_release_id, poh.po_header_id)
5120: AND zxl.ENTITY_CODE = NVL2(poll.po_release_id, 'RELEASE','PURCHASE_ORDER'));
5121:
5122: -- insert into zx_lines tax group
5123: --
5124: INSERT INTO ZX_LINES(
5125: -- ,ADJUSTED_DOC_APPLICATION_ID
5126: -- ,ADJUSTED_DOC_DATE

Line 5124: INSERT INTO ZX_LINES(

5120: AND zxl.ENTITY_CODE = NVL2(poll.po_release_id, 'RELEASE','PURCHASE_ORDER'));
5121:
5122: -- insert into zx_lines tax group
5123: --
5124: INSERT INTO ZX_LINES(
5125: -- ,ADJUSTED_DOC_APPLICATION_ID
5126: -- ,ADJUSTED_DOC_DATE
5127: -- ,ADJUSTED_DOC_ENTITY_CODE
5128: -- ,ADJUSTED_DOC_EVENT_CLASS_CODE

Line 5709: zx_lines_s.nextval TAX_LINE_ID,

5705: -- NULL TAX_HOLD_RELEASED_CODE,
5706: taxes.tax_id TAX_ID,
5707: -- NULL TAX_JURISDICTION_CODE,
5708: -- NULL TAX_JURISDICTION_ID,
5709: zx_lines_s.nextval TAX_LINE_ID,
5710: RANK() OVER
5711: (PARTITION BY
5712: NVL(poll.po_release_id,
5713: poh.po_header_id)

Line 5832: (SELECT 1 FROM zx_lines zxl

5828: AND status.tax(+) = rates.tax
5829: AND status.content_owner_id(+) = rates.content_owner_id
5830: AND status.tax_status_code(+) = rates.tax_status_code
5831: AND NOT EXISTS
5832: (SELECT 1 FROM zx_lines zxl
5833: WHERE zxl.APPLICATION_ID = 201
5834: AND zxl.EVENT_CLASS_CODE = NVL2(poll.po_release_id, 'RELEASE', 'PO_PA')
5835: AND zxl.TRX_ID = NVL(poll.po_release_id, poh.po_header_id)
5836: AND zxl.ENTITY_CODE = NVL2(poll.po_release_id, 'RELEASE','PURCHASE_ORDER'));

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

6200: 1 OBJECT_VERSION_NUMBER
6201: FROM (SELECT /*+ use_nl_with_index(recdist ZX_PO_REC_DIST_N1) */
6202: pohzd.*,
6203: recdist.rec_rate d_rec_rate
6204: FROM (SELECT /*+ NO_EXPAND leading(poh) ordered use_nl_with_index(zxl, ZX_LINES_U1) use_nl(pod) */
6205: poh.po_header_id,
6206: poh.set_of_books_id,
6207: poh.last_update_date poh_last_update_date,
6208: zxl.tax_line_id,

Line 6285: zx_lines zxl,

6281: AND upd.ledger_id = fsp.set_of_books_id
6282: AND (trunc(poh.last_update_date) between upd.start_date and upd.end_date)
6283: AND poll.po_header_id = poh.po_header_id
6284: ) poh,
6285: zx_lines zxl,
6286: po_distributions_all pod
6287: WHERE zxl.application_id = 201
6288: AND zxl.entity_code = poh.entity_code
6289: AND zxl.event_class_code = poh.event_class_code