APPS.ARP_ETAX_RECURR_UTIL dependencies on RA_CUSTOMER_TRX_LINES

Line 329: RA_CUSTOMER_TRX_LINES TL,

325: AND gld.account_class = 'REV') account_ccid,
326: TL.description,
327: ML.tax_product_category
328: FROM
329: RA_CUSTOMER_TRX_LINES TL,
330: RA_CUSTOMER_TRX_LINES TL_ORIG,
331: RA_CUSTOMER_TRX T,
332: ZX_TRX_HEADERS_GT ZTH,
333: HZ_CUST_ACCOUNTS STCA,

Line 330: RA_CUSTOMER_TRX_LINES TL_ORIG,

326: TL.description,
327: ML.tax_product_category
328: FROM
329: RA_CUSTOMER_TRX_LINES TL,
330: RA_CUSTOMER_TRX_LINES TL_ORIG,
331: RA_CUSTOMER_TRX T,
332: ZX_TRX_HEADERS_GT ZTH,
333: HZ_CUST_ACCOUNTS STCA,
334: HZ_CUST_ACCT_SITES STPS,

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

400: RAISE;
401: END insert_line;
402:
403: /* Inserts manual tax lines into IMPORT_GT table when
404: then are present in ra_customer_trx_lines (on original invoice)
405: with autotax flag set to 'N'
406:
407: DEV NOTE:
408:

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

431:
432: /* NOTE: We are passing the line_id of the original tax line
433: into this table. That means that we can get that same line
434: ID back out when inserting the shadow tax lines into
435: RA_CUSTOMER_TRX_LINES. At this point, I'm not sure
436: we need this, but I thought it was worth noting in case
437: we need to copy DFF values, etc. */
438:
439: INSERT INTO ZX_IMPORT_TAX_LINES_GT

Line 488: RA_CUSTOMER_TRX_LINES orig_line,

484: orig_etax.exempt_certificate_number,
485: 'N', -- no rows in LINK table
486: 0 -- 4698302
487: FROM
488: RA_CUSTOMER_TRX_LINES orig_line,
489: RA_CUSTOMER_TRX_LINES orig_tax,
490: ZX_LINES orig_etax
491: WHERE
492: orig_line.customer_trx_line_id = p_original_line_id

Line 489: RA_CUSTOMER_TRX_LINES orig_tax,

485: 'N', -- no rows in LINK table
486: 0 -- 4698302
487: FROM
488: RA_CUSTOMER_TRX_LINES orig_line,
489: RA_CUSTOMER_TRX_LINES orig_tax,
490: ZX_LINES orig_etax
491: WHERE
492: orig_line.customer_trx_line_id = p_original_line_id
493: AND orig_line.customer_trx_line_id = orig_tax.link_to_cust_trx_line_id

Line 514: RA_CUSTOMER_TRX_LINES accordingly */

510: END insert_tax_lines;
511:
512:
513: /* Procedure to retrieve TAX lines from ZX and populate
514: RA_CUSTOMER_TRX_LINES accordingly */
515: PROCEDURE build_ar_tax_lines(
516: p_request_id IN NUMBER) IS
517:
518: l_rows NUMBER;

Line 529: /* Insert rows into RA_CUSTOMER_TRX_LINES for the

525: /* Dev Notes:
526:
527: End Dev Notes */
528:
529: /* Insert rows into RA_CUSTOMER_TRX_LINES for the
530: new TAX lines */
531: INSERT INTO RA_CUSTOMER_TRX_LINES
532: (
533: CUSTOMER_TRX_LINE_ID,

Line 531: INSERT INTO RA_CUSTOMER_TRX_LINES

527: End Dev Notes */
528:
529: /* Insert rows into RA_CUSTOMER_TRX_LINES for the
530: new TAX lines */
531: INSERT INTO RA_CUSTOMER_TRX_LINES
532: (
533: CUSTOMER_TRX_LINE_ID,
534: LAST_UPDATE_DATE,
535: LAST_UPDATED_BY,

Line 558: ra_customer_trx_lines_s.nextval,

554: TAX_LINE_ID, -- ID in ZX_ table
555: ORG_ID
556: )
557: SELECT
558: ra_customer_trx_lines_s.nextval,
559: sysdate,
560: arp_standard.profile.user_id,
561: sysdate,
562: arp_standard.profile.user_id,

Line 582: RA_CUSTOMER_TRX_LINES plin

578: tax_rate_id,
579: zxt.tax_line_id,
580: plin.org_id
581: FROM ZX_LINES zxt,
582: RA_CUSTOMER_TRX_LINES plin
583: WHERE plin.request_id = p_request_id
584: AND zxt.application_id = 222
585: AND zxt.entity_code = 'TRANSACTIONS'
586: AND zxt.event_class_code in ('INVOICE','DEBIT_MEMO')

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

733:
734: /* Call import_document_with_tax */
735: calculate_tax_for_copy;
736:
737: /* Pull resulting tax lines and populate RA_CUSTOMER_TRX_LINES */
738: build_ar_tax_lines(p_request_id);
739: END IF;
740:
741: /* 4904679 - removed detect_missing_tax_lines */