APPS.ARP_ETAX_INVAPI_UTIL dependencies on RA_CUSTOMER_TRX_LINES

Line 375: RA_CUSTOMER_TRX_LINES TL,

371: WHERE gld.customer_trx_line_id = TL.customer_trx_line_id
372: AND gld.account_class = 'REV') account_ccid,
373: TL.description
374: FROM
375: RA_CUSTOMER_TRX_LINES TL,
376: RA_CUSTOMER_TRX T,
377: AR_TRX_LINES_GT TLG,
378: ZX_TRX_HEADERS_GT ZTH,
379: HZ_CUST_ACCOUNTS STCA,

Line 602: RA_CUSTOMER_TRX_LINES accordingly */

598:
599: END populate_ebt_gt;
600:
601: /* Procedure to retrieve TAX lines from ZX and populate
602: RA_CUSTOMER_TRX_LINES accordingly */
603: PROCEDURE build_ar_tax_lines(p_request_id IN NUMBER) IS
604:
605: l_rows1 NUMBER;
606: l_rows2 NUMBER;

Line 627: /* Insert rows into RA_CUSTOMER_TRX_LINES for the

623: conv on 25-MAY
624:
625: End Dev Notes */
626:
627: /* Insert rows into RA_CUSTOMER_TRX_LINES for the
628: new TAX lines */
629: /*4410461 Breaking the insert into two for Manual and Automatic Tax lines*/
630:
631: INSERT INTO RA_CUSTOMER_TRX_LINES

Line 631: INSERT INTO RA_CUSTOMER_TRX_LINES

627: /* Insert rows into RA_CUSTOMER_TRX_LINES for the
628: new TAX lines */
629: /*4410461 Breaking the insert into two for Manual and Automatic Tax lines*/
630:
631: INSERT INTO RA_CUSTOMER_TRX_LINES
632: (
633: CUSTOMER_TRX_LINE_ID,
634: LAST_UPDATE_DATE,
635: LAST_UPDATED_BY,

Line 714: RA_CUSTOMER_TRX_LINES plin,

710: mtax.interface_line_attribute14,
711: mtax.interface_line_attribute15,
712: plin.org_id
713: FROM ZX_LINES zxt,
714: RA_CUSTOMER_TRX_LINES plin,
715: AR_TRX_LINES_GT mtax
716: WHERE plin.request_id = p_request_id
717: AND zxt.application_id = 222
718: AND zxt.entity_code = 'TRANSACTIONS'

Line 729: INSERT INTO RA_CUSTOMER_TRX_LINES

725: AND zxt.interface_tax_line_id = mtax.trx_line_id (+);
726:
727: l_rows1 := SQL%ROWCOUNT;
728:
729: INSERT INTO RA_CUSTOMER_TRX_LINES
730: (
731: CUSTOMER_TRX_LINE_ID,
732: LAST_UPDATE_DATE,
733: LAST_UPDATED_BY,

Line 772: ra_customer_trx_lines_s.nextval,

768: INTERFACE_LINE_ATTRIBUTE15,
769: ORG_ID
770: )
771: SELECT
772: ra_customer_trx_lines_s.nextval,
773: sysdate,
774: arp_standard.profile.user_id,
775: sysdate,
776: arp_standard.profile.user_id,

Line 812: RA_CUSTOMER_TRX_LINES plin,

808: mtax.interface_line_attribute14,
809: mtax.interface_line_attribute15,
810: plin.org_id
811: FROM ZX_LINES zxt,
812: RA_CUSTOMER_TRX_LINES plin,
813: AR_TRX_LINES_GT mtax
814: WHERE plin.request_id = p_request_id
815: AND zxt.application_id = 222
816: AND zxt.entity_code = 'TRANSACTIONS'

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

957: THEN
958: /* retrieve validation errors and populate RA_INTERFACE_ERRORS */
959: retrieve_tax_validation_errors(p_error_count);
960:
961: /* Pull resulting tax lines and populate RA_CUSTOMER_TRX_LINES */
962: build_ar_tax_lines(p_request_id);
963: END IF;
964:
965: /* 4904679 - removed logic to detect missing tax lines */