APPS.ARP_ETAX_AUTOINV_UTIL dependencies on RA_INTERFACE_LINES

Line 185: FROM RA_INTERFACE_LINES IL

181: MAX(default_taxation_country),
182: MAX(decode(IL.taxed_upstream_flag,'Y','N','Y')),
183: MAX(IL.tax_invoice_date),
184: MAX(IL.tax_invoice_number)
185: FROM RA_INTERFACE_LINES IL
186: WHERE HGT.trx_id = IL.customer_trx_id
187: GROUP BY IL.customer_trx_id);
188:
189: IF PG_DEBUG in ('Y', 'C') THEN

Line 319: 'RA_INTERFACE_LINES',

315: SELECT
316: 222,
317: ZTH.entity_code,
318: ZTH.event_class_code,
319: 'RA_INTERFACE_LINES',
320: TL.customer_trx_line_id,
321: TL.customer_trx_id,
322: 'LINE',
323: TL.customer_trx_line_id,

Line 412: RA_INTERFACE_LINES RIL,

408: TL.description
409: FROM
410: RA_CUSTOMER_TRX_LINES TL,
411: RA_CUSTOMER_TRX T,
412: RA_INTERFACE_LINES RIL,
413: ZX_TRX_HEADERS_GT ZTH,
414: HZ_CUST_ACCOUNTS STCA,
415: HZ_CUST_ACCT_SITES STPS,
416: HZ_CUST_SITE_USES STCSU,

Line 514: then are present in ra_interface_lines

510: RAISE;
511: END insert_lines;
512:
513: /* Inserts manual tax lines into IMPORT_GT table when
514: then are present in ra_interface_lines
515:
516: DEV NOTE:
517:
518: 1) Jury is still out on how to link the manual tax lines to

Line 572: 'RA_INTERFACE_LINES',

568: ZTH.internal_organization_id,
569: 222,
570: ZTH.entity_code,
571: ZTH.event_class_code,
572: 'RA_INTERFACE_LINES',
573: RIL.interface_line_id, -- tax line
574: ZTH.trx_id,
575: RIL.link_to_line_id,
576: RIL.tax_regime_code,

Line 591: RA_INTERFACE_LINES RIL, -- tax lines

587: RIL.tax_exempt_number,
588: 'N', -- no rows in zx_trx_tax_link_gt
589: RIL.interface_line_id -- 4698302
590: FROM
591: RA_INTERFACE_LINES RIL, -- tax lines
592: ZX_TRX_HEADERS_GT ZTH
593: WHERE
594: RIL.line_type = 'TAX'
595: AND RIL.request_id = p_request_id

Line 665: FROM ra_interface_lines

661: BEGIN
662:
663: SELECT 1
664: INTO l_ret_val
665: FROM ra_interface_lines
666: WHERE request_id = p_request_id
667: AND line_type = 'TAX'
668: AND reference_line_id is NULL
669: AND rownum = 1;

Line 688: FROM ra_interface_lines

684:
685: BEGIN
686: SELECT 2
687: INTO l_ret_val
688: FROM ra_interface_lines
689: WHERE request_id = p_request_id
690: AND line_type = 'TAX'
691: AND reference_line_id is not NULL
692: AND rownum = 1;

Line 889: ra_interface_lines

885:
886: RESP: They are now allowing me to pass the interface_line_id
887: of the invoice lines and tax lines in -- and they pass them back
888: out. This should be enough to let me get what I need from
889: ra_interface_lines
890:
891: 4) changed zx_detail_tax_lines_gt to zx_lines at request of santosh
892: during IM conv on 25-MAY. Apparently, zx_detail_tax_lines_gt
893: is only for quotes.

Line 994: RA_INTERFACE_LINES mtax,

990: mtax.interface_line_attribute15,
991: plin.org_id
992: FROM ZX_LINES zxt,
993: RA_CUSTOMER_TRX_LINES plin,
994: RA_INTERFACE_LINES mtax,
995: ZX_LINES inv_zxt,
996: RA_CUSTOMER_TRX_LINES inv_lin
997: WHERE plin.request_id = p_request_id
998: AND zxt.application_id = 222

Line 1063: ra_interface_lines il

1059: il.interface_line_id,
1060: zxe.message_text,
1061: il.org_id
1062: FROM ZX_VALIDATION_ERRORS_GT zxe,
1063: ra_interface_lines il
1064: WHERE zxe.trx_id = il.customer_trx_id
1065: AND NVL(zxe.interface_line_id, NVL(zxe.trx_line_id,
1066: il.interface_line_id)) = il.interface_line_id
1067: AND il.line_type <> 'TAX'

Line 1100: ra_interface_lines it

1096: 'ZX_TAX_RATE_NOT_ACTIVE', it.tax_rate_code,
1097: NULL),
1098: it.org_id
1099: FROM ZX_VALIDATION_ERRORS_GT zxe,
1100: ra_interface_lines it
1101: WHERE zxe.trx_id = it.customer_trx_id
1102: AND zxe.interface_tax_line_id = it.interface_line_id
1103: AND it.line_type = 'TAX';
1104:

Line 1120: ra_interface_lines it

1116: zxe.message_text,
1117: NULL,
1118: it.org_id
1119: FROM ZX_ERRORS_GT zxe,
1120: ra_interface_lines it
1121: WHERE zxe.trx_id = it.customer_trx_id;
1122:
1123: l_tax_line_errors := l_tax_line_errors + SQL%ROWCOUNT;
1124: debug('rows inserted through zx_errors_gt '||sql%rowcount);