[Home] [Help]
140: DECODE(REL_T.customer_trx_id, NULL, NULL, REL_T.trx_number),
141: DECODE(REL_T.customer_trx_id, NULL, NULL, REL_T.trx_date),
142: T.bill_to_customer_id, -- bill_third_pty_acct_id
143: BTPS.cust_acct_site_id -- bill_third_pty_acct_site_id
144: FROM RA_CUSTOMER_TRX T,
145: RA_CUST_TRX_TYPES TT,
146: RA_BATCH_SOURCES TB,
147: FND_CURRENCIES C,
148: FND_DOCUMENT_SEQUENCES SEQ,
150: HZ_CUST_ACCOUNTS BTCA,
151: HZ_CUST_SITE_USES BTCSU,
152: HZ_CUST_ACCT_SITES BTPS,
153: HR_ORGANIZATION_UNITS HR,
154: RA_CUSTOMER_TRX REL_T,
155: RA_CUST_TRX_TYPES REL_TT
156: WHERE T.request_id = p_request_id
157: AND T.invoice_currency_code = C.currency_code
158: AND T.org_id = AR.org_id
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,
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,
380: HZ_CUST_ACCT_SITES STPS,
415: update zx_transaction_lines ZXL
416: set (poo_party_id, poo_location_id) =
417: (select SR_PER.organization_id, -- poo_party_id
418: SR_HRL.location_id -- poo_location_id
419: from RA_CUSTOMER_TRX TRX,
420: JTF_RS_SALESREPS SR,
421: PER_ALL_ASSIGNMENTS_F SR_PER,
422: HR_ORGANIZATION_UNITS SR_HRL
423: where TRX.customer_trx_id = ZXL.trx_id
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;
606: l_rows2 NUMBER;
607: /* Bug 9585582 */
608: CURSOR ctt IS
609: SELECT DISTINCT types.type
610: FROM ra_customer_trx trx ,
611: ra_cust_trx_types types
612: WHERE trx.cust_trx_type_id = types.cust_trx_type_id
613: AND trx.request_id=p_request_id;
614:
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
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,
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'
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,
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,
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'
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 */