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 476: /* Insert All Taxable Lines into ZX_LINES_DET_FACTORS. Incase there are No taxable lines,

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

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

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

Line 482: INTO ZX_LINES_DET_FACTORS(

478: trx_line_id = -9999) */
479:
480: INSERT ALL
481: WHEN trx_line_type IN ('LINE' ,'CB') THEN
482: INTO ZX_LINES_DET_FACTORS(
483: INTERNAL_ORGANIZATION_ID
484: ,APPLICATION_ID
485: ,ENTITY_CODE
486: ,EVENT_CLASS_CODE

Line 847: INTO ZX_LINES (

843: ,LAST_UPDATED_BY
844: ,LAST_UPDATE_LOGIN
845: )
846: WHEN (trx_line_type = 'TAX') THEN
847: INTO ZX_LINES (
848: TAX_LINE_ID
849: ,INTERNAL_ORGANIZATION_ID
850: ,APPLICATION_ID
851: ,ENTITY_CODE

Line 1712: -- zx_lines columns start from here

1708: --NULL TRX_LINE_PRECISION,
1709: --NULL TRX_LINE_MAU,
1710: --NULL TRX_LINE_CURRENCY_CONV_TYPE,
1711:
1712: -- zx_lines columns start from here
1713:
1714: custtrxl.tax_line_id TAX_LINE_ID,
1715: DECODE(custtrxl.line_type,
1716: 'TAX', RANK() OVER (

Line 2187: (SELECT 1 FROM zx_lines_det_factors zxl

2183: AND rates.tax_status_code = status.tax_status_code(+)
2184: AND rates.content_owner_id = status.content_owner_id(+)
2185: AND NVL(arsysparam.tax_code, '!') <> 'Localization'
2186: AND NOT EXISTS
2187: (SELECT 1 FROM zx_lines_det_factors zxl
2188: WHERE zxl.APPLICATION_ID = 222
2189: AND zxl.EVENT_CLASS_CODE = DECODE(types.type,
2190: 'INV','INVOICE',
2191: 'CM', 'CREDIT_MEMO',

Line 2246: -- Insert data into zx_lines_det_factors and zx_lines_summary

2242: END IF;
2243:
2244: x_retcode := CONC_SUCCESS;
2245:
2246: -- Insert data into zx_lines_det_factors and zx_lines_summary
2247: --
2248: INSERT ALL
2249: WHEN AP_LINE_LOOKUP_CODE IN ('ITEM', 'PREPAY','FREIGHT','MISCELLANEOUS') OR
2250: TAX_ONLY_LINE_FLAG = 'Y'

Line 2252: INTO ZX_LINES_DET_FACTORS (

2248: INSERT ALL
2249: WHEN AP_LINE_LOOKUP_CODE IN ('ITEM', 'PREPAY','FREIGHT','MISCELLANEOUS') OR
2250: TAX_ONLY_LINE_FLAG = 'Y'
2251: THEN
2252: INTO ZX_LINES_DET_FACTORS (
2253: --EVENT_ID
2254: OBJECT_VERSION_NUMBER
2255: ,INTERNAL_ORGANIZATION_ID
2256: ,APPLICATION_ID

Line 2487: INTO ZX_LINES_SUMMARY (

2483: ,BILL_THIRD_PTY_ACCT_ID
2484: ,BILL_THIRD_PTY_ACCT_SITE_ID
2485: )
2486: WHEN AP_LINE_LOOKUP_CODE = 'TAX' THEN
2487: INTO ZX_LINES_SUMMARY (
2488: SUMMARY_TAX_LINE_ID
2489: ,INTERNAL_ORGANIZATION_ID
2490: ,APPLICATION_ID
2491: ,ENTITY_CODE

Line 2961: (SELECT 1 FROM zx_lines_Det_Factors zxdet

2957: AND ptp.party_type_code = 'OU'
2958: AND ptp.party_id = DECODE(l_multi_org_flag,'N',l_org_id,lines.org_id)
2959: AND NVL(inv.historical_flag, 'N') = 'Y'
2960: AND NOT EXISTS
2961: (SELECT 1 FROM zx_lines_Det_Factors zxdet
2962: WHERE zxdet.APPLICATION_ID = 200
2963: AND zxdet.ENTITY_CODE = 'AP_INVOICES'
2964: AND zxdet.event_class_code = DECODE(inv.INVOICE_TYPE_LOOKUP_CODE,
2965: 'STANDARD', 'STANDARD INVOICES',

Line 2980: -- Insert data into zx_lines and zx_rec_nrec_dist

2976: 'INTEREST INVOICE', 'INTEREST INVOICES','NA')
2977: AND zxdet.TRX_ID = inv.invoice_id);
2978:
2979:
2980: -- Insert data into zx_lines and zx_rec_nrec_dist
2981: --
2982: INSERT ALL
2983: INTO ZX_REC_NREC_DIST(
2984: TAX_LINE_ID

Line 3124: ZX_LINES_S.NEXTVAL

3120: ,ACCOUNT_SOURCE_TAX_RATE_ID
3121: ,RECOVERY_RATE_ID
3122: )
3123: VALUES(
3124: ZX_LINES_S.NEXTVAL
3125: ,REC_NREC_TAX_DIST_ID
3126: ,REC_NREC_TAX_DIST_NUMBER
3127: ,200
3128: ,CONTENT_OWNER_ID

Line 3263: INTO ZX_LINES(

3259: ,DEF_REC_SETTLEMENT_OPTION_CODE
3260: ,ACCOUNT_SOURCE_TAX_RATE_ID
3261: ,RECOVERY_RATE_ID
3262: )
3263: INTO ZX_LINES(
3264: TAX_LINE_ID
3265: ,TAX_LINE_NUMBER
3266: ,APPLICATION_ID
3267: ,CONTENT_OWNER_ID

Line 3420: ZX_LINES_S.NEXTVAL

3416: ,LEGAL_REPORTING_STATUS
3417: ,ACCOUNT_SOURCE_TAX_RATE_ID
3418: )
3419: VALUES (
3420: ZX_LINES_S.NEXTVAL
3421: ,TAX_LINE_NUMBER
3422: ,200
3423: ,CONTENT_OWNER_ID
3424: ,CURRENCY_CONVERSION_DATE

Line 3849: (SELECT 1 FROM zx_lines zxl

3845: AND ptp.party_type_code = 'OU'
3846: AND ptp.party_id = DECODE(l_multi_org_flag,'N', l_org_id, ap_dists.org_id)
3847: AND NVL(inv.historical_flag, 'N') = 'Y'
3848: AND NOT EXISTS
3849: (SELECT 1 FROM zx_lines zxl
3850: WHERE zxl.application_id = 200
3851: AND zxl.event_class_code = DECODE(inv.INVOICE_TYPE_LOOKUP_CODE,
3852: 'STANDARD', 'STANDARD INVOICES',
3853: 'CREDIT' , 'STANDARD INVOICES',

Line 3919: INSERT INTO ZX_LINES_DET_FACTORS (

3915: ZX_PO_REC_PKG.get_rec_info(
3916: p_start_rowid => p_start_rowid,
3917: p_end_rowid => p_end_rowid);
3918:
3919: INSERT INTO ZX_LINES_DET_FACTORS (
3920: -- ,EVENT_ID
3921: -- ,ACCOUNT_CCID
3922: -- ,ACCOUNT_STRING
3923: -- ,ADJUSTED_DOC_APPLICATION_ID

Line 4328: (SELECT 1 FROM zx_lines_Det_Factors zxdet

4324: AND ptp.party_id = DECODE(l_multi_org_flag,'N',l_org_id,poll.org_id)
4325: AND ptp.party_type_code = 'OU'
4326: AND hr.location_id(+) = poll.ship_to_location_id
4327: AND NOT EXISTS
4328: (SELECT 1 FROM zx_lines_Det_Factors zxdet
4329: WHERE zxdet.APPLICATION_ID = 201
4330: AND zxdet.ENTITY_CODE = NVL2(poll.po_release_id, 'RELEASE', 'PURCHASE_ORDER')
4331: AND zxdet.EVENT_CLASS_CODE = NVL2(poll.po_release_id, 'RELEASE', 'PO_PA')
4332: AND zxdet.TRX_ID = NVL(poll.po_release_id,poh.po_header_id)

Line 4335: INSERT INTO ZX_LINES(

4331: AND zxdet.EVENT_CLASS_CODE = NVL2(poll.po_release_id, 'RELEASE', 'PO_PA')
4332: AND zxdet.TRX_ID = NVL(poll.po_release_id,poh.po_header_id)
4333: );
4334:
4335: INSERT INTO ZX_LINES(
4336: -- ,ADJUSTED_DOC_APPLICATION_ID
4337: -- ,ADJUSTED_DOC_DATE
4338: -- ,ADJUSTED_DOC_ENTITY_CODE
4339: -- ,ADJUSTED_DOC_EVENT_CLASS_CODE

Line 4923: zx_lines_s.nextval TAX_LINE_ID,

4919: -- NULL TAX_HOLD_RELEASED_CODE,
4920: taxes.tax_id TAX_ID,
4921: -- NULL TAX_JURISDICTION_CODE,
4922: -- NULL TAX_JURISDICTION_ID,
4923: zx_lines_s.nextval TAX_LINE_ID,
4924: RANK() OVER
4925: (PARTITION BY
4926: NVL(poll.po_release_id,
4927: poh.po_header_id)

Line 5041: (SELECT 1 FROM zx_lines zxl

5037: AND status.tax(+) = rates.tax
5038: AND status.content_owner_id(+) = rates.content_owner_id
5039: AND status.tax_status_code(+) = rates.tax_status_code
5040: AND NOT EXISTS
5041: (SELECT 1 FROM zx_lines zxl
5042: WHERE zxl.APPLICATION_ID = 201
5043: AND zxl.EVENT_CLASS_CODE = NVL2(poll.po_release_id, 'RELEASE', 'PO_PA')
5044: AND zxl.TRX_ID = NVL(poll.po_release_id, poh.po_header_id)
5045: AND zxl.ENTITY_CODE = NVL2(poll.po_release_id, 'RELEASE','PURCHASE_ORDER'));

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

5374: 1 OBJECT_VERSION_NUMBER
5375: FROM (SELECT /*+ use_nl_with_index(recdist ZX_PO_REC_DIST_N1) */
5376: pohzd.*,
5377: recdist.rec_rate d_rec_rate
5378: FROM (SELECT /*+ NO_EXPAND leading(poh) use_nl_with_index(zxl, ZX_LINES_U1) use_nl(pod) */
5379: poh.po_header_id,
5380: poh.set_of_books_id,
5381: zxl.*,
5382: pod.po_distribution_id p_po_distribution_id,

Line 5426: zx_lines zxl,

5422: AND upd.ledger_id = fsp.set_of_books_id
5423: AND (poh.last_update_date between upd.start_date and upd.end_date)
5424: AND poll.po_header_id = poh.po_header_id
5425: ) poh,
5426: zx_lines zxl,
5427: po_distributions_all pod
5428: WHERE zxl.application_id = 201
5429: AND zxl.entity_code = poh.entity_code
5430: AND zxl.event_class_code = poh.event_class_code