[Home] [Help]
391: AND gld.account_class = 'REV'
392: AND gld.request_id = tl.request_id) account_ccid,
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,
402: RA_CUSTOMER_TRX IT,
403: RA_CUST_TRX_TYPES ITT,
404: RA_CUSTOMER_TRX_LINES ITL,
405: RA_CUST_TRX_LINE_GL_DIST REC,
406: HZ_PARTY_SITES STPSU,
407: HZ_PARTY_SITES BTPSU,
408: HR_ALL_ORGANIZATION_UNITS HR,
820:
821: END populate_ebt_gt;
822:
823: /* Procedure to retrieve TAX lines from ZX and populate
824: RA_CUSTOMER_TRX_LINES accordingly
825:
826: 06-JAN-2006 M Raymond 4740826 - Added code to retrieve
827: tax classifications back
828: from etax and stamp them
862: 3-MAR-05 along with my suggestion which was to have them add
863: a 45th column for link_to_trx_line_id or perhaps applied_to_trx_line_id
864: The idea for this is that they pass me the eTax line_id of the target
865: tax line and I use that to fetch the customer_trx_line_id of the
866: corresponding line in ra_customer_trx_lines.
867:
868: However, I'll probably need an index based on tax_line_id in
869: RA_CUSTOMER_TRX_LINES table to make that search fast enough
870:
865: tax line and I use that to fetch the customer_trx_line_id of the
866: corresponding line in ra_customer_trx_lines.
867:
868: However, I'll probably need an index based on tax_line_id in
869: RA_CUSTOMER_TRX_LINES table to make that search fast enough
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
883: 6) ORA-28115 raised because we were not setting org_id
884: End Dev Notes */
885:
886:
887: /* Insert rows into RA_CUSTOMER_TRX_LINES for the
888: new TAX lines */
889: INSERT INTO RA_CUSTOMER_TRX_LINES
890: (
891: CUSTOMER_TRX_LINE_ID,
885:
886:
887: /* Insert rows into RA_CUSTOMER_TRX_LINES for the
888: new TAX lines */
889: INSERT INTO RA_CUSTOMER_TRX_LINES
890: (
891: CUSTOMER_TRX_LINE_ID,
892: LAST_UPDATE_DATE,
893: LAST_UPDATED_BY,
929: INTERFACE_LINE_ATTRIBUTE15,
930: ORG_ID
931: )
932: SELECT
933: NVL(mtax.interface_line_id,ra_customer_trx_lines_s.nextval),
934: sysdate,
935: arp_standard.profile.user_id,
936: sysdate,
937: arp_standard.profile.user_id,
970: mtax.interface_line_attribute14,
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
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
980: AND zxt.entity_code = 'TRANSACTIONS'
981: AND zxt.event_class_code in ('INVOICE','DEBIT_MEMO','CREDIT_MEMO')
1156: THEN
1157: /* retrieve validation errors and populate RA_INTERFACE_ERRORS */
1158: retrieve_tax_validation_errors(p_error_count);
1159:
1160: /* Pull resulting tax lines and populate RA_CUSTOMER_TRX_LINES */
1161: build_ar_tax_lines(p_request_id, p_phase);
1162: END IF;
1163:
1164: IF PG_DEBUG in ('Y', 'C')