APPS.ARP_ETAX_AUTOINV_UTIL dependencies on RA_INTERFACE_LINES

Line 179: FROM RA_INTERFACE_LINES IL

175: tax_reporting_flag) =
176: (SELECT MAX(document_sub_type),
177: MAX(default_taxation_country),
178: MAX(decode(IL.taxed_upstream_flag,'Y','N','Y'))
179: FROM RA_INTERFACE_LINES IL
180: WHERE HGT.trx_id = IL.customer_trx_id
181: GROUP BY IL.customer_trx_id);
182:
183: IF PG_DEBUG in ('Y', 'C') THEN

Line 310: 'RA_INTERFACE_LINES',

306: SELECT
307: 222,
308: ZTH.entity_code,
309: ZTH.event_class_code,
310: 'RA_INTERFACE_LINES',
311: TL.customer_trx_line_id,
312: TL.customer_trx_id,
313: 'LINE',
314: TL.customer_trx_line_id,

Line 397: RA_INTERFACE_LINES RIL,

393: TL.description
394: FROM
395: RA_CUSTOMER_TRX_LINES TL,
396: RA_CUSTOMER_TRX T,
397: RA_INTERFACE_LINES RIL,
398: ZX_TRX_HEADERS_GT ZTH,
399: HZ_CUST_ACCOUNTS STCA,
400: HZ_CUST_ACCT_SITES STPS,
401: HZ_CUST_SITE_USES STCSU,

Line 499: then are present in ra_interface_lines

495: RAISE;
496: END insert_lines;
497:
498: /* Inserts manual tax lines into IMPORT_GT table when
499: then are present in ra_interface_lines
500:
501: DEV NOTE:
502:
503: 1) Jury is still out on how to link the manual tax lines to

Line 557: 'RA_INTERFACE_LINES',

553: ZTH.internal_organization_id,
554: 222,
555: ZTH.entity_code,
556: ZTH.event_class_code,
557: 'RA_INTERFACE_LINES',
558: RIL.interface_line_id, -- tax line
559: ZTH.trx_id,
560: RIL.link_to_line_id,
561: RIL.tax_regime_code,

Line 576: RA_INTERFACE_LINES RIL, -- tax lines

572: RIL.tax_exempt_number,
573: 'N', -- no rows in zx_trx_tax_link_gt
574: RIL.interface_line_id -- 4698302
575: FROM
576: RA_INTERFACE_LINES RIL, -- tax lines
577: ZX_TRX_HEADERS_GT ZTH
578: WHERE
579: RIL.line_type = 'TAX'
580: AND RIL.request_id = p_request_id

Line 650: FROM ra_interface_lines

646: BEGIN
647:
648: SELECT 1
649: INTO l_ret_val
650: FROM ra_interface_lines
651: WHERE request_id = p_request_id
652: AND line_type = 'TAX'
653: AND reference_line_id is NULL
654: AND rownum = 1;

Line 673: FROM ra_interface_lines

669:
670: BEGIN
671: SELECT 2
672: INTO l_ret_val
673: FROM ra_interface_lines
674: WHERE request_id = p_request_id
675: AND line_type = 'TAX'
676: AND reference_line_id is not NULL
677: AND rownum = 1;

Line 874: ra_interface_lines

870:
871: RESP: They are now allowing me to pass the interface_line_id
872: of the invoice lines and tax lines in -- and they pass them back
873: out. This should be enough to let me get what I need from
874: ra_interface_lines
875:
876: 4) changed zx_detail_tax_lines_gt to zx_lines at request of santosh
877: during IM conv on 25-MAY. Apparently, zx_detail_tax_lines_gt
878: is only for quotes.

Line 975: RA_INTERFACE_LINES mtax,

971: mtax.interface_line_attribute15,
972: plin.org_id
973: FROM ZX_LINES zxt,
974: RA_CUSTOMER_TRX_LINES plin,
975: RA_INTERFACE_LINES mtax,
976: ZX_LINES inv_zxt,
977: RA_CUSTOMER_TRX_LINES inv_lin
978: WHERE plin.request_id = p_request_id
979: AND zxt.application_id = 222

Line 1043: ra_interface_lines il

1039: zxe.trx_line_id,
1040: zxe.message_text,
1041: il.org_id
1042: FROM ZX_VALIDATION_ERRORS_GT zxe,
1043: ra_interface_lines il
1044: WHERE zxe.interface_line_id = il.interface_line_id
1045: AND il.line_type <> 'TAX'
1046: AND zxe.summary_tax_line_number is NULL;
1047:

Line 1078: ra_interface_lines it

1074: 'ZX_TAX_RATE_NOT_ACTIVE', it.tax_rate_code,
1075: NULL),
1076: it.org_id
1077: FROM ZX_VALIDATION_ERRORS_GT zxe,
1078: ra_interface_lines it
1079: WHERE zxe.trx_id = it.customer_trx_id
1080: AND zxe.interface_tax_line_id = it.interface_line_id
1081: AND it.line_type = 'TAX';
1082:

Line 1098: ra_interface_lines it

1094: zxe.message_text,
1095: NULL,
1096: it.org_id
1097: FROM ZX_ERRORS_GT zxe,
1098: ra_interface_lines it
1099: WHERE zxe.trx_id = it.customer_trx_id;
1100:
1101: l_tax_line_errors := l_tax_line_errors + SQL%ROWCOUNT;
1102: debug('rows inserted through zx_errors_gt '||sql%rowcount);