APPS.ARP_ETAX_INVAPI_UTIL dependencies on RA_CUSTOMER_TRX_LINES

Line 371: RA_CUSTOMER_TRX_LINES TL,

367: WHERE gld.customer_trx_line_id = TL.customer_trx_line_id
368: AND gld.account_class = 'REV') account_ccid,
369: TL.description
370: FROM
371: RA_CUSTOMER_TRX_LINES TL,
372: RA_CUSTOMER_TRX T,
373: AR_TRX_LINES_GT TLG,
374: ZX_TRX_HEADERS_GT ZTH,
375: HZ_CUST_ACCOUNTS STCA,

Line 598: RA_CUSTOMER_TRX_LINES accordingly */

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

Line 614: /* Insert rows into RA_CUSTOMER_TRX_LINES for the

610: conv on 25-MAY
611:
612: End Dev Notes */
613:
614: /* Insert rows into RA_CUSTOMER_TRX_LINES for the
615: new TAX lines */
616: /*4410461 Breaking the insert into two for Manual and Automatic Tax lines*/
617:
618: INSERT INTO RA_CUSTOMER_TRX_LINES

Line 618: INSERT INTO RA_CUSTOMER_TRX_LINES

614: /* Insert rows into RA_CUSTOMER_TRX_LINES for the
615: new TAX lines */
616: /*4410461 Breaking the insert into two for Manual and Automatic Tax lines*/
617:
618: INSERT INTO RA_CUSTOMER_TRX_LINES
619: (
620: CUSTOMER_TRX_LINE_ID,
621: LAST_UPDATE_DATE,
622: LAST_UPDATED_BY,

Line 701: RA_CUSTOMER_TRX_LINES plin,

697: mtax.interface_line_attribute14,
698: mtax.interface_line_attribute15,
699: plin.org_id
700: FROM ZX_LINES zxt,
701: RA_CUSTOMER_TRX_LINES plin,
702: AR_TRX_LINES_GT mtax
703: WHERE plin.request_id = p_request_id
704: AND zxt.application_id = 222
705: AND zxt.entity_code = 'TRANSACTIONS'

Line 716: INSERT INTO RA_CUSTOMER_TRX_LINES

712: AND zxt.interface_tax_line_id = mtax.trx_line_id (+);
713:
714: l_rows1 := SQL%ROWCOUNT;
715:
716: INSERT INTO RA_CUSTOMER_TRX_LINES
717: (
718: CUSTOMER_TRX_LINE_ID,
719: LAST_UPDATE_DATE,
720: LAST_UPDATED_BY,

Line 759: ra_customer_trx_lines_s.nextval,

755: INTERFACE_LINE_ATTRIBUTE15,
756: ORG_ID
757: )
758: SELECT
759: ra_customer_trx_lines_s.nextval,
760: sysdate,
761: arp_standard.profile.user_id,
762: sysdate,
763: arp_standard.profile.user_id,

Line 799: RA_CUSTOMER_TRX_LINES plin,

795: mtax.interface_line_attribute14,
796: mtax.interface_line_attribute15,
797: plin.org_id
798: FROM ZX_LINES zxt,
799: RA_CUSTOMER_TRX_LINES plin,
800: AR_TRX_LINES_GT mtax
801: WHERE plin.request_id = p_request_id
802: AND zxt.application_id = 222
803: AND zxt.entity_code = 'TRANSACTIONS'

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

909: THEN
910: /* retrieve validation errors and populate RA_INTERFACE_ERRORS */
911: retrieve_tax_validation_errors(p_error_count);
912:
913: /* Pull resulting tax lines and populate RA_CUSTOMER_TRX_LINES */
914: build_ar_tax_lines(p_request_id);
915: END IF;
916:
917: /* 4904679 - removed logic to detect missing tax lines */