APPS.ARP_ETAX_RECURR_UTIL dependencies on RA_CUSTOMER_TRX_LINES

Line 336: RA_CUSTOMER_TRX_LINES TL,

332: AND gld.account_class = 'REV') account_ccid,
333: TL.description,
334: ML.tax_product_category -- 7661349
335: FROM
336: RA_CUSTOMER_TRX_LINES TL,
337: RA_CUSTOMER_TRX_LINES TL_ORIG,
338: RA_CUSTOMER_TRX T,
339: ZX_TRX_HEADERS_GT ZTH,
340: HZ_CUST_ACCOUNTS STCA,

Line 337: RA_CUSTOMER_TRX_LINES TL_ORIG,

333: TL.description,
334: ML.tax_product_category -- 7661349
335: FROM
336: RA_CUSTOMER_TRX_LINES TL,
337: RA_CUSTOMER_TRX_LINES TL_ORIG,
338: RA_CUSTOMER_TRX T,
339: ZX_TRX_HEADERS_GT ZTH,
340: HZ_CUST_ACCOUNTS STCA,
341: HZ_CUST_ACCT_SITES STPS,

Line 419: then are present in ra_customer_trx_lines (on original invoice)

415: RAISE;
416: END insert_line;
417:
418: /* Inserts manual tax lines into IMPORT_GT table when
419: then are present in ra_customer_trx_lines (on original invoice)
420: with autotax flag set to 'N'
421:
422: DEV NOTE:
423:

Line 450: RA_CUSTOMER_TRX_LINES. At this point, I'm not sure

446:
447: /* NOTE: We are passing the line_id of the original tax line
448: into this table. That means that we can get that same line
449: ID back out when inserting the shadow tax lines into
450: RA_CUSTOMER_TRX_LINES. At this point, I'm not sure
451: we need this, but I thought it was worth noting in case
452: we need to copy DFF values, etc. */
453:
454: INSERT INTO ZX_IMPORT_TAX_LINES_GT

Line 503: RA_CUSTOMER_TRX_LINES orig_line,

499: orig_etax.exempt_certificate_number,
500: 'N', -- no rows in LINK table
501: 0 -- 4698302
502: FROM
503: RA_CUSTOMER_TRX_LINES orig_line,
504: RA_CUSTOMER_TRX_LINES orig_tax,
505: ZX_LINES orig_etax
506: WHERE
507: orig_line.customer_trx_line_id = p_original_line_id

Line 504: RA_CUSTOMER_TRX_LINES orig_tax,

500: 'N', -- no rows in LINK table
501: 0 -- 4698302
502: FROM
503: RA_CUSTOMER_TRX_LINES orig_line,
504: RA_CUSTOMER_TRX_LINES orig_tax,
505: ZX_LINES orig_etax
506: WHERE
507: orig_line.customer_trx_line_id = p_original_line_id
508: AND orig_line.customer_trx_line_id = orig_tax.link_to_cust_trx_line_id

Line 529: RA_CUSTOMER_TRX_LINES accordingly */

525: END insert_tax_lines;
526:
527:
528: /* Procedure to retrieve TAX lines from ZX and populate
529: RA_CUSTOMER_TRX_LINES accordingly */
530: PROCEDURE build_ar_tax_lines(
531: p_request_id IN NUMBER) IS
532:
533: l_rows NUMBER;

Line 544: /* Insert rows into RA_CUSTOMER_TRX_LINES for the

540: /* Dev Notes:
541:
542: End Dev Notes */
543:
544: /* Insert rows into RA_CUSTOMER_TRX_LINES for the
545: new TAX lines */
546: INSERT INTO RA_CUSTOMER_TRX_LINES
547: (
548: CUSTOMER_TRX_LINE_ID,

Line 546: INSERT INTO RA_CUSTOMER_TRX_LINES

542: End Dev Notes */
543:
544: /* Insert rows into RA_CUSTOMER_TRX_LINES for the
545: new TAX lines */
546: INSERT INTO RA_CUSTOMER_TRX_LINES
547: (
548: CUSTOMER_TRX_LINE_ID,
549: LAST_UPDATE_DATE,
550: LAST_UPDATED_BY,

Line 573: ra_customer_trx_lines_s.nextval,

569: TAX_LINE_ID, -- ID in ZX_ table
570: ORG_ID
571: )
572: SELECT
573: ra_customer_trx_lines_s.nextval,
574: sysdate,
575: arp_standard.profile.user_id,
576: sysdate,
577: arp_standard.profile.user_id,

Line 597: RA_CUSTOMER_TRX_LINES plin

593: tax_rate_id,
594: zxt.tax_line_id,
595: plin.org_id
596: FROM ZX_LINES zxt,
597: RA_CUSTOMER_TRX_LINES plin
598: WHERE plin.request_id = p_request_id
599: AND zxt.application_id = 222
600: AND zxt.entity_code = 'TRANSACTIONS'
601: AND zxt.event_class_code in ('INVOICE','DEBIT_MEMO')

Line 761: /* Pull resulting tax lines and populate RA_CUSTOMER_TRX_LINES */

757:
758: /* retrieve validation errors and display them in log */
759: retrieve_tax_validation_errors(p_error_count);
760:
761: /* Pull resulting tax lines and populate RA_CUSTOMER_TRX_LINES */
762: build_ar_tax_lines(p_request_id);
763: END IF;
764:
765: /* 4904679 - removed detect_missing_tax_lines */