[Home] [Help]
297: SELECT
298: 222,
299: ZTH.entity_code,
300: ZTH.event_class_code,
301: 'AR_TRX_LINES_GT', -- interface_entity_code
302: TLG.trx_line_id, -- interface_entity_line_id
303: TL.customer_trx_id,
304: 'LINE',
305: TL.customer_trx_line_id,
369: TL.description
370: FROM
371: RA_CUSTOMER_TRX_LINES TL,
372: RA_CUSTOMER_TRX T,
373: AR_TRX_LINES_GT TLG,
374: ZX_TRX_HEADERS_GT ZTH,
375: HZ_CUST_ACCOUNTS STCA,
376: HZ_CUST_ACCT_SITES STPS,
377: HZ_CUST_SITE_USES STCSU,
486: ZTH.internal_organization_id,
487: 222,
488: ZTH.entity_code,
489: ZTH.event_class_code,
490: 'AR_TRX_LINES_GT',
491: GTL.trx_line_id, -- tax line in AR_GT table
492: ZTH.trx_id,
493: GTL.link_to_cust_trx_line_id,
494: GTL.tax_regime_code,
505: GTL.tax_exempt_number,
506: 'N', -- no lines in LINK table
507: GTL.trx_line_id -- 4698302
508: FROM
509: AR_TRX_LINES_GT GTL, -- tax lines
510: ZX_TRX_HEADERS_GT ZTH
511: WHERE
512: GTL.line_type = 'TAX'
513: AND GTL.customer_trx_id = ZTH.trx_id;
698: mtax.interface_line_attribute15,
699: plin.org_id
700: FROM ZX_LINES zxt,
701: RA_CUSTOMER_TRX_LINES plin,
702: AR_TRX_LINES_GT mtax
703: WHERE plin.request_id = p_request_id
704: AND zxt.application_id = 222
705: AND zxt.entity_code = 'TRANSACTIONS'
706: /* 7166862 */
796: mtax.interface_line_attribute15,
797: plin.org_id
798: FROM ZX_LINES zxt,
799: RA_CUSTOMER_TRX_LINES plin,
800: AR_TRX_LINES_GT mtax
801: WHERE plin.request_id = p_request_id
802: AND zxt.application_id = 222
803: AND zxt.entity_code = 'TRANSACTIONS'
804: /* 7166862 */
859: il.trx_header_id,
860: il.trx_line_id,
861: zxe.message_text
862: FROM ZX_VALIDATION_ERRORS_GT zxe,
863: AR_TRX_LINES_GT il
864: WHERE nvl(zxe.interface_tax_line_id, zxe.interface_line_id) = il.trx_line_id;
865:
866: l_trx_line_errors := SQL%ROWCOUNT;
867: