[Home] [Help]
136: 'CM', 'CREDIT_MEMO')),
137: DECODE(REL_T.customer_trx_id, NULL, NULL, REL_T.customer_trx_id),
138: DECODE(REL_T.customer_trx_id, NULL, NULL, REL_T.trx_number),
139: DECODE(REL_T.customer_trx_id, NULL, NULL, REL_T.trx_date)
140: FROM RA_CUSTOMER_TRX T,
141: RA_CUST_TRX_TYPES TT,
142: RA_BATCH_SOURCES TB,
143: FND_CURRENCIES C,
144: FND_DOCUMENT_SEQUENCES SEQ,
146: HZ_CUST_ACCOUNTS BTCA,
147: HZ_CUST_SITE_USES BTCSU,
148: HZ_CUST_ACCT_SITES BTPS,
149: HR_ORGANIZATION_UNITS HR,
150: RA_CUSTOMER_TRX REL_T,
151: RA_CUST_TRX_TYPES REL_TT
152: WHERE T.request_id = p_request_id
153: AND T.invoice_currency_code = C.currency_code
154: AND T.org_id = AR.org_id
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,
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,
376: HZ_CUST_ACCT_SITES STPS,
411: update zx_transaction_lines ZXL
412: set (poo_party_id, poo_location_id) =
413: (select SR_PER.organization_id, -- poo_party_id
414: SR_HRL.location_id -- poo_location_id
415: from RA_CUSTOMER_TRX TRX,
416: JTF_RS_SALESREPS SR,
417: PER_ALL_ASSIGNMENTS_F SR_PER,
418: HR_ORGANIZATION_UNITS SR_HRL
419: where TRX.customer_trx_id = ZXL.trx_id
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;
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
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,
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'
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,
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,
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'
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 */