[Home] [Help]
PACKAGE BODY: APPS.ZX_ON_FLY_TRX_UPGRADE_AP_PKG
Source
1 PACKAGE BODY ZX_ON_FLY_TRX_UPGRADE_AP_PKG AS
2 /* $Header: zxmigtrxflyapb.pls 120.23.12010000.2 2008/11/12 12:33:52 spasala ship $ */
3
4 g_current_runtime_level NUMBER;
5 g_level_statement CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
6 g_level_procedure CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
7 g_level_event CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
8 g_level_unexpected CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
9
10
11 -------------------------------------------------------------------------------
12 -- PUBLIC PROCEDURE
13 -- upgrade_trx_on_fly_ap
14 --
15 -- DESCRIPTION
16 -- on the fly migration of one transaction for AP
17 --
18 -------------------------------------------------------------------------------
19
20 PROCEDURE upgrade_trx_on_fly_ap(
21 p_upg_trx_info_rec IN ZX_ON_FLY_TRX_UPGRADE_PKG.zx_upg_trx_info_rec_type,
22 x_return_status OUT NOCOPY VARCHAR2
23 ) AS
24
25 l_multi_org_flag fnd_product_groups.multi_org_flag%TYPE;
26 l_org_id NUMBER;
27
28 BEGIN
29 g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
30
31 IF (g_level_procedure >= g_current_runtime_level ) THEN
32 FND_LOG.STRING(g_level_procedure,
33 'ZX.PLSQL.ZX_ON_FLY_TRX_UPGRADE_AP_PKG.upgrade_trx_on_fly_ap.BEGIN',
34 'ZX_ON_FLY_TRX_UPGRADE_AP_PKG.upgrade_trx_on_fly_ap(+)');
35 END IF;
36
37 x_return_status := FND_API.G_RET_STS_SUCCESS;
38 SELECT multi_org_flag INTO l_multi_org_flag FROM fnd_product_groups;
39
40 -- for single org environment, get value of org_id from profile
41 IF l_multi_org_flag = 'N' THEN
42 FND_PROFILE.GET('ORG_ID',l_org_id);
43 IF l_org_id is NULL THEN
44 IF (g_level_unexpected >= g_current_runtime_level ) THEN
45 FND_LOG.STRING(g_level_unexpected,
46 'ZX.PLSQL.ZX_ON_FLY_TRX_UPGRADE_AP_PKG.upgrade_trx_on_fly_blk_ap',
47 'Current envionment is a Single Org environment,'||
48 ' but peofile ORG_ID is not set up');
49 END IF;
50
51 END IF;
52 END IF;
53
54 IF (g_level_statement >= g_current_runtime_level ) THEN
55 FND_LOG.STRING(g_level_statement,
56 'ZX.PLSQL.ZX_ON_FLY_TRX_UPGRADE_AP_PKG.upgrade_trx_on_fly_ap',
57 'Inserting data into zx_lines_det_factors and zx_lines_summary');
58 END IF;
59
60
61 -- Insert data into zx_lines_det_factors and zx_lines_summary
62 --
63 INSERT ALL
64 WHEN AP_LINE_LOOKUP_CODE IN ('ITEM', 'PREPAY','FREIGHT','MISCELLANEOUS') OR
65 TAX_ONLY_LINE_FLAG = 'Y'
66 THEN
67 INTO ZX_LINES_DET_FACTORS (
68 EVENT_ID
69 ,OBJECT_VERSION_NUMBER
70 ,INTERNAL_ORGANIZATION_ID
71 ,APPLICATION_ID
72 ,ENTITY_CODE
73 ,EVENT_CLASS_CODE
74 ,EVENT_TYPE_CODE
75 ,TAX_EVENT_CLASS_CODE
76 ,TAX_EVENT_TYPE_CODE
77 -- ,DOC_EVENT_STATUS
78 ,LINE_LEVEL_ACTION
79 ,LINE_CLASS
80 -- ,APPLICATION_DOC_STATUS
81 ,TRX_ID
82 ,TRX_LINE_ID
83 ,TRX_LEVEL_TYPE
84 ,TRX_DATE
85 ,LEDGER_ID
86 ,TRX_CURRENCY_CODE
87 ,CURRENCY_CONVERSION_DATE
88 ,CURRENCY_CONVERSION_RATE
89 ,CURRENCY_CONVERSION_TYPE
90 ,MINIMUM_ACCOUNTABLE_UNIT
91 ,PRECISION
92 ,LEGAL_ENTITY_ID
93 -- ,ESTABLISHMENT_ID
94 ,DEFAULT_TAXATION_COUNTRY
95 ,TRX_NUMBER
96 ,TRX_LINE_NUMBER
97 ,TRX_LINE_DESCRIPTION
98 ,TRX_DESCRIPTION
99 ,TRX_COMMUNICATED_DATE
100 ,TRX_LINE_GL_DATE
101 ,BATCH_SOURCE_ID
102 -- ,BATCH_SOURCE_NAME
103 ,DOC_SEQ_ID
104 ,DOC_SEQ_NAME
105 ,DOC_SEQ_VALUE
106 ,TRX_DUE_DATE
107 -- ,TRX_TYPE_DESCRIPTION
108 ,TRX_LINE_TYPE
109 ,TRX_LINE_DATE
110 -- ,TRX_SHIPPING_DATE
111 -- ,TRX_RECEIPT_DATE
112 ,LINE_AMT
113 ,TRX_LINE_QUANTITY
114 ,UNIT_PRICE
115 ,PRODUCT_ID
116 -- ,PRODUCT_ORG_ID
117 ,UOM_CODE
118 ,PRODUCT_TYPE
119 -- ,PRODUCT_CODE
120 ,PRODUCT_DESCRIPTION
121 ,FIRST_PTY_ORG_ID
122 -- ,ASSET_NUMBER
123 -- ,ASSET_ACCUM_DEPRECIATION
124 -- ,ASSET_TYPE
125 -- ,ASSET_COST
126 ,ACCOUNT_CCID
127 -- ,ACCOUNT_STRING
128 -- ,RELATED_DOC_APPLICATION_ID
129 -- ,RELATED_DOC_ENTITY_CODE
130 -- ,RELATED_DOC_EVENT_CLASS_CODE
131 -- ,RELATED_DOC_TRX_ID
132 -- ,RELATED_DOC_NUMBER
133 -- ,RELATED_DOC_DATE
134 ,APPLIED_FROM_APPLICATION_ID
135 ,APPLIED_FROM_ENTITY_CODE
136 ,APPLIED_FROM_EVENT_CLASS_CODE
137 ,APPLIED_FROM_TRX_ID
138 ,APPLIED_FROM_LINE_ID
139 ,ADJUSTED_DOC_APPLICATION_ID
140 ,ADJUSTED_DOC_ENTITY_CODE
141 ,ADJUSTED_DOC_EVENT_CLASS_CODE
142 ,ADJUSTED_DOC_TRX_ID
143 ,ADJUSTED_DOC_LINE_ID
144 -- ,ADJUSTED_DOC_NUMBER
145 -- ,ADJUSTED_DOC_DATE
146 ,APPLIED_TO_APPLICATION_ID
147 ,APPLIED_TO_ENTITY_CODE
148 ,APPLIED_TO_EVENT_CLASS_CODE
149 ,APPLIED_TO_TRX_ID
150 ,APPLIED_TO_TRX_LINE_ID
151 -- ,APPLIED_TO_TRX_NUMBER
152 ,REF_DOC_TRX_LEVEL_TYPE
153 ,REF_DOC_APPLICATION_ID
154 ,REF_DOC_ENTITY_CODE
155 ,REF_DOC_EVENT_CLASS_CODE
156 ,REF_DOC_TRX_ID
157 ,REF_DOC_LINE_ID
158 -- ,REF_DOC_LINE_QUANTITY
159 ,APPLIED_TO_TRX_LEVEL_TYPE
160 ,APPLIED_FROM_TRX_LEVEL_TYPE
161 ,ADJUSTED_DOC_TRX_LEVEL_TYPE
162 ,MERCHANT_PARTY_NAME
163 ,MERCHANT_PARTY_DOCUMENT_NUMBER
164 ,MERCHANT_PARTY_REFERENCE
165 ,MERCHANT_PARTY_TAXPAYER_ID
166 ,MERCHANT_PARTY_TAX_REG_NUMBER
167 -- ,MERCHANT_PARTY_ID
168 ,MERCHANT_PARTY_COUNTRY
169 ,START_EXPENSE_DATE
170 ,SHIP_TO_LOCATION_ID
171 -- ,SHIP_FROM_LOCATION_ID
172 -- ,BILL_TO_LOCATION_ID
173 -- ,BILL_FROM_LOCATION_ID
174 -- ,SHIP_TO_PARTY_TAX_PROF_ID
175 -- ,SHIP_FROM_PARTY_TAX_PROF_ID
176 -- ,BILL_TO_PARTY_TAX_PROF_ID
177 -- ,BILL_FROM_PARTY_TAX_PROF_ID
178 -- ,SHIP_TO_SITE_TAX_PROF_ID
179 -- ,SHIP_FROM_SITE_TAX_PROF_ID
180 -- ,BILL_TO_SITE_TAX_PROF_ID
181 -- ,BILL_FROM_SITE_TAX_PROF_ID
182 -- ,MERCHANT_PARTY_TAX_PROF_ID
183 -- ,HQ_ESTB_PARTY_TAX_PROF_ID
184 -- ,CTRL_TOTAL_LINE_TX_AMT
185 -- ,CTRL_TOTAL_HDR_TX_AMT
186 -- ,INPUT_TAX_CLASSIFICATION_CODE
187 -- ,OUTPUT_TAX_CLASSIFICATION_CODE
188 -- ,INTERNAL_ORG_LOCATION_ID
189 ,RECORD_TYPE_CODE
190 ,PRODUCT_FISC_CLASSIFICATION
191 ,PRODUCT_CATEGORY
192 ,USER_DEFINED_FISC_CLASS
193 ,ASSESSABLE_VALUE
194 ,TRX_BUSINESS_CATEGORY
195 ,SUPPLIER_TAX_INVOICE_NUMBER
196 ,SUPPLIER_TAX_INVOICE_DATE
197 ,SUPPLIER_EXCHANGE_RATE
198 ,TAX_INVOICE_DATE
199 ,TAX_INVOICE_NUMBER
200 ,DOCUMENT_SUB_TYPE
201 ,LINE_INTENDED_USE
202 ,PORT_OF_ENTRY_CODE
203 -- ,SOURCE_APPLICATION_ID
204 -- ,SOURCE_ENTITY_CODE
205 -- ,SOURCE_EVENT_CLASS_CODE
206 -- ,SOURCE_TRX_ID
207 -- ,SOURCE_LINE_ID
208 -- ,SOURCE_TRX_LEVEL_TYPE
209 ,HISTORICAL_FLAG
210 ,LINE_AMT_INCLUDES_TAX_FLAG
211 ,CTRL_HDR_TX_APPL_FLAG
212 ,TAX_REPORTING_FLAG
213 ,TAX_AMT_INCLUDED_FLAG
214 ,COMPOUNDING_TAX_FLAG
215 ,INCLUSIVE_TAX_OVERRIDE_FLAG
216 ,THRESHOLD_INDICATOR_FLAG
217 ,USER_UPD_DET_FACTORS_FLAG
218 ,TAX_PROCESSING_COMPLETED_FLAG
219 ,ASSET_FLAG
220 ,CREATION_DATE
221 ,CREATED_BY
222 ,LAST_UPDATE_DATE
223 ,LAST_UPDATED_BY
224 ,LAST_UPDATE_LOGIN
225 ,EVENT_CLASS_MAPPING_ID
226 ,SHIP_THIRD_PTY_ACCT_ID
227 ,SHIP_THIRD_PTY_ACCT_SITE_ID
228 ,GLOBAL_ATTRIBUTE_CATEGORY
229 ,GLOBAL_ATTRIBUTE1
230 -- ,ICX_SESSION_ID
231 -- ,TRX_LINE_CURRENCY_CODE
232 -- ,TRX_LINE_CURRENCY_CONV_RATE
233 -- ,TRX_LINE_CURRENCY_CONV_DATE
234 -- ,TRX_LINE_PRECISION
235 -- ,TRX_LINE_MAU
236 -- ,TRX_LINE_CURRENCY_CONV_TYPE
237 -- ,INTERFACE_ENTITY_CODE
238 -- ,INTERFACE_LINE_ID
239 -- ,SOURCE_TAX_LINE_ID
240 ,BILL_THIRD_PTY_ACCT_ID
241 ,BILL_THIRD_PTY_ACCT_SITE_ID
242 )
243 VALUES(
244 EVENT_ID
245 ,OBJECT_VERSION_NUMBER
246 ,INTERNAL_ORGANIZATION_ID
247 ,APPLICATION_ID
248 ,ENTITY_CODE
249 ,EVENT_CLASS_CODE
250 ,EVENT_TYPE_CODE
251 ,TAX_EVENT_CLASS_CODE
252 ,TAX_EVENT_TYPE_CODE
253 -- ,DOC_EVENT_STATUS
254 ,LINE_LEVEL_ACTION
255 ,LINE_CLASS
256 -- ,APPLICATION_DOC_STATUS
257 ,TRX_ID
258 ,TRX_LINE_ID
259 ,TRX_LEVEL_TYPE
260 ,TRX_DATE
261 ,LEDGER_ID
262 ,TRX_CURRENCY_CODE
263 ,CURRENCY_CONVERSION_DATE
264 ,CURRENCY_CONVERSION_RATE
265 ,CURRENCY_CONVERSION_TYPE
266 ,MINIMUM_ACCOUNTABLE_UNIT
267 ,PRECISION
268 ,LEGAL_ENTITY_ID
269 -- ,ESTABLISHMENT_ID
270 ,DEFAULT_TAXATION_COUNTRY
271 ,TRX_NUMBER
272 ,TRX_LINE_NUMBER
273 ,TRX_LINE_DESCRIPTION
274 ,TRX_DESCRIPTION
275 ,TRX_COMMUNICATED_DATE
276 ,TRX_LINE_GL_DATE
277 ,BATCH_SOURCE_ID
278 -- ,BATCH_SOURCE_NAME
279 ,DOC_SEQ_ID
280 ,DOC_SEQ_NAME
281 ,DOC_SEQ_VALUE
282 ,TRX_DUE_DATE
283 -- ,TRX_TYPE_DESCRIPTION
284 ,TRX_LINE_TYPE
285 ,TRX_LINE_DATE
286 -- ,TRX_SHIPPING_DATE
287 -- ,TRX_RECEIPT_DATE
288 ,LINE_AMT
289 ,TRX_LINE_QUANTITY
290 ,UNIT_PRICE
291 ,PRODUCT_ID
292 -- ,PRODUCT_ORG_ID
293 ,UOM_CODE
294 ,PRODUCT_TYPE
295 -- ,PRODUCT_CODE
296 ,PRODUCT_DESCRIPTION
297 ,FIRST_PTY_ORG_ID
298 -- ,ASSET_NUMBER
299 -- ,ASSET_ACCUM_DEPRECIATION
300 -- ,ASSET_TYPE
301 -- ,ASSET_COST
302 ,ACCOUNT_CCID
303 -- ,ACCOUNT_STRING
304 -- ,RELATED_DOC_APPLICATION_ID
305 -- ,RELATED_DOC_ENTITY_CODE
306 -- ,RELATED_DOC_EVENT_CLASS_CODE
307 -- ,RELATED_DOC_TRX_ID
308 -- ,RELATED_DOC_NUMBER
309 -- ,RELATED_DOC_DATE
310 ,APPLIED_FROM_APPLICATION_ID
311 ,APPLIED_FROM_ENTITY_CODE
312 ,APPLIED_FROM_EVENT_CLASS_CODE
313 ,APPLIED_FROM_TRX_ID
314 ,APPLIED_FROM_LINE_ID
315 ,ADJUSTED_DOC_APPLICATION_ID
316 ,ADJUSTED_DOC_ENTITY_CODE
317 ,ADJUSTED_DOC_EVENT_CLASS_CODE
318 ,ADJUSTED_DOC_TRX_ID
319 ,ADJUSTED_DOC_LINE_ID
320 -- ,ADJUSTED_DOC_NUMBER
321 -- ,ADJUSTED_DOC_DATE
322 ,APPLIED_TO_APPLICATION_ID
323 ,APPLIED_TO_ENTITY_CODE
324 ,APPLIED_TO_EVENT_CLASS_CODE
325 ,APPLIED_TO_TRX_ID
326 ,APPLIED_TO_TRX_LINE_ID
327 -- ,APPLIED_TO_TRX_NUMBER
328 ,REF_DOC_TRX_LEVEL_TYPE
329 ,REF_DOC_APPLICATION_ID
330 ,REF_DOC_ENTITY_CODE
331 ,REF_DOC_EVENT_CLASS_CODE
332 ,REF_DOC_TRX_ID
333 ,REF_DOC_LINE_ID
334 -- ,REF_DOC_LINE_QUANTITY
335 ,APPLIED_TO_TRX_LEVEL_TYPE
336 ,APPLIED_FROM_TRX_LEVEL_TYPE
337 ,ADJUSTED_DOC_TRX_LEVEL_TYPE
338 ,MERCHANT_PARTY_NAME
339 ,MERCHANT_PARTY_DOCUMENT_NUMBER
340 ,MERCHANT_PARTY_REFERENCE
341 ,MERCHANT_PARTY_TAXPAYER_ID
342 ,MERCHANT_PARTY_TAX_REG_NUMBER
343 -- ,MERCHANT_PARTY_ID
344 ,MERCHANT_PARTY_COUNTRY
345 ,START_EXPENSE_DATE
346 ,SHIP_TO_LOCATION_ID
347 -- ,SHIP_FROM_LOCATION_ID
348 -- ,BILL_TO_LOCATION_ID
349 -- ,BILL_FROM_LOCATION_ID
350 -- ,SHIP_TO_PARTY_TAX_PROF_ID
351 -- ,SHIP_FROM_PARTY_TAX_PROF_ID
352 -- ,BILL_TO_PARTY_TAX_PROF_ID
353 -- ,BILL_FROM_PARTY_TAX_PROF_ID
354 -- ,SHIP_TO_SITE_TAX_PROF_ID
355 -- ,SHIP_FROM_SITE_TAX_PROF_ID
356 -- ,BILL_TO_SITE_TAX_PROF_ID
357 -- ,BILL_FROM_SITE_TAX_PROF_ID
358 -- ,MERCHANT_PARTY_TAX_PROF_ID
359 -- ,HQ_ESTB_PARTY_TAX_PROF_ID
360 -- ,CTRL_TOTAL_LINE_TX_AMT
361 -- ,CTRL_TOTAL_HDR_TX_AMT
362 -- ,INPUT_TAX_CLASSIFICATION_CODE
363 -- ,OUTPUT_TAX_CLASSIFICATION_CODE
364 -- ,INTERNAL_ORG_LOCATION_ID
365 ,RECORD_TYPE_CODE
366 ,PRODUCT_FISC_CLASSIFICATION
367 ,PRODUCT_CATEGORY
368 ,USER_DEFINED_FISC_CLASS
369 ,ASSESSABLE_VALUE
370 ,TRX_BUSINESS_CATEGORY
371 ,SUPPLIER_TAX_INVOICE_NUMBER
372 ,SUPPLIER_TAX_INVOICE_DATE
373 ,SUPPLIER_EXCHANGE_RATE
374 ,TAX_INVOICE_DATE
375 ,TAX_INVOICE_NUMBER
376 ,DOCUMENT_SUB_TYPE
377 ,LINE_INTENDED_USE
378 ,PORT_OF_ENTRY_CODE
379 -- ,SOURCE_APPLICATION_ID
380 -- ,SOURCE_ENTITY_CODE
381 -- ,SOURCE_EVENT_CLASS_CODE
382 -- ,SOURCE_TRX_ID
383 -- ,SOURCE_LINE_ID
384 -- ,SOURCE_TRX_LEVEL_TYPE
385 ,HISTORICAL_FLAG
386 ,LINE_AMT_INCLUDES_TAX_FLAG
387 ,CTRL_HDR_TX_APPL_FLAG
388 ,TAX_REPORTING_FLAG
389 ,TAX_AMT_INCLUDED_FLAG
390 ,COMPOUNDING_TAX_FLAG
391 ,INCLUSIVE_TAX_OVERRIDE_FLAG
392 ,THRESHOLD_INDICATOR_FLAG
393 ,USER_UPD_DET_FACTORS_FLAG
394 ,TAX_PROCESSING_COMPLETED_FLAG
395 ,ASSET_FLAG
396 ,CREATION_DATE
397 ,CREATED_BY
398 ,LAST_UPDATE_DATE
399 ,LAST_UPDATED_BY
400 ,LAST_UPDATE_LOGIN
401 ,EVENT_CLASS_MAPPING_ID
402 ,SHIP_THIRD_PTY_ACCT_ID
403 ,SHIP_THIRD_PTY_ACCT_SITE_ID
404 ,GLOBAL_ATTRIBUTE_CATEGORY
405 ,GLOBAL_ATTRIBUTE1
406 -- ,ICX_SESSION_ID
407 -- ,TRX_LINE_CURRENCY_CODE
408 -- ,TRX_LINE_CURRENCY_CONV_RATE
409 -- ,TRX_LINE_CURRENCY_CONV_DATE
410 -- ,TRX_LINE_PRECISION
411 -- ,TRX_LINE_MAU
412 -- ,TRX_LINE_CURRENCY_CONV_TYPE
413 -- ,INTERFACE_ENTITY_CODE
414 -- ,INTERFACE_LINE_ID
415 -- ,SOURCE_TAX_LINE_ID
416 ,BILL_THIRD_PTY_ACCT_ID
417 ,BILL_THIRD_PTY_ACCT_SITE_ID
418 )
419 WHEN AP_LINE_LOOKUP_CODE = 'TAX' THEN
420 INTO ZX_LINES_SUMMARY (
421 SUMMARY_TAX_LINE_ID
422 ,INTERNAL_ORGANIZATION_ID
423 ,APPLICATION_ID
424 ,ENTITY_CODE
425 ,EVENT_CLASS_CODE
426 ,TRX_ID
427 ,TRX_NUMBER
428 ,APPLIED_FROM_APPLICATION_ID
429 ,APPLIED_FROM_EVENT_CLASS_CODE
430 ,APPLIED_FROM_ENTITY_CODE
431 ,APPLIED_FROM_TRX_ID
432 ,ADJUSTED_DOC_APPLICATION_ID
433 ,ADJUSTED_DOC_ENTITY_CODE
434 ,ADJUSTED_DOC_EVENT_CLASS_CODE
435 ,ADJUSTED_DOC_TRX_ID
436 ,SUMMARY_TAX_LINE_NUMBER
437 ,CONTENT_OWNER_ID
438 ,TAX_REGIME_CODE
439 ,TAX
440 ,TAX_STATUS_CODE
441 ,TAX_RATE_ID
442 ,TAX_RATE_CODE
443 ,TAX_RATE
444 ,TAX_AMT
445 ,TAX_AMT_TAX_CURR
446 ,TAX_AMT_FUNCL_CURR
447 ,TAX_JURISDICTION_CODE
448 ,TOTAL_REC_TAX_AMT
449 ,TOTAL_REC_TAX_AMT_FUNCL_CURR
450 ,TOTAL_NREC_TAX_AMT
451 ,TOTAL_NREC_TAX_AMT_FUNCL_CURR
452 ,LEDGER_ID
453 ,LEGAL_ENTITY_ID
454 -- ,ESTABLISHMENT_ID
455 ,CURRENCY_CONVERSION_DATE
456 ,CURRENCY_CONVERSION_TYPE
457 ,CURRENCY_CONVERSION_RATE
458 -- ,SUMMARIZATION_TEMPLATE_ID
459 ,TAXABLE_BASIS_FORMULA
460 ,TAX_CALCULATION_FORMULA
461 ,HISTORICAL_FLAG
462 ,CANCEL_FLAG
463 ,DELETE_FLAG
464 ,TAX_AMT_INCLUDED_FLAG
465 ,COMPOUNDING_TAX_FLAG
466 ,SELF_ASSESSED_FLAG
467 ,OVERRIDDEN_FLAG
468 ,REPORTING_ONLY_FLAG
469 ,ASSOCIATED_CHILD_FROZEN_FLAG
470 ,COPIED_FROM_OTHER_DOC_FLAG
471 ,MANUALLY_ENTERED_FLAG
472 ,LAST_MANUAL_ENTRY --BUG7146063
473 ,RECORD_TYPE_CODE
474 -- ,TAX_PROVIDER_ID
475 ,TAX_ONLY_LINE_FLAG
476 ,CREATED_BY
477 ,CREATION_DATE
478 ,LAST_UPDATED_BY
479 ,LAST_UPDATE_DATE
480 ,LAST_UPDATE_LOGIN
481 ,ATTRIBUTE_CATEGORY
482 ,ATTRIBUTE1
483 ,ATTRIBUTE2
484 ,ATTRIBUTE3
485 ,ATTRIBUTE4
486 ,ATTRIBUTE5
487 ,ATTRIBUTE6
488 ,ATTRIBUTE7
489 ,ATTRIBUTE8
490 ,ATTRIBUTE9
491 ,ATTRIBUTE10
492 ,ATTRIBUTE11
493 ,ATTRIBUTE12
494 ,ATTRIBUTE13
495 ,ATTRIBUTE14
496 ,ATTRIBUTE15
497 ,APPLIED_FROM_LINE_ID
498 ,APPLIED_TO_APPLICATION_ID
499 ,APPLIED_TO_EVENT_CLASS_CODE
500 ,APPLIED_TO_ENTITY_CODE
501 ,APPLIED_TO_TRX_ID
502 ,APPLIED_TO_LINE_ID
503 -- ,TAX_EXEMPTION_ID
504 -- ,TAX_RATE_BEFORE_EXEMPTION
505 -- ,TAX_RATE_NAME_BEFORE_EXEMPTION
506 -- ,EXEMPT_RATE_MODIFIER
507 -- ,EXEMPT_CERTIFICATE_NUMBER
508 -- ,EXEMPT_REASON
509 -- ,EXEMPT_REASON_CODE
510 -- ,TAX_RATE_BEFORE_EXCEPTION
511 -- ,TAX_RATE_NAME_BEFORE_EXCEPTION
512 -- ,TAX_EXCEPTION_ID
513 -- ,EXCEPTION_RATE
514 ,TOTAL_REC_TAX_AMT_TAX_CURR
515 ,TOTAL_NREC_TAX_AMT_TAX_CURR
516 ,MRC_TAX_LINE_FLAG
517 ,GLOBAL_ATTRIBUTE_CATEGORY
518 ,GLOBAL_ATTRIBUTE1
519 ,GLOBAL_ATTRIBUTE2
520 ,GLOBAL_ATTRIBUTE3
521 ,GLOBAL_ATTRIBUTE4
522 ,GLOBAL_ATTRIBUTE5
523 ,GLOBAL_ATTRIBUTE6
524 ,GLOBAL_ATTRIBUTE7
525 ,GLOBAL_ATTRIBUTE8
526 ,GLOBAL_ATTRIBUTE9
527 ,GLOBAL_ATTRIBUTE10
528 ,GLOBAL_ATTRIBUTE11
529 ,GLOBAL_ATTRIBUTE12
530 ,GLOBAL_ATTRIBUTE13
531 ,GLOBAL_ATTRIBUTE14
532 ,GLOBAL_ATTRIBUTE15
533 ,GLOBAL_ATTRIBUTE16
534 ,GLOBAL_ATTRIBUTE17
535 ,GLOBAL_ATTRIBUTE18
536 ,GLOBAL_ATTRIBUTE19
537 ,GLOBAL_ATTRIBUTE20
538 ,APPLIED_FROM_TRX_LEVEL_TYPE
539 ,ADJUSTED_DOC_TRX_LEVEL_TYPE
540 ,APPLIED_TO_TRX_LEVEL_TYPE
541 ,TRX_LEVEL_TYPE
542 ,ADJUST_TAX_AMT_FLAG
543 ,OBJECT_VERSION_NUMBER)
544 VALUES(
545 SUMMARY_TAX_LINE_ID
546 ,INTERNAL_ORGANIZATION_ID
547 ,APPLICATION_ID
548 ,ENTITY_CODE
549 ,EVENT_CLASS_CODE
550 ,TRX_ID
551 ,TRX_NUMBER
552 ,APPLIED_FROM_APPLICATION_ID
553 ,APPLIED_FROM_EVENT_CLASS_CODE
554 ,APPLIED_FROM_ENTITY_CODE
555 ,APPLIED_FROM_TRX_ID
556 ,ADJUSTED_DOC_APPLICATION_ID
557 ,ADJUSTED_DOC_ENTITY_CODE
558 ,ADJUSTED_DOC_EVENT_CLASS_CODE
559 ,ADJUSTED_DOC_TRX_ID
560 ,SUMMARY_TAX_LINE_NUMBER
561 ,CONTENT_OWNER_ID
562 ,TAX_REGIME_CODE
563 ,TAX
564 ,TAX_STATUS_CODE
565 ,TAX_RATE_ID
566 ,TAX_RATE_CODE
567 ,TAX_RATE
568 ,TAX_AMT
569 ,TAX_AMT_TAX_CURR
570 ,TAX_AMT_FUNCL_CURR
571 ,TAX_JURISDICTION_CODE
572 ,TOTAL_REC_TAX_AMT
573 ,TOTAL_REC_TAX_AMT_FUNCL_CURR
574 ,TOTAL_NREC_TAX_AMT
575 ,TOTAL_NREC_TAX_AMT_FUNCL_CURR
576 ,LEDGER_ID
577 ,LEGAL_ENTITY_ID
578 -- ,ESTABLISHMENT_ID
579 ,CURRENCY_CONVERSION_DATE
580 ,CURRENCY_CONVERSION_TYPE
581 ,CURRENCY_CONVERSION_RATE
582 -- ,NULL -- SUMMARIZATION_TEMPLATE_ID
583 ,'STANDARD_TB' -- TAXABLE_BASIS_FORMULA
584 ,'STANDARD_TC' -- TAX_CALCULATION_FORMULA
585 ,HISTORICAL_FLAG
586 ,CANCEL_FLAG
587 ,'N' -- DELETE_FLAG
588 ,TAX_AMT_INCLUDED_FLAG
589 ,COMPOUNDING_TAX_FLAG
590 ,SELF_ASSESSED_FLAG
591 ,OVERRIDDEN_FLAG
592 ,'N' -- REPORTING_ONLY_FLAG
593 ,'N' -- ASSOCIATED_CHILD_FROZEN_FLAG
594 ,'N' -- COPIED_FROM_OTHER_DOC_FLAG
595 ,MANUALLY_ENTERED_FLAG --BUG7146063
596 ,LAST_MANUAL_ENTRY --BUG7146063
597 ,RECORD_TYPE_CODE
598 -- ,NULL -- TAX_PROVIDER_ID
599 ,TAX_ONLY_LINE_FLAG
600 ,CREATED_BY
601 ,CREATION_DATE
602 ,LAST_UPDATED_BY
603 ,LAST_UPDATE_DATE
604 ,LAST_UPDATE_LOGIN
605 ,ATTRIBUTE_CATEGORY
606 ,ATTRIBUTE1
607 ,ATTRIBUTE2
608 ,ATTRIBUTE3
609 ,ATTRIBUTE4
610 ,ATTRIBUTE5
611 ,ATTRIBUTE6
612 ,ATTRIBUTE7
613 ,ATTRIBUTE8
614 ,ATTRIBUTE9
615 ,ATTRIBUTE10
616 ,ATTRIBUTE11
617 ,ATTRIBUTE12
618 ,ATTRIBUTE13
619 ,ATTRIBUTE14
620 ,ATTRIBUTE15
621 ,APPLIED_FROM_LINE_ID
622 ,APPLIED_TO_APPLICATION_ID
623 ,APPLIED_TO_EVENT_CLASS_CODE
624 ,APPLIED_TO_ENTITY_CODE
625 ,APPLIED_TO_TRX_ID
626 ,APPLIED_TO_TRX_LINE_ID -- APPLIED_TO_LINE_ID
627 -- ,NULL -- TAX_EXEMPTION_ID
628 -- ,NULL -- TAX_RATE_BEFORE_EXEMPTION
629 -- ,NULL -- TAX_RATE_NAME_BEFORE_EXEMPTION
630 -- ,NULL -- EXEMPT_RATE_MODIFIER
631 -- ,NULL -- EXEMPT_CERTIFICATE_NUMBER
632 -- ,NULL -- EXEMPT_REASON
633 -- ,NULL -- EXEMPT_REASON_CODE
634 -- ,NULL -- TAX_RATE_BEFORE_EXCEPTION
635 -- ,NULL -- TAX_RATE_NAME_BEFORE_EXCEPTION
636 -- ,NULL -- TAX_EXCEPTION_ID
637 -- ,NULL -- EXCEPTION_RATE
638 ,TOTAL_REC_TAX_AMT_FUNCL_CURR
639 ,TOTAL_NREC_TAX_AMT_FUNCL_CURR
640 ,'N' -- MRC_TAX_LINE_FLAG
641 ,GLOBAL_ATTRIBUTE_CATEGORY
642 ,GLOBAL_ATTRIBUTE1
643 ,GLOBAL_ATTRIBUTE2
644 ,GLOBAL_ATTRIBUTE3
645 ,GLOBAL_ATTRIBUTE4
646 ,GLOBAL_ATTRIBUTE5
647 ,GLOBAL_ATTRIBUTE6
648 ,GLOBAL_ATTRIBUTE7
649 ,GLOBAL_ATTRIBUTE8
650 ,GLOBAL_ATTRIBUTE9
651 ,GLOBAL_ATTRIBUTE10
652 ,GLOBAL_ATTRIBUTE11
653 ,GLOBAL_ATTRIBUTE12
654 ,GLOBAL_ATTRIBUTE13
655 ,GLOBAL_ATTRIBUTE14
656 ,GLOBAL_ATTRIBUTE15
657 ,GLOBAL_ATTRIBUTE16
658 ,GLOBAL_ATTRIBUTE17
659 ,GLOBAL_ATTRIBUTE18
660 ,GLOBAL_ATTRIBUTE19
661 ,GLOBAL_ATTRIBUTE20
662 ,APPLIED_FROM_TRX_LEVEL_TYPE
663 ,ADJUSTED_DOC_TRX_LEVEL_TYPE
664 ,APPLIED_TO_TRX_LEVEL_TYPE
665 ,TRX_LEVEL_TYPE
666 ,NULL -- ADJUST_TAX_AMT_FLAG
667 ,OBJECT_VERSION_NUMBER
668 )
669 (SELECT /*+ ROWID(inv) ORDERED use_nl(fnd_curr,fds,lines,poll,ptp)*/
670 NULL EVENT_ID
671 ,1 OBJECT_VERSION_NUMBER
672 ,NVL(lines.org_id,-99) INTERNAL_ORGANIZATION_ID
673 ,200 APPLICATION_ID
674 ,'AP_INVOICES' ENTITY_CODE
675 ,DECODE(inv.INVOICE_TYPE_LOOKUP_CODE,
676 'STANDARD', 'STANDARD INVOICES',
677 'CREDIT' , 'STANDARD INVOICES', --Bug 6489409
678 'DEBIT' , 'STANDARD INVOICES', --Bug 6489409
679 'MIXED' , 'STANDARD INVOICES', --Bug 6489409
680 'ADJUSTMENT','STANDARD INVOICES', --Bug 6489409
681 'PO PRICE ADJUST','STANDARD INVOICES', --Bug 6489409
682 'INVOICE REQUEST','STANDARD INVOICES', --Bug 6489409
683 'CREDIT MEMO REQUEST','STANDARD INVOICES',--Bug 6489409
684 'RETAINAGE RELEASE' ,'STANDARD INVOICES',--Bug 6489409
685 'PREPAYMENT', 'PREPAYMENT INVOICES',
686 'EXPENSE REPORT', 'EXPENSE REPORTS',
687 'INTEREST INVOICE', 'INTEREST INVOICES','NA') EVENT_CLASS_CODE
688 ,DECODE(inv.INVOICE_TYPE_LOOKUP_CODE, 'STANDARD', 1,
689 'PREPAYMENT', 7, 'EXPENSE REPORT', 2, NULL) EVENT_CLASS_MAPPING_ID
690 ,DECODE(inv.INVOICE_TYPE_LOOKUP_CODE,
691 'STANDARD','STANDARD INVOICE CREATED',
692 'PREPAYMENT','PREPAYMENT INVOICE CREATED',
693 'EXPENSE REPORT','EXPENSE REPORT CREATED',
694 'INTEREST INVOICE','INTEREST INVOICE CREATED','NA') EVENT_TYPE_CODE
695 ,(CASE
696 WHEN inv.invoice_type_lookup_code in
697 ('ADJUSTMENT','CREDIT','DEBIT','INTEREST',
698 'MIXED','QUICKDEFAULT','PO PRICE ADJUST',
699 'QUICKMATCH','STANDARD','AWT')
700 THEN 'PURCHASE_TRANSACTION'
701 WHEN inv.invoice_type_lookup_code = 'PREPAYMENT'
702 THEN 'PURCHASE_PREPAYMENTTRANSACTION'
703 WHEN inv.invoice_type_lookup_code='EXPENSE REPORT'
704 THEN 'EXPENSE_REPORT'
705 ELSE NULL
706 END) TAX_EVENT_CLASS_CODE
707 ,'VALIDATE' TAX_EVENT_TYPE_CODE
708 -- ,NULL DOC_EVENT_STATUS
709 ,'CREATE' LINE_LEVEL_ACTION
710 ,DECODE(lines.po_line_location_id,
711 NULL, DECODE(lines.line_type_lookup_code,
712 'PREPAY', 'PREPAY_APPLICATION',
713 DECODE(inv.invoice_type_lookup_code,
714 'STANDARD', 'STANDARD INVOICES',
715 'CREDIT','AP_CREDIT_MEMO',
716 'CREDIT MEMO REQUEST', 'AP_CREDIT_MEMO',
717 'DEBIT','AP_DEBIT_MEMO',
718 'PREPAYMENT','PREPAYMENT INVOICES',
719 'EXPENSE REPORT','EXPENSE REPORTS',
720 'STANDARD INVOICES'
721 )
722 ),
723 DECODE(poll.shipment_type,
724 'PREPAYMENT', DECODE(poll.payment_type,
725 'ADVANCE', 'ADVANCE',
726 'MILESTONE', 'FINANCING',
727 'RATE', 'FINANCING',
728 'LUMPSUM', 'FINANCING',
729 DECODE(poll.matching_basis,
730 'AMOUNT','AMOUNT_MATCHED',
731 'STANDARD INVOICES')
732 ),
733 DECODE(poll.matching_basis,
734 'AMOUNT','AMOUNT_MATCHED',
735 'STANDARD INVOICES')
736 )
737 ) LINE_CLASS
738 -- ,NULL APPLICATION_DOC_STATUS
739 ,lines.line_type_lookup_code AP_LINE_LOOKUP_CODE
740 ,lines.invoice_id TRX_ID
741 ,NVL(inv.invoice_date,sysdate) TRX_DATE
742 ,lines.set_of_books_id LEDGER_ID
743 ,inv.invoice_currency_code TRX_CURRENCY_CODE
744 ,NVL(inv.legal_entity_id, -99) LEGAL_ENTITY_ID
745 -- ,NULL ESTABLISHMENT_ID
746 ,inv.taxation_country DEFAULT_TAXATION_COUNTRY
747 ,inv.invoice_num TRX_NUMBER
748 ,lines.description TRX_LINE_DESCRIPTION
749 ,inv.description TRX_DESCRIPTION
750 ,inv.invoice_received_date TRX_COMMUNICATED_DATE
751 ,NVL(lines.accounting_date,sysdate) TRX_LINE_GL_DATE
752 ,inv.batch_id BATCH_SOURCE_ID
753 -- ,NULL BATCH_SOURCE_NAME
754 ,inv.doc_sequence_id DOC_SEQ_ID
755 ,fds.name DOC_SEQ_NAME
756 ,inv.doc_sequence_value DOC_SEQ_VALUE
757 ,inv.terms_date TRX_DUE_DATE
758 -- ,NULL TRX_TYPE_DESCRIPTION
759 ,lines.line_type_lookup_code TRX_LINE_TYPE
760 ,lines.accounting_date TRX_LINE_DATE
761 -- ,NULL TRX_SHIPPING_DATE
762 -- ,NULL TRX_RECEIPT_DATE
763 ,NVL(lines.amount,0) LINE_AMT
764 ,lines.quantity_invoiced TRX_LINE_QUANTITY
765 ,lines.unit_price -- UNIT_PRICE
766 ,lines.inventory_item_id PRODUCT_ID
767 -- ,NULL PRODUCT_ORG_ID
768 ,lines.unit_meas_lookup_code UOM_CODE
769 ,lines.product_type -- PRODUCT_TYPE
770 -- ,NULL PRODUCT_CODE
771 ,lines.item_description PRODUCT_DESCRIPTION
772 ,ptp.party_tax_profile_id FIRST_PTY_ORG_ID
773 -- ,NULL ASSET_NUMBER
774 -- ,NULL ASSET_ACCUM_DEPRECIATION
775 -- ,NULL ASSET_TYPE
776 -- ,NULL ASSET_COST
777 -- ,NULL RELATED_DOC_APPLICATION_ID,
778 -- ,NULL RELATED_DOC_ENTITY_CODE
779 -- ,NULL RELATED_DOC_EVENT_CLASS_CODE
780 -- ,NULL RELATED_DOC_TRX_ID
781 -- ,NULL RELATED_DOC_NUMBER
782 -- ,NULL RELATED_DOC_DATE
783 ,DECODE(lines.prepay_invoice_id, NULL, NULL, 200) APPLIED_FROM_APPLICATION_ID
784 ,DECODE(lines.prepay_invoice_id, NULL, NULL,
785 'AP_INVOICES') APPLIED_FROM_ENTITY_CODE
786 ,DECODE(lines.prepay_invoice_id, NULL, NULL,
787 'PREPAYMENT INVOICES') APPLIED_FROM_EVENT_CLASS_CODE
788 ,lines.prepay_invoice_id APPLIED_FROM_TRX_ID
789 ,lines.prepay_line_number APPLIED_FROM_LINE_ID
790 ,DECODE(lines.corrected_inv_id, NULL, NULL, 200) ADJUSTED_DOC_APPLICATION_ID
791 ,DECODE(lines.corrected_inv_id, NULL, NULL,
792 'AP_INVOICES') ADJUSTED_DOC_ENTITY_CODE
793 ,DECODE(lines.corrected_inv_id, NULL, NULL,
794 'STANDARD INVOICES') ADJUSTED_DOC_EVENT_CLASS_CODE
795 ,lines.corrected_inv_id ADJUSTED_DOC_TRX_ID
796 ,lines.corrected_line_number ADJUSTED_DOC_LINE_ID
797 -- ,NULL ADJUSTED_DOC_NUMBER
798 -- ,NULL ADJUSTED_DOC_DATE
799 ,DECODE(lines.rcv_transaction_id, NULL, NULL, 707) APPLIED_TO_APPLICATION_ID
800 ,DECODE(lines.rcv_transaction_id, NULL, NULL,
801 'RCV_ACCOUNTING_EVENTS') APPLIED_TO_ENTITY_CODE
802 ,DECODE(lines.rcv_transaction_id, NULL, NULL,
803 'RCPT_REC_INSP') APPLIED_TO_EVENT_CLASS_CODE
804 ,lines.rcv_transaction_id APPLIED_TO_TRX_ID
805 ,lines.rcv_shipment_line_id APPLIED_TO_TRX_LINE_ID
806 -- ,NULL APPLIED_TO_TRX_NUMBER
807 ,DECODE(NVL(lines.po_release_id, lines.po_header_id),
808 NULL, NULL, 'SHIPMENT') REF_DOC_TRX_LEVEL_TYPE
809 ,NVL(lines.po_release_id, lines.po_header_id) REF_DOC_TRX_ID
810 ,lines.po_line_location_id REF_DOC_LINE_ID
811 -- ,NULL REF_DOC_LINE_QUANTITY
812 ,DECODE(lines.rcv_transaction_id, NULL, NULL,
813 'LINE') APPLIED_TO_TRX_LEVEL_TYPE
814 ,DECODE(lines.prepay_invoice_id, NULL, NULL,
815 'LINE') APPLIED_FROM_TRX_LEVEL_TYPE
816 ,DECODE(lines.corrected_inv_id, NULL, NULL,
817 'LINE') ADJUSTED_DOC_TRX_LEVEL_TYPE
818 ,lines.merchant_name MERCHANT_PARTY_NAME
819 ,lines.merchant_document_number MERCHANT_PARTY_DOCUMENT_NUMBER
820 ,lines.merchant_reference MERCHANT_PARTY_REFERENCE
821 ,lines.merchant_taxpayer_id MERCHANT_PARTY_TAXPAYER_ID
822 ,lines.merchant_tax_reg_number MERCHANT_PARTY_TAX_REG_NUMBER
823 -- ,NULL MERCHANT_PARTY_ID
824 ,lines.country_of_supply MERCHANT_PARTY_COUNTRY
825 ,lines.start_expense_date -- START_EXPENSE_DATE
826 ,lines.ship_to_location_id -- SHIP_TO_LOCATION_ID
827 -- ,NULL SHIP_FROM_LOCATION_ID
828 -- ,NULL BILL_TO_LOCATION_ID
829 -- ,NULL BILL_FROM_LOCATION_ID
830 -- ,NULL SHIP_TO_PARTY_TAX_PROF_ID
831 -- ,NULL SHIP_FROM_PARTY_TAX_PROF_ID
832 -- ,NULL BILL_TO_PARTY_TAX_PROF_ID
833 -- ,NULL BILL_FROM_PARTY_TAX_PROF_ID
834 -- ,NULL SHIP_TO_SITE_TAX_PROF_ID
835 -- ,NULL SHIP_FROM_SITE_TAX_PROF_ID
836 -- ,NULL BILL_TO_SITE_TAX_PROF_ID
837 -- ,NULL BILL_FROM_SITE_TAX_PROF_ID
838 -- ,NULL MERCHANT_PARTY_TAX_PROF_ID
839 -- ,NULL HQ_ESTB_PARTY_TAX_PROF_ID
840 -- ,NULL CTRL_TOTAL_LINE_TX_AMT
841 -- ,NULL CTRL_TOTAL_HDR_TX_AMT
842 -- ,NULL INPUT_TAX_CLASSIFICATION_CODE
843 -- ,NULL OUTPUT_TAX_CLASSIFICATION_CODE
844 -- ,NULL INTERNAL_ORG_LOCATION_ID
845 ,'MIGRATED' RECORD_TYPE_CODE
846 ,lines.product_fisc_classification -- PRODUCT_FISC_CLASSIFICATION
847 ,lines.product_category -- PRODUCT_CATEGORY
848 ,lines.user_defined_fisc_class -- USER_DEFINED_FISC_CLASS
849 ,lines.assessable_value -- ASSESSABLE_VALUE
850 ,lines.trx_business_category -- TRX_BUSINESS_CATEGORY
851 ,inv.supplier_tax_invoice_number -- SUPPLIER_TAX_INVOICE_NUMBER
852 ,inv.supplier_tax_invoice_date -- SUPPLIER_TAX_INVOICE_DATE
853 ,inv.supplier_tax_exchange_rate SUPPLIER_EXCHANGE_RATE
854 ,inv.tax_invoice_recording_date TAX_INVOICE_DATE
855 ,inv.tax_invoice_internal_seq TAX_INVOICE_NUMBER
856 ,inv.document_sub_type -- DOCUMENT_SUB_TYPE
857 ,lines.primary_intended_use LINE_INTENDED_USE
858 ,inv.port_of_entry_code -- PORT_OF_ENTRY_CODE
859 -- ,NULL SOURCE_APPLICATION_ID
860 -- ,NULL SOURCE_ENTITY_CODE
861 -- ,NULL SOURCE_EVENT_CLASS_CODE
862 -- ,NULL SOURCE_TRX_ID,
863 -- ,NULL SOURCE_LINE_ID,
864 -- ,NULL SOURCE_TRX_LEVEL_TYPE
865 ,'N' LINE_AMT_INCLUDES_TAX_FLAG
866 ,'N' CTRL_HDR_TX_APPL_FLAG
867 ,'Y' TAX_REPORTING_FLAG
868 ,'N' TAX_AMT_INCLUDED_FLAG
869 ,'N' COMPOUNDING_TAX_FLAG
870 ,'N' INCLUSIVE_TAX_OVERRIDE_FLAG
871 ,'N' THRESHOLD_INDICATOR_FLAG
872 ,'N' USER_UPD_DET_FACTORS_FLAG
873 ,'N' TAX_PROCESSING_COMPLETED_FLAG
874 ,lines.assets_tracking_flag ASSET_FLAG
875 ,ptp.party_tax_profile_id CONTENT_OWNER_ID
876 ,inv.exchange_date CURRENCY_CONVERSION_DATE
877 ,inv.exchange_rate CURRENCY_CONVERSION_RATE
878 ,inv.exchange_rate_type CURRENCY_CONVERSION_TYPE
879 ,fnd_curr.minimum_accountable_unit MINIMUM_ACCOUNTABLE_UNIT
880 ,NVL(fnd_curr.precision,0) PRECISION
881 ,DECODE(NVL(lines.po_release_id, lines.po_header_id),
882 NULL, NULL, 201) REF_DOC_APPLICATION_ID
883 ,DECODE(lines.po_release_id, NULL,
884 DECODE(lines.po_header_id, NULL, NULL,
885 'PURCHASE_ORDER'), 'RELEASE') REF_DOC_ENTITY_CODE
886 ,DECODE(lines.po_release_id, NULL,
887 DECODE(lines.po_header_id, NULL, NULL,
888 'PO_PA'), 'RELEASE') REF_DOC_EVENT_CLASS_CODE
889 ,lines.SUMMARY_TAX_LINE_ID SUMMARY_TAX_LINE_ID
890 ,lines.TAX TAX
891 ,DECODE(lines.line_type_lookup_code, 'TAX',
892 RANK() OVER (PARTITION BY inv.invoice_id,
893 lines.line_type_lookup_code
894 ORDER BY lines.line_number), NULL) SUMMARY_TAX_LINE_NUMBER
895 ,lines.tax_rate -- TAX_RATE
896 ,lines.tax_rate_code -- TAX_RATE_CODE
897 ,lines.tax_rate_id -- TAX_RATE_ID
898 ,lines.tax_regime_code -- TAX_REGIME_CODE
899 ,lines.tax_status_code -- TAX_STATUS_CODE
900 ,lines.tax_jurisdiction_code -- TAX_JURISDICTION_CODE
901 ,'LINE' TRX_LEVEL_TYPE
902 ,lines.line_number TRX_LINE_ID
903 ,lines.line_number TRX_LINE_NUMBER
904 ,lines.default_dist_ccid ACCOUNT_CCID
905 -- ,NULL ACCOUNT_STRING
906 ,lines.amount TAX_AMT
907 ,lines.base_amount TAX_AMT_TAX_CURR
908 ,lines.base_amount TAX_AMT_FUNCL_CURR
909 ,lines.attribute_category -- ATTRIBUTE_CATEGORY
910 ,lines.attribute1 -- ATTRIBUTE1
911 ,lines.attribute2 -- ATTRIBUTE2
912 ,lines.attribute3 -- ATTRIBUTE3
913 ,lines.attribute4 -- ATTRIBUTE4
914 ,lines.attribute5 -- ATTRIBUTE5
915 ,lines.attribute6 -- ATTRIBUTE6
916 ,lines.attribute7 -- ATTRIBUTE7
917 ,lines.attribute8 -- ATTRIBUTE8
918 ,lines.attribute9 -- ATTRIBUTE9
919 ,lines.attribute10 -- ATTRIBUTE10
920 ,lines.attribute11 -- ATTRIBUTE11
921 ,lines.attribute12 -- ATTRIBUTE12
922 ,lines.attribute13 -- ATTRIBUTE13
923 ,lines.attribute14 -- ATTRIBUTE14
924 ,lines.attribute15 -- ATTRIBUTE15
925 ,lines.global_attribute_category -- GLOBAL_ATTRIBUTE_CATEGORY
926 ,lines.global_attribute1 -- GLOBAL_ATTRIBUTE1
927 ,lines.global_attribute2 -- GLOBAL_ATTRIBUTE2
928 ,lines.global_attribute3 -- GLOBAL_ATTRIBUTE3
929 ,lines.global_attribute4 -- GLOBAL_ATTRIBUTE4
930 ,lines.global_attribute5 -- GLOBAL_ATTRIBUTE5
931 ,lines.global_attribute6 -- GLOBAL_ATTRIBUTE6
932 ,lines.global_attribute7 -- GLOBAL_ATTRIBUTE7
933 ,lines.global_attribute8 -- GLOBAL_ATTRIBUTE8
934 ,lines.global_attribute9 -- GLOBAL_ATTRIBUTE9
935 ,lines.global_attribute10 -- GLOBAL_ATTRIBUTE10
936 ,lines.global_attribute11 -- GLOBAL_ATTRIBUTE11
937 ,lines.global_attribute12 -- GLOBAL_ATTRIBUTE12
938 ,lines.global_attribute13 -- GLOBAL_ATTRIBUTE13
939 ,lines.global_attribute14 -- GLOBAL_ATTRIBUTE14
940 ,lines.global_attribute15 -- GLOBAL_ATTRIBUTE15
941 ,lines.global_attribute16 -- GLOBAL_ATTRIBUTE16
942 ,lines.global_attribute17 -- GLOBAL_ATTRIBUTE17
943 ,lines.global_attribute18 -- GLOBAL_ATTRIBUTE18
944 ,lines.global_attribute19 -- GLOBAL_ATTRIBUTE19
945 ,lines.global_attribute20 -- GLOBAL_ATTRIBUTE20
946 ,'Y' HISTORICAL_FLAG
947 ,'N' OVERRIDDEN_FLAG
948 ,'N' SELF_ASSESSED_FLAG
949 ,1 CREATED_BY
950 ,SYSDATE CREATION_DATE
951 ,SYSDATE LAST_UPDATE_DATE
952 ,1 LAST_UPDATE_LOGIN
953 ,1 LAST_UPDATED_BY
954 -- ,NULL LAST_MANUAL_ENTRY
955 ,CASE
956 WHEN lines.line_type_lookup_code <> 'TAX'
957 THEN NULL
958 WHEN NOT EXISTS -- Tax Lines
959 (SELECT 1
960 FROM AP_INV_DISTS_TARGET dists
961 WHERE dists.invoice_id = lines.invoice_id
962 AND dists.invoice_line_number = lines.line_number
963 AND dists.charge_applicable_to_dist_id IS NOT NULL
964 )
965 THEN 'Y'
966 ELSE 'N'
967 END TAX_ONLY_LINE_FLAG
968 ,lines.total_rec_tax_amount TOTAL_REC_TAX_AMT
969 ,lines.total_nrec_tax_amount TOTAL_NREC_TAX_AMT
970 ,lines.total_rec_tax_amt_funcl_curr -- TOTAL_REC_TAX_AMT_FUNCL_CURR,
971 ,lines.total_nrec_tax_amt_funcl_curr -- TOTAL_NREC_TAX_AMT_FUNCL_CURR,
972 ,inv.vendor_id SHIP_THIRD_PTY_ACCT_ID
973 ,inv.vendor_site_id SHIP_THIRD_PTY_ACCT_SITE_ID
974 ,inv.vendor_id BILL_THIRD_PTY_ACCT_ID
975 ,inv.vendor_site_id BILL_THIRD_PTY_ACCT_SITE_ID
976 -- ,NULL ICX_SESSION_ID
977 -- ,NULL TRX_LINE_CURRENCY_CODE
978 -- ,NULL TRX_LINE_CURRENCY_CONV_RATE
979 -- ,NULL TRX_LINE_CURRENCY_CONV_DATE
980 -- ,NULL TRX_LINE_PRECISION
981 -- ,NULL TRX_LINE_MAU
982 -- ,NULL TRX_LINE_CURRENCY_CONV_TYPE
983 -- ,NULL INTERFACE_ENTITY_CODE
984 -- ,NULL INTERFACE_LINE_ID
985 -- ,NULL SOURCE_TAX_LINE_ID
986 ,DECODE(lines.discarded_flag, 'Y', 'Y', 'N') CANCEL_FLAG
987 ,DECODE(lines.line_source,'MANUAL LINE ENTRY','Y','N') MANUALLY_ENTERED_FLAG --BUG7146063
988 ,DECODE(lines.line_source,'MANUAL LINE ENTRY','TAX_AMOUNT',NULL) LAST_MANUAL_ENTRY --BUG7146063
989 FROM ap_invoices_all inv,
990 fnd_currencies fnd_curr,
991 fnd_document_sequences fds,
992 ap_invoice_lines_all lines,
993 po_line_locations_all poll,
994 zx_party_tax_profile ptp
995 WHERE inv.invoice_id = p_upg_trx_info_rec.trx_id
996 AND fnd_curr.currency_code = inv.invoice_currency_code
997 AND inv.doc_sequence_id = fds.doc_sequence_id(+)
998 AND lines.invoice_id = inv.invoice_id
999 AND NVL(lines.historical_flag, 'N') = 'Y'
1000 AND poll.line_location_id(+) = lines.po_line_location_id
1001 AND ptp.party_type_code = 'OU'
1002 AND ptp.party_id = DECODE(l_multi_org_flag,'N',l_org_id,lines.org_id)
1003 AND NOT EXISTS (SELECT 1 FROM zx_lines_det_factors zxdet --Bug 6738188
1004 WHERE zxdet.application_id = 200
1005 AND zxdet.entity_code = 'AP_INVOICES'
1006 AND zxdet.event_class_code = DECODE(inv.INVOICE_TYPE_LOOKUP_CODE,
1007 'STANDARD', 'STANDARD INVOICES',
1008 'CREDIT' , 'STANDARD INVOICES',
1009 'DEBIT' , 'STANDARD INVOICES',
1010 'MIXED' , 'STANDARD INVOICES',
1011 'ADJUSTMENT','STANDARD INVOICES',
1012 'PO PRICE ADJUST','STANDARD INVOICES',
1013 'INVOICE REQUEST','STANDARD INVOICES',
1014 'CREDIT MEMO REQUEST','STANDARD INVOICES',
1015 'RETAINAGE RELEASE' ,'STANDARD INVOICES',
1016 'PREPAYMENT', 'PREPAYMENT INVOICES',
1017 'EXPENSE REPORT', 'EXPENSE REPORTS',
1018 'INTEREST INVOICE', 'INTEREST INVOICES','NA')
1019 AND zxdet.trx_id=inv.invoice_id
1020 AND zxdet.trx_line_id=lines.line_number)
1021 );
1022
1023 IF (g_level_statement >= g_current_runtime_level ) THEN
1024 FND_LOG.STRING(g_level_statement,
1025 'ZX.PLSQL.ZX_ON_FLY_TRX_UPGRADE_AP_PKG.upgrade_trx_on_fly_ap',
1026 'Inserting data into zx_lines and zx_rec_nrec_dist');
1027 END IF;
1028
1029 -- Insert data into zx_lines and zx_rec_nrec_dist
1030 --
1031 INSERT ALL
1032 INTO ZX_REC_NREC_DIST(
1033 TAX_LINE_ID
1034 ,REC_NREC_TAX_DIST_ID
1035 ,REC_NREC_TAX_DIST_NUMBER
1036 ,APPLICATION_ID
1037 ,CONTENT_OWNER_ID
1038 ,CURRENCY_CONVERSION_DATE
1039 ,CURRENCY_CONVERSION_RATE
1040 ,CURRENCY_CONVERSION_TYPE
1041 ,ENTITY_CODE
1042 ,EVENT_CLASS_CODE
1043 ,EVENT_TYPE_CODE
1044 ,LEDGER_ID
1045 ,MINIMUM_ACCOUNTABLE_UNIT
1046 ,PRECISION
1047 ,RECORD_TYPE_CODE
1048 ,REF_DOC_APPLICATION_ID
1049 ,REF_DOC_ENTITY_CODE
1050 ,REF_DOC_EVENT_CLASS_CODE
1051 ,REF_DOC_LINE_ID
1052 ,REF_DOC_TRX_ID
1053 ,REF_DOC_TRX_LEVEL_TYPE
1054 ,SUMMARY_TAX_LINE_ID
1055 ,TAX
1056 ,TAX_APPORTIONMENT_LINE_NUMBER
1057 ,TAX_CURRENCY_CODE
1058 ,TAX_CURRENCY_CONVERSION_DATE
1059 ,TAX_CURRENCY_CONVERSION_RATE
1060 ,TAX_CURRENCY_CONVERSION_TYPE
1061 ,TAX_EVENT_CLASS_CODE
1062 ,TAX_EVENT_TYPE_CODE
1063 ,TAX_ID
1064 ,TAX_LINE_NUMBER
1065 ,TAX_RATE
1066 ,TAX_RATE_CODE
1067 ,TAX_RATE_ID
1068 ,TAX_REGIME_CODE
1069 ,TAX_REGIME_ID
1070 ,TAX_STATUS_CODE
1071 ,TAX_STATUS_ID
1072 ,TRX_CURRENCY_CODE
1073 ,TRX_ID
1074 ,TRX_LEVEL_TYPE
1075 ,TRX_LINE_ID
1076 ,TRX_LINE_NUMBER
1077 ,TRX_NUMBER
1078 ,UNIT_PRICE
1079 ,ACCOUNT_CCID
1080 -- ,ACCOUNT_STRING
1081 -- ,ADJUSTED_DOC_TAX_DIST_ID
1082 -- ,APPLIED_FROM_TAX_DIST_ID
1083 -- ,APPLIED_TO_DOC_CURR_CONV_RATE
1084 ,AWARD_ID
1085 ,EXPENDITURE_ITEM_DATE
1086 ,EXPENDITURE_ORGANIZATION_ID
1087 ,EXPENDITURE_TYPE
1088 ,FUNC_CURR_ROUNDING_ADJUSTMENT
1089 ,GL_DATE
1090 ,INTENDED_USE
1091 ,ITEM_DIST_NUMBER
1092 -- ,MRC_LINK_TO_TAX_DIST_ID
1093 -- ,ORIG_REC_NREC_RATE
1094 -- ,ORIG_REC_NREC_TAX_AMT
1095 -- ,ORIG_REC_NREC_TAX_AMT_TAX_CURR
1096 -- ,ORIG_REC_RATE_CODE
1097 -- ,PER_TRX_CURR_UNIT_NR_AMT
1098 -- ,PER_UNIT_NREC_TAX_AMT
1099 -- ,PRD_TAX_AMT
1100 -- ,PRICE_DIFF
1101 ,PROJECT_ID
1102 -- ,QTY_DIFF
1103 -- ,RATE_TAX_FACTOR
1104 ,REC_NREC_RATE
1105 ,REC_NREC_TAX_AMT
1106 ,REC_NREC_TAX_AMT_FUNCL_CURR
1107 ,REC_NREC_TAX_AMT_TAX_CURR
1108 ,RECOVERY_RATE_CODE
1109 ,RECOVERY_TYPE_CODE
1110 -- ,RECOVERY_TYPE_ID
1111 -- ,REF_DOC_CURR_CONV_RATE
1112 ,REF_DOC_DIST_ID
1113 -- ,REF_DOC_PER_UNIT_NREC_TAX_AMT
1114 -- ,REF_DOC_TAX_DIST_ID
1115 -- ,REF_DOC_TRX_LINE_DIST_QTY
1116 -- ,REF_DOC_UNIT_PRICE
1117 -- ,REF_PER_TRX_CURR_UNIT_NR_AMT
1118 ,REVERSED_TAX_DIST_ID
1119 -- ,ROUNDING_RULE_CODE
1120 ,TASK_ID
1121 ,TAXABLE_AMT_FUNCL_CURR
1122 ,TAXABLE_AMT_TAX_CURR
1123 ,TRX_LINE_DIST_AMT
1124 ,TRX_LINE_DIST_ID
1125 ,TRX_LINE_DIST_QTY
1126 ,TRX_LINE_DIST_TAX_AMT
1127 -- ,UNROUNDED_REC_NREC_TAX_AMT
1128 -- ,UNROUNDED_TAXABLE_AMT
1129 ,TAXABLE_AMT
1130 ,ATTRIBUTE_CATEGORY
1131 ,ATTRIBUTE1
1132 ,ATTRIBUTE2
1133 ,ATTRIBUTE3
1134 ,ATTRIBUTE4
1135 ,ATTRIBUTE5
1136 ,ATTRIBUTE6
1137 ,ATTRIBUTE7
1138 ,ATTRIBUTE8
1139 ,ATTRIBUTE9
1140 ,ATTRIBUTE10
1141 ,ATTRIBUTE11
1142 ,ATTRIBUTE12
1143 ,ATTRIBUTE13
1144 ,ATTRIBUTE14
1145 ,ATTRIBUTE15
1146 ,GLOBAL_ATTRIBUTE_CATEGORY
1147 ,GLOBAL_ATTRIBUTE1
1148 ,GLOBAL_ATTRIBUTE2
1149 ,GLOBAL_ATTRIBUTE3
1150 ,GLOBAL_ATTRIBUTE4
1151 ,GLOBAL_ATTRIBUTE5
1152 ,GLOBAL_ATTRIBUTE6
1153 ,GLOBAL_ATTRIBUTE7
1154 ,GLOBAL_ATTRIBUTE8
1155 ,GLOBAL_ATTRIBUTE9
1156 ,GLOBAL_ATTRIBUTE10
1157 ,GLOBAL_ATTRIBUTE11
1158 ,GLOBAL_ATTRIBUTE12
1159 ,GLOBAL_ATTRIBUTE13
1160 ,GLOBAL_ATTRIBUTE14
1161 ,GLOBAL_ATTRIBUTE15
1162 ,GLOBAL_ATTRIBUTE16
1163 ,GLOBAL_ATTRIBUTE17
1164 ,GLOBAL_ATTRIBUTE18
1165 ,GLOBAL_ATTRIBUTE19
1166 ,GLOBAL_ATTRIBUTE20
1167 ,HISTORICAL_FLAG
1168 ,OVERRIDDEN_FLAG
1169 ,SELF_ASSESSED_FLAG
1170 ,TAX_APPORTIONMENT_FLAG
1171 ,TAX_ONLY_LINE_FLAG
1172 ,INCLUSIVE_FLAG
1173 ,MRC_TAX_DIST_FLAG
1174 ,REC_TYPE_RULE_FLAG
1175 ,NEW_REC_RATE_CODE_FLAG
1176 ,RECOVERABLE_FLAG
1177 ,REVERSE_FLAG
1178 ,REC_RATE_DET_RULE_FLAG
1179 ,BACKWARD_COMPATIBILITY_FLAG
1180 ,FREEZE_FLAG
1181 ,POSTING_FLAG
1182 ,LEGAL_ENTITY_ID
1183 ,CREATED_BY
1184 ,CREATION_DATE
1185 ,LAST_MANUAL_ENTRY
1186 ,LAST_UPDATE_DATE
1187 ,LAST_UPDATE_LOGIN
1188 ,LAST_UPDATED_BY
1189 ,OBJECT_VERSION_NUMBER
1190 ,ORIG_AP_CHRG_DIST_NUM
1191 ,ORIG_AP_CHRG_DIST_ID
1192 ,ORIG_AP_TAX_DIST_NUM
1193 ,ORIG_AP_TAX_DIST_ID
1194 ,INTERNAL_ORGANIZATION_ID
1195 ,DEF_REC_SETTLEMENT_OPTION_CODE
1196 --,TAX_JURISDICTION_ID
1197 ,ACCOUNT_SOURCE_TAX_RATE_ID
1198 ,RECOVERY_RATE_ID
1199 )
1200 VALUES(
1201 ZX_LINES_S.NEXTVAL
1202 ,REC_NREC_TAX_DIST_ID
1203 ,REC_NREC_TAX_DIST_NUMBER
1204 ,APPLICATION_ID
1205 ,CONTENT_OWNER_ID
1206 ,CURRENCY_CONVERSION_DATE
1207 ,CURRENCY_CONVERSION_RATE
1208 ,CURRENCY_CONVERSION_TYPE
1209 ,ENTITY_CODE
1210 ,EVENT_CLASS_CODE
1211 ,EVENT_TYPE_CODE
1212 ,AP_LEDGER_ID
1213 ,MINIMUM_ACCOUNTABLE_UNIT
1214 ,PRECISION
1215 ,RECORD_TYPE_CODE
1216 ,REF_DOC_APPLICATION_ID
1217 ,REF_DOC_ENTITY_CODE
1218 ,REF_DOC_EVENT_CLASS_CODE
1219 ,REF_DOC_LINE_ID
1220 ,REF_DOC_TRX_ID
1221 ,REF_DOC_TRX_LEVEL_TYPE
1222 ,SUMMARY_TAX_LINE_ID
1223 ,TAX
1224 ,TAX_APPORTIONMENT_LINE_NUMBER
1225 ,TAX_CURRENCY_CODE
1226 ,TAX_CURRENCY_CONVERSION_DATE
1227 ,TAX_CURRENCY_CONVERSION_RATE
1228 ,TAX_CURRENCY_CONVERSION_TYPE
1229 ,TAX_EVENT_CLASS_CODE
1230 ,TAX_EVENT_TYPE_CODE
1231 ,TAX_ID
1232 ,TAX_LINE_NUMBER
1233 ,TAX_RATE
1234 ,TAX_RATE_CODE
1235 ,TAX_RATE_ID
1236 ,TAX_REGIME_CODE
1237 ,TAX_REGIME_ID
1238 ,TAX_STATUS_CODE
1239 ,TAX_STATUS_ID
1240 ,TRX_CURRENCY_CODE
1241 ,TRX_ID
1242 ,TRX_LEVEL_TYPE
1243 ,TRX_LINE_ID
1244 ,TRX_LINE_NUMBER
1245 ,TRX_NUMBER
1246 ,UNIT_PRICE
1247 ,ACCOUNT_CCID
1248 -- ,ACCOUNT_STRING
1249 -- ,ADJUSTED_DOC_TAX_DIST_ID
1250 -- ,APPLIED_FROM_TAX_DIST_ID
1251 -- ,APPLIED_TO_DOC_CURR_CONV_RATE
1252 ,AWARD_ID
1253 ,EXPENDITURE_ITEM_DATE
1254 ,EXPENDITURE_ORGANIZATION_ID
1255 ,EXPENDITURE_TYPE
1256 ,FUNC_CURR_ROUNDING_ADJUSTMENT
1257 ,GL_DATE
1258 ,INTENDED_USE
1259 ,ITEM_DIST_NUMBER
1260 -- ,MRC_LINK_TO_TAX_DIST_ID
1261 -- ,ORIG_REC_NREC_RATE
1262 -- ,ORIG_REC_NREC_TAX_AMT
1263 -- ,ORIG_REC_NREC_TAX_AMT_TAX_CURR
1264 -- ,ORIG_REC_RATE_CODE
1265 -- ,PER_TRX_CURR_UNIT_NR_AMT
1266 -- ,PER_UNIT_NREC_TAX_AMT
1267 -- ,PRD_TAX_AMT
1268 -- ,PRICE_DIFF
1269 ,PROJECT_ID
1270 -- ,QTY_DIFF
1271 -- ,RATE_TAX_FACTOR
1272 ,REC_NREC_RATE
1273 ,REC_NREC_TAX_AMT
1274 ,REC_NREC_TAX_AMT_FUNCL_CURR
1275 ,REC_NREC_TAX_AMT_TAX_CURR
1276 ,RECOVERY_RATE_CODE
1277 ,RECOVERY_TYPE_CODE
1278 -- ,RECOVERY_TYPE_ID
1279 -- ,REF_DOC_CURR_CONV_RATE
1280 ,REF_DOC_DIST_ID
1281 -- ,REF_DOC_PER_UNIT_NREC_TAX_AMT
1282 -- ,REF_DOC_TAX_DIST_ID
1283 -- ,REF_DOC_TRX_LINE_DIST_QTY
1284 -- ,REF_DOC_UNIT_PRICE
1285 -- ,REF_PER_TRX_CURR_UNIT_NR_AMT
1286 ,REVERSED_TAX_DIST_ID
1287 -- ,ROUNDING_RULE_CODE
1288 ,TASK_ID
1289 ,TAXABLE_AMT_FUNCL_CURR
1290 ,TAXABLE_AMT_TAX_CURR
1291 ,TRX_LINE_DIST_AMT
1292 ,TRX_LINE_DIST_ID
1293 ,TRX_LINE_DIST_QTY
1294 ,TRX_LINE_DIST_TAX_AMT
1295 -- ,UNROUNDED_REC_NREC_TAX_AMT
1296 -- ,UNROUNDED_TAXABLE_AMT
1297 ,TAXABLE_AMT
1298 ,ATTRIBUTE_CATEGORY
1299 ,ATTRIBUTE1
1300 ,ATTRIBUTE2
1301 ,ATTRIBUTE3
1302 ,ATTRIBUTE4
1303 ,ATTRIBUTE5
1304 ,ATTRIBUTE6
1305 ,ATTRIBUTE7
1306 ,ATTRIBUTE8
1307 ,ATTRIBUTE9
1308 ,ATTRIBUTE10
1309 ,ATTRIBUTE11
1310 ,ATTRIBUTE12
1311 ,ATTRIBUTE13
1312 ,ATTRIBUTE14
1313 ,ATTRIBUTE15
1314 ,GLOBAL_ATTRIBUTE_CATEGORY
1315 ,GLOBAL_ATTRIBUTE1
1316 ,GLOBAL_ATTRIBUTE2
1317 ,GLOBAL_ATTRIBUTE3
1318 ,GLOBAL_ATTRIBUTE4
1319 ,GLOBAL_ATTRIBUTE5
1320 ,GLOBAL_ATTRIBUTE6
1321 ,GLOBAL_ATTRIBUTE7
1322 ,GLOBAL_ATTRIBUTE8
1323 ,GLOBAL_ATTRIBUTE9
1324 ,GLOBAL_ATTRIBUTE10
1325 ,GLOBAL_ATTRIBUTE11
1326 ,GLOBAL_ATTRIBUTE12
1327 ,GLOBAL_ATTRIBUTE13
1328 ,GLOBAL_ATTRIBUTE14
1329 ,GLOBAL_ATTRIBUTE15
1330 ,GLOBAL_ATTRIBUTE16
1331 ,GLOBAL_ATTRIBUTE17
1332 ,GLOBAL_ATTRIBUTE18
1333 ,GLOBAL_ATTRIBUTE19
1334 ,GLOBAL_ATTRIBUTE20
1335 ,HISTORICAL_FLAG
1336 ,OVERRIDDEN_FLAG
1337 ,SELF_ASSESSED_FLAG
1338 ,TAX_APPORTIONMENT_FLAG
1339 ,TAX_ONLY_LINE_FLAG
1340 ,INCLUSIVE_FLAG
1341 ,MRC_TAX_DIST_FLAG
1342 ,REC_TYPE_RULE_FLAG
1343 ,NEW_REC_RATE_CODE_FLAG
1344 ,RECOVERABLE_FLAG
1345 ,REVERSE_FLAG
1346 ,REC_RATE_DET_RULE_FLAG
1347 ,BACKWARD_COMPATIBILITY_FLAG
1348 ,FREEZE_FLAG
1349 ,POSTING_FLAG
1350 ,LEGAL_ENTITY_ID
1351 ,CREATED_BY
1352 ,CREATION_DATE
1353 ,LAST_MANUAL_ENTRY
1354 ,LAST_UPDATE_DATE
1355 ,LAST_UPDATE_LOGIN
1356 ,LAST_UPDATED_BY
1357 ,OBJECT_VERSION_NUMBER
1358 ,ORIG_AP_CHRG_DIST_NUM
1359 ,ORIG_AP_CHRG_DIST_ID
1360 ,ORIG_AP_TAX_DIST_NUM
1361 ,ORIG_AP_TAX_DIST_ID
1362 ,INTERNAL_ORGANIZATION_ID
1363 ,DEF_REC_SETTLEMENT_OPTION_CODE
1364 --,TAX_JURISDICTION_ID
1365 ,ACCOUNT_SOURCE_TAX_RATE_ID
1366 ,RECOVERY_RATE_ID
1367 )
1368 INTO ZX_LINES(
1369 TAX_LINE_ID
1370 ,TAX_LINE_NUMBER
1371 ,APPLICATION_ID
1372 ,CONTENT_OWNER_ID
1373 ,CURRENCY_CONVERSION_DATE
1374 ,CURRENCY_CONVERSION_RATE
1375 ,CURRENCY_CONVERSION_TYPE
1376 ,ENTITY_CODE
1377 ,EVENT_CLASS_CODE
1378 ,EVENT_TYPE_CODE
1379 ,LEDGER_ID
1380 ,MINIMUM_ACCOUNTABLE_UNIT
1381 ,PRECISION
1382 ,RECORD_TYPE_CODE
1383 ,REF_DOC_APPLICATION_ID
1384 ,REF_DOC_ENTITY_CODE
1385 ,REF_DOC_EVENT_CLASS_CODE
1386 ,REF_DOC_LINE_ID
1387 ,REF_DOC_TRX_ID
1388 ,REF_DOC_TRX_LEVEL_TYPE
1389 ,SUMMARY_TAX_LINE_ID
1390 ,TAX
1391 ,TAX_APPORTIONMENT_LINE_NUMBER
1392 ,TAX_CURRENCY_CODE
1393 ,TAX_CURRENCY_CONVERSION_DATE
1394 ,TAX_CURRENCY_CONVERSION_RATE
1395 ,TAX_CURRENCY_CONVERSION_TYPE
1396 ,TAX_EVENT_CLASS_CODE
1397 ,TAX_EVENT_TYPE_CODE
1398 ,TAX_ID
1399 ,TAX_RATE
1400 ,TAX_RATE_CODE
1401 ,TAX_RATE_ID
1402 ,TAX_REGIME_CODE
1403 ,TAX_REGIME_ID
1404 ,TAX_STATUS_CODE
1405 ,TAX_STATUS_ID
1406 ,TRX_CURRENCY_CODE
1407 ,TRX_ID
1408 ,TRX_LEVEL_TYPE
1409 ,TRX_LINE_ID
1410 ,TRX_LINE_NUMBER
1411 ,TRX_NUMBER
1412 ,UNIT_PRICE
1413 ,TAX_RATE_TYPE
1414 ,ADJUSTED_DOC_APPLICATION_ID
1415 -- ,ADJUSTED_DOC_DATE
1416 ,ADJUSTED_DOC_ENTITY_CODE
1417 ,ADJUSTED_DOC_EVENT_CLASS_CODE
1418 ,ADJUSTED_DOC_LINE_ID
1419 -- ,ADJUSTED_DOC_NUMBER
1420 ,ADJUSTED_DOC_TRX_ID
1421 ,ADJUSTED_DOC_TRX_LEVEL_TYPE
1422 ,APPLIED_FROM_APPLICATION_ID
1423 ,APPLIED_FROM_ENTITY_CODE
1424 ,APPLIED_FROM_EVENT_CLASS_CODE
1425 ,APPLIED_FROM_LINE_ID
1426 -- ,APPLIED_FROM_TRX_NUMBER
1427 ,APPLIED_FROM_TRX_ID
1428 ,APPLIED_FROM_TRX_LEVEL_TYPE
1429 ,APPLIED_TO_APPLICATION_ID
1430 ,APPLIED_TO_ENTITY_CODE
1431 ,APPLIED_TO_EVENT_CLASS_CODE
1432 ,APPLIED_TO_LINE_ID
1433 ,APPLIED_TO_TRX_ID
1434 ,APPLIED_TO_TRX_LEVEL_TYPE
1435 -- ,APPLIED_TO_TRX_NUMBER
1436 -- ,CAL_TAX_AMT
1437 -- ,CAL_TAX_AMT_FUNCL_CURR
1438 -- ,CAL_TAX_AMT_TAX_CURR
1439 -- ,DOC_EVENT_STATUS
1440 -- ,INTERNAL_ORG_LOCATION_ID
1441 ,INTERNAL_ORGANIZATION_ID
1442 ,LINE_AMT
1443 ,LINE_ASSESSABLE_VALUE
1444 -- ,MRC_LINK_TO_TAX_LINE_ID
1445 ,NREC_TAX_AMT
1446 ,NREC_TAX_AMT_FUNCL_CURR
1447 ,NREC_TAX_AMT_TAX_CURR
1448 -- ,OFFSET_LINK_TO_TAX_LINE_ID
1449 -- ,OFFSET_TAX_RATE_CODE
1450 -- ,ORIG_TAX_AMT
1451 -- ,ORIG_TAX_AMT_TAX_CURR
1452 -- ,ORIG_TAX_RATE
1453 -- ,ORIG_TAX_RATE_CODE
1454 -- ,ORIG_TAX_RATE_ID
1455 -- ,ORIG_TAX_STATUS_CODE
1456 -- ,ORIG_TAX_STATUS_ID
1457 -- ,ORIG_TAXABLE_AMT
1458 -- ,ORIG_TAXABLE_AMT_TAX_CURR
1459 -- ,OTHER_DOC_LINE_AMT
1460 -- ,OTHER_DOC_LINE_TAX_AMT
1461 -- ,OTHER_DOC_LINE_TAXABLE_AMT
1462 -- ,OTHER_DOC_SOURCE
1463 -- ,PRORATION_CODE
1464 ,REC_TAX_AMT
1465 ,REC_TAX_AMT_FUNCL_CURR
1466 ,REC_TAX_AMT_TAX_CURR
1467 -- ,REF_DOC_LINE_QUANTITY
1468 -- ,RELATED_DOC_APPLICATION_ID
1469 -- ,RELATED_DOC_DATE
1470 -- ,RELATED_DOC_ENTITY_CODE
1471 -- ,RELATED_DOC_EVENT_CLASS_CODE
1472 -- ,RELATED_DOC_NUMBER
1473 -- ,RELATED_DOC_TRX_ID
1474 -- ,RELATED_DOC_TRX_LEVEL_TYPE
1475 -- ,REPORTING_CURRENCY_CODE
1476 ,TAX_AMT
1477 ,TAX_AMT_FUNCL_CURR
1478 ,TAX_AMT_TAX_CURR
1479 ,TAX_CALCULATION_FORMULA
1480 -- ,TAX_CODE
1481 ,TAX_DATE
1482 ,TAX_DETERMINE_DATE
1483 ,TAX_POINT_DATE
1484 -- ,TAX_TYPE_CODE
1485 -- ,ROUNDING_RULE_CODE
1486 ,TAXABLE_AMT
1487 ,TAXABLE_AMT_FUNCL_CURR
1488 ,TAXABLE_AMT_TAX_CURR
1489 ,TAXABLE_BASIS_FORMULA
1490 ,TRX_DATE
1491 ,TRX_LINE_DATE
1492 ,TRX_LINE_QUANTITY
1493 -- ,UNROUNDED_TAX_AMT
1494 -- ,UNROUNDED_TAXABLE_AMT
1495 ,HISTORICAL_FLAG
1496 ,OVERRIDDEN_FLAG
1497 ,SELF_ASSESSED_FLAG
1498 ,TAX_APPORTIONMENT_FLAG
1499 ,TAX_ONLY_LINE_FLAG
1500 ,TAX_AMT_INCLUDED_FLAG
1501 ,MRC_TAX_LINE_FLAG
1502 ,OFFSET_FLAG
1503 ,PROCESS_FOR_RECOVERY_FLAG
1504 ,COMPOUNDING_TAX_FLAG
1505 ,ORIG_TAX_AMT_INCLUDED_FLAG
1506 ,ORIG_SELF_ASSESSED_FLAG
1507 ,CANCEL_FLAG
1508 ,PURGE_FLAG
1509 ,DELETE_FLAG
1510 ,MANUALLY_ENTERED_FLAG
1511 --,LAST_MANUAL_ENTRY --BUG7146063
1512 ,REPORTING_ONLY_FLAG
1513 ,FREEZE_UNTIL_OVERRIDDEN_FLAG
1514 ,COPIED_FROM_OTHER_DOC_FLAG
1515 ,RECALC_REQUIRED_FLAG
1516 ,SETTLEMENT_FLAG
1517 ,ITEM_DIST_CHANGED_FLAG
1518 ,ASSOCIATED_CHILD_FROZEN_FLAG
1519 ,COMPOUNDING_DEP_TAX_FLAG
1520 ,ENFORCE_FROM_NATURAL_ACCT_FLAG
1521 ,ATTRIBUTE_CATEGORY
1522 ,ATTRIBUTE1
1523 ,ATTRIBUTE2
1524 ,ATTRIBUTE3
1525 ,ATTRIBUTE4
1526 ,ATTRIBUTE5
1527 ,ATTRIBUTE6
1528 ,ATTRIBUTE7
1529 ,ATTRIBUTE8
1530 ,ATTRIBUTE9
1531 ,ATTRIBUTE10
1532 ,ATTRIBUTE11
1533 ,ATTRIBUTE12
1534 ,ATTRIBUTE13
1535 ,ATTRIBUTE14
1536 ,ATTRIBUTE15
1537 ,GLOBAL_ATTRIBUTE_CATEGORY
1538 ,GLOBAL_ATTRIBUTE1
1539 ,GLOBAL_ATTRIBUTE2
1540 ,GLOBAL_ATTRIBUTE3
1541 ,GLOBAL_ATTRIBUTE4
1542 ,GLOBAL_ATTRIBUTE5
1543 ,GLOBAL_ATTRIBUTE6
1544 ,GLOBAL_ATTRIBUTE7
1545 ,GLOBAL_ATTRIBUTE8
1546 ,GLOBAL_ATTRIBUTE9
1547 ,GLOBAL_ATTRIBUTE10
1548 ,GLOBAL_ATTRIBUTE11
1549 ,GLOBAL_ATTRIBUTE12
1550 ,GLOBAL_ATTRIBUTE13
1551 ,GLOBAL_ATTRIBUTE14
1552 ,GLOBAL_ATTRIBUTE15
1553 ,LAST_MANUAL_ENTRY
1554 ,LEGAL_ENTITY_ID
1555 -- ,ESTABLISHMENT_ID
1556 ,CREATED_BY
1557 ,CREATION_DATE
1558 ,LAST_UPDATE_DATE
1559 ,LAST_UPDATE_LOGIN
1560 ,LAST_UPDATED_BY
1561 ,OBJECT_VERSION_NUMBER
1562 ,MULTIPLE_JURISDICTIONS_FLAG
1563 ,LEGAL_REPORTING_STATUS
1564 ,ACCOUNT_SOURCE_TAX_RATE_ID
1565 )
1566 VALUES (
1567 ZX_LINES_S.NEXTVAL
1568 ,TAX_LINE_NUMBER
1569 ,APPLICATION_ID
1570 ,CONTENT_OWNER_ID
1571 ,CURRENCY_CONVERSION_DATE
1572 ,CURRENCY_CONVERSION_RATE
1573 ,CURRENCY_CONVERSION_TYPE
1574 ,ENTITY_CODE
1575 ,EVENT_CLASS_CODE
1576 ,EVENT_TYPE_CODE
1577 ,AP_LEDGER_ID
1578 ,MINIMUM_ACCOUNTABLE_UNIT
1579 ,PRECISION
1580 ,RECORD_TYPE_CODE
1581 ,REF_DOC_APPLICATION_ID
1582 ,REF_DOC_ENTITY_CODE
1583 ,REF_DOC_EVENT_CLASS_CODE
1584 ,REF_DOC_LINE_ID
1585 ,REF_DOC_TRX_ID
1586 ,REF_DOC_TRX_LEVEL_TYPE
1587 ,SUMMARY_TAX_LINE_ID
1588 ,TAX
1589 ,TAX_APPORTIONMENT_LINE_NUMBER
1590 ,TAX_CURRENCY_CODE
1591 ,TAX_CURRENCY_CONVERSION_DATE
1592 ,TAX_CURRENCY_CONVERSION_RATE
1593 ,TAX_CURRENCY_CONVERSION_TYPE
1594 ,TAX_EVENT_CLASS_CODE
1595 ,TAX_EVENT_TYPE_CODE
1596 ,TAX_ID
1597 ,TAX_RATE
1598 ,TAX_RATE_CODE
1599 ,TAX_RATE_ID
1600 ,TAX_REGIME_CODE
1601 ,TAX_REGIME_ID
1602 ,TAX_STATUS_CODE
1603 ,TAX_STATUS_ID
1604 ,TRX_CURRENCY_CODE
1605 ,TRX_ID
1606 ,TRX_LEVEL_TYPE
1607 ,TRX_LINE_ID
1608 ,TRX_LINE_NUMBER
1609 ,TRX_NUMBER
1610 ,UNIT_PRICE
1611 ,NULL
1612 ,ADJUSTED_DOC_APPLICATION_ID
1613 -- ,ADJUSTED_DOC_DATE
1614 ,ADJUSTED_DOC_ENTITY_CODE
1615 ,ADJUSTED_DOC_EVENT_CLASS_CODE
1616 ,ADJUSTED_DOC_LINE_ID
1617 -- ,ADJUSTED_DOC_NUMBER
1618 ,ADJUSTED_DOC_TRX_ID
1619 ,ADJUSTED_DOC_TRX_LEVEL_TYPE
1620 ,APPLIED_FROM_APPLICATION_ID
1621 ,APPLIED_FROM_ENTITY_CODE
1622 ,APPLIED_FROM_EVENT_CLASS_CODE
1623 ,APPLIED_FROM_LINE_ID
1624 -- ,APPLIED_FROM_TRX_NUMBER
1625 ,APPLIED_FROM_TRX_ID
1626 ,APPLIED_FROM_TRX_LEVEL_TYPE
1627 ,APPLIED_TO_APPLICATION_ID
1628 ,APPLIED_TO_ENTITY_CODE
1629 ,APPLIED_TO_EVENT_CLASS_CODE
1630 ,APPLIED_TO_LINE_ID
1631 ,APPLIED_TO_TRX_ID
1632 ,APPLIED_TO_TRX_LEVEL_TYPE
1633 -- ,APPLIED_TO_TRX_NUMBER
1634 -- ,NULL -- CAL_TAX_AMT
1635 -- ,NULL -- CAL_TAX_AMT_FUNCL_CURR
1636 -- ,NULL -- CAL_TAX_AMT_TAX_CURR
1637 -- ,DOC_EVENT_STATUS
1638 -- ,INTERNAL_ORG_LOCATION_ID
1639 ,INTERNAL_ORGANIZATION_ID
1640 ,LINE_AMT
1641 ,ASSESSABLE_VALUE
1642 -- ,NULL -- MRC_LINK_TO_TAX_LINE_ID
1643 ,DECODE(AP_DIST_LOOKUP_CODE,
1644 'NONREC_TAX', REC_NREC_TAX_AMT, NULL) -- NREC_TAX_AMT
1645 ,DECODE(AP_DIST_LOOKUP_CODE,
1646 'NONREC_TAX', REC_NREC_TAX_AMT_FUNCL_CURR, NULL) -- NREC_TAX_AMT_FUNCL_CURR
1647 ,DECODE(AP_DIST_LOOKUP_CODE,
1648 'NONREC_TAX', REC_NREC_TAX_AMT_TAX_CURR, NULL) -- NREC_TAX_AMT_TAX_CURR
1649 -- ,NULL -- OFFSET_LINK_TO_TAX_LINE_ID
1650 -- ,NULL -- OFFSET_TAX_RATE_CODE
1651 -- ,NULL -- ORIG_TAX_AMT
1652 -- ,NULL -- ORIG_TAX_AMT_TAX_CURR
1653 -- ,NULL -- ORIG_TAX_RATE
1654 -- ,NULL -- ORIG_TAX_RATE_CODE
1655 -- ,NULL -- ORIG_TAX_RATE_ID
1656 -- ,NULL -- ORIG_TAX_STATUS_CODE
1657 -- ,NULL -- ORIG_TAX_STATUS_ID
1658 -- ,NULL -- ORIG_TAXABLE_AMT
1659 -- ,NULL -- ORIG_TAXABLE_AMT_TAX_CURR
1660 -- ,NULL -- OTHER_DOC_LINE_AMT
1661 -- ,NULL -- OTHER_DOC_LINE_TAX_AMT
1662 -- ,NULL -- OTHER_DOC_LINE_TAXABLE_AMT
1663 -- ,NULL -- OTHER_DOC_SOURCE
1664 -- ,NULL -- PRORATION_CODE
1665 ,DECODE(AP_DIST_LOOKUP_CODE,
1666 'REC_TAX', REC_NREC_TAX_AMT, NULL) -- REC_TAX_AMT
1667 ,DECODE(AP_DIST_LOOKUP_CODE,
1668 'REC_TAX', REC_NREC_TAX_AMT_FUNCL_CURR, NULL) -- REC_TAX_AMT_FUNCL_CURR
1669 ,DECODE(AP_DIST_LOOKUP_CODE,
1670 'REC_TAX', REC_NREC_TAX_AMT_TAX_CURR, NULL) -- REC_TAX_AMT_TAX_CURR
1671 -- ,REF_DOC_LINE_QUANTITY
1672 -- ,RELATED_DOC_APPLICATION_ID
1673 -- ,RELATED_DOC_DATE
1674 -- ,RELATED_DOC_ENTITY_CODE
1675 -- ,RELATED_DOC_EVENT_CLASS_CODE
1676 -- ,RELATED_DOC_NUMBER
1677 -- ,RELATED_DOC_TRX_ID
1678 -- ,RELATED_DOC_TRX_LEVEL_TYPE
1679 -- ,NULL -- REPORTING_CURRENCY_CODE
1680 ,TAX_AMT
1681 ,TAX_AMT_FUNCL_CURR
1682 ,TAX_AMT_TAX_CURR
1683 ,'STANDARD_TC'
1684 -- ,NULL -- TAX_CODE
1685 ,TAX_DATE
1686 ,TAX_DETERMINE_DATE
1687 ,TAX_POINT_DATE
1688 -- ,NULL -- TAX_TYPE_CODE
1689 -- ,ROUNDING_RULE_CODE
1690 ,TAXABLE_AMT
1691 ,TAXABLE_AMT_FUNCL_CURR
1692 ,TAXABLE_AMT_TAX_CURR
1693 ,'STANDARD_TB' -- TAXABLE_BASIS_FORMULA
1694 ,TRX_DATE
1695 ,TRX_LINE_DATE
1696 ,TRX_LINE_QUANTITY
1697 -- ,NULL -- UNROUNDED_TAX_AMT
1698 -- ,NULL -- UNROUNDED_TAXABLE_AMT
1699 ,HISTORICAL_FLAG
1700 ,OVERRIDDEN_FLAG
1701 ,SELF_ASSESSED_FLAG
1702 ,TAX_APPORTIONMENT_FLAG
1703 ,TAX_ONLY_LINE_FLAG
1704 ,TAX_AMT_INCLUDED_FLAG
1705 ,'N' -- MRC_TAX_LINE_FLAG
1706 ,'N' -- OFFSET_FLAG
1707 ,'N' -- PROCESS_FOR_RECOVERY_FLAG
1708 ,COMPOUNDING_TAX_FLAG
1709 ,'N' -- ORIG_TAX_AMT_INCLUDED_FLAG
1710 ,'N' -- ORIG_SELF_ASSESSED_FLAG
1711 ,CANCEL_FLAG
1712 ,'N' -- PURGE_FLAG
1713 ,'N' -- DELETE_FLAG
1714 ,MANUALLY_ENTERED_FLAG --BUG7146063
1715 --,LAST_MANUAL_ENTRY --BUG7146063
1716 ,'N' -- REPORTING_ONLY_FLAG
1717 ,'N' -- FREEZE_UNTIL_OVERRIDDEN_FLAG
1718 ,'N' -- COPIED_FROM_OTHER_DOC_FLAG
1719 ,'N' -- RECALC_REQUIRED_FLAG
1720 ,'N' -- SETTLEMENT_FLAG
1721 ,'N' -- ITEM_DIST_CHANGED_FLAG
1722 ,'N' -- ASSOCIATED_CHILD_FROZEN_FLAG
1723 ,'N' -- COMPOUNDING_DEP_TAX_FLAG
1724 ,'N' -- ENFORCE_FROM_NATURAL_ACCT_FLAG
1725 ,ATTRIBUTE_CATEGORY
1726 ,ATTRIBUTE1
1727 ,ATTRIBUTE2
1728 ,ATTRIBUTE3
1729 ,ATTRIBUTE4
1730 ,ATTRIBUTE5
1731 ,ATTRIBUTE6
1732 ,ATTRIBUTE7
1733 ,ATTRIBUTE8
1734 ,ATTRIBUTE9
1735 ,ATTRIBUTE10
1736 ,ATTRIBUTE11
1737 ,ATTRIBUTE12
1738 ,ATTRIBUTE13
1739 ,ATTRIBUTE14
1740 ,ATTRIBUTE15
1741 ,GLOBAL_ATTRIBUTE_CATEGORY
1742 ,GLOBAL_ATTRIBUTE1
1743 ,GLOBAL_ATTRIBUTE2
1744 ,GLOBAL_ATTRIBUTE3
1745 ,GLOBAL_ATTRIBUTE4
1746 ,GLOBAL_ATTRIBUTE5
1747 ,GLOBAL_ATTRIBUTE6
1748 ,GLOBAL_ATTRIBUTE7
1749 ,GLOBAL_ATTRIBUTE8
1750 ,GLOBAL_ATTRIBUTE9
1751 ,GLOBAL_ATTRIBUTE10
1752 ,GLOBAL_ATTRIBUTE11
1753 ,GLOBAL_ATTRIBUTE12
1754 ,GLOBAL_ATTRIBUTE13
1755 ,GLOBAL_ATTRIBUTE14
1756 ,GLOBAL_ATTRIBUTE15
1757 ,LAST_MANUAL_ENTRY
1758 ,LEGAL_ENTITY_ID
1759 -- ,ESTABLISHMENT_ID
1760 ,CREATED_BY
1761 ,CREATION_DATE
1762 ,LAST_UPDATE_DATE
1763 ,LAST_UPDATE_LOGIN
1764 ,LAST_UPDATED_BY
1765 ,OBJECT_VERSION_NUMBER
1766 ,MULTIPLE_JURISDICTIONS_FLAG
1767 ,LEGAL_REPORTING_STATUS
1768 ,ACCOUNT_SOURCE_TAX_RATE_ID
1769 )
1770 (SELECT /*+ ROWID(inv) NO_EXPAND ORDERED
1771 use_nl(fnd_curr,ap_dists,ap_dists1,lines1,rates,regimes,taxes,status,ptp)
1772 index(taxes,ZX_TAXES_B_U2) */
1773 NVL(lines1.org_id,-99) INTERNAL_ORGANIZATION_ID
1774 ,200 APPLICATION_ID
1775 ,'AP_INVOICES' ENTITY_CODE
1776 ,DECODE(inv.INVOICE_TYPE_LOOKUP_CODE ,
1777 'STANDARD', 'STANDARD INVOICES' ,
1778 'CREDIT' , 'STANDARD INVOICES', --Bug 6489409
1779 'DEBIT' , 'STANDARD INVOICES', --Bug 6489409
1780 'MIXED' , 'STANDARD INVOICES', --Bug 6489409
1781 'ADJUSTMENT','STANDARD INVOICES', --Bug 6489409
1782 'PO PRICE ADJUST','STANDARD INVOICES', --Bug 6489409
1783 'INVOICE REQUEST','STANDARD INVOICES', --Bug 6489409
1784 'CREDIT MEMO REQUEST','STANDARD INVOICES',--Bug 6489409
1785 'RETAINAGE RELEASE' ,'STANDARD INVOICES',--Bug 6489409
1786 'PREPAYMENT','PREPAYMENT INVOICES' ,
1787 'EXPENSE REPORT','EXPENSE REPORTS' ,
1788 'INTEREST INVOICE','INTEREST INVOICES','NA') EVENT_CLASS_CODE
1789 ,DECODE(inv.INVOICE_TYPE_LOOKUP_CODE,
1790 'STANDARD','STANDARD INVOICE CREATED',
1791 'PREPAYMENT','PREPAYMENT INVOICE CREATED',
1792 'EXPENSE REPORT','EXPENSE REPORT CREATED',
1793 'INTEREST INVOICE','INTEREST INVOICE CREATED','NA') EVENT_TYPE_CODE
1794 ,(CASE WHEN inv.invoice_type_lookup_code in
1795 ('ADJUSTMENT','CREDIT','DEBIT','INTEREST',
1796 'MIXED','QUICKDEFAULT','PO PRICE ADJUST',
1797 'QUICKMATCH','STANDARD','AWT')
1798 THEN 'PURCHASE_TRANSACTION'
1799 WHEN (inv.invoice_type_lookup_code =
1800 'PREPAYMENT')
1801 THEN 'PURCHASE_PREPAYMENTTRANSACTION'
1802 WHEN (inv.invoice_type_lookup_code =
1803 'EXPENSE REPORT')
1804 THEN 'EXPENSE_REPORT'
1805 ELSE NULL
1806 END) TAX_EVENT_CLASS_CODE
1807 ,'VALIDATE' TAX_EVENT_TYPE_CODE
1808 -- ,NULL DOC_EVENT_STATUS
1809 ,lines1.invoice_id TRX_ID
1810 ,NVL(inv.invoice_date,sysdate) TRX_DATE
1811 ,inv.invoice_currency_code TRX_CURRENCY_CODE
1812 ,NVL(inv.legal_entity_id, -99) LEGAL_ENTITY_ID
1813 -- ,NULL ESTABLISHMENT_ID
1814 ,inv.invoice_num TRX_NUMBER
1815 -- ,DECODE(ap_dists.charge_applicable_to_dist_id,NULL,1,
1816 ,(RANK() OVER (PARTITION BY inv.invoice_id ORDER BY
1817 ap_dists1.invoice_line_number,
1818 ap_dists.invoice_distribution_id)) TAX_LINE_NUMBER
1819 ,lines1.accounting_date TRX_LINE_DATE
1820 ,NVL(lines1.amount,0) LINE_AMT
1821 ,NVL(lines1.quantity_invoiced, 0) TRX_LINE_QUANTITY
1822 ,lines1.UNIT_PRICE UNIT_PRICE
1823 -- ,NULL RELATED_DOC_APPLICATION_ID
1824 -- ,NULL RELATED_DOC_ENTITY_CODE
1825 -- ,NULL RELATED_DOC_EVENT_CLASS_CODE
1826 -- ,NULL RELATED_DOC_TRX_ID
1827 -- ,NULL RELATED_DOC_TRX_LEVEL_TYPE
1828 -- ,NULL RELATED_DOC_NUMBER
1829 -- ,NULL RELATED_DOC_DATE
1830 ,DECODE(lines1.prepay_invoice_id, NULL, NULL, 200) APPLIED_FROM_APPLICATION_ID
1831 ,DECODE(lines1.prepay_invoice_id, NULL, NULL,
1832 'AP_INVOICES') APPLIED_FROM_ENTITY_CODE
1833 ,DECODE(lines1.prepay_invoice_id, NULL, NULL,
1834 'PREPAYMENT INVOICES') APPLIED_FROM_EVENT_CLASS_CODE
1835 ,lines1.prepay_invoice_id APPLIED_FROM_TRX_ID
1836 ,lines1.prepay_line_number APPLIED_FROM_LINE_ID
1837 -- ,NULL APPLIED_FROM_TRX_NUMBER
1838 ,DECODE(lines1.corrected_inv_id, NULL, NULL, 200) ADJUSTED_DOC_APPLICATION_ID
1839 ,DECODE(lines1.corrected_inv_id, NULL, NULL,
1840 'AP_INVOICES') ADJUSTED_DOC_ENTITY_CODE
1841 ,DECODE(lines1.corrected_inv_id, NULL, NULL,
1842 'STANDARD INVOICES') ADJUSTED_DOC_EVENT_CLASS_CODE
1843 ,lines1.corrected_inv_id ADJUSTED_DOC_TRX_ID
1844 ,lines1.Corrected_Line_Number ADJUSTED_DOC_LINE_ID
1845 -- ,NULL ADJUSTED_DOC_NUMBER
1846 -- ,NULL ADJUSTED_DOC_DATE
1847 ,DECODE(lines1.rcv_transaction_id, NULL, NULL, 707) APPLIED_TO_APPLICATION_ID
1848 ,DECODE(lines1.rcv_transaction_id, NULL, NULL,
1849 'RCV_ACCOUNTING_EVENTS') APPLIED_TO_ENTITY_CODE
1850 ,DECODE(lines1.rcv_transaction_id, NULL, NULL,
1851 'RCPT_REC_INSP') APPLIED_TO_EVENT_CLASS_CODE
1852 ,lines1.rcv_transaction_id APPLIED_TO_TRX_ID
1853 ,lines1.rcv_shipment_line_id APPLIED_TO_LINE_ID
1854 -- ,NULL APPLIED_TO_TRX_NUMBER
1855 ,DECODE(NVL(lines1.po_release_id,lines1.po_header_id),
1856 NULL, NULL, 'SHIPMENT') REF_DOC_TRX_LEVEL_TYPE
1857 ,NVL(lines1.po_release_id, lines1.po_header_id) REF_DOC_TRX_ID
1858 ,lines1.po_line_location_id REF_DOC_LINE_ID
1859 -- ,NULL REF_DOC_LINE_QUANTITY
1860 ,DECODE(lines1.rcv_transaction_id, NULL, NULL,
1861 'LINE') APPLIED_TO_TRX_LEVEL_TYPE
1862 ,DECODE(lines1.prepay_invoice_id, NULL, NULL,
1863 'LINE') APPLIED_FROM_TRX_LEVEL_TYPE
1864 ,DECODE(lines1.corrected_inv_id, NULL, NULL,
1865 'LINE') ADJUSTED_DOC_TRX_LEVEL_TYPE
1866 -- ,NULL INTERNAL_ORG_LOCATION_ID
1867 ,'MIGRATED' RECORD_TYPE_CODE
1868 ,lines1.ASSESSABLE_VALUE -- ASSESSABLE_VALUE
1869 ,'N' TAX_AMT_INCLUDED_FLAG
1870 ,'N' COMPOUNDING_TAX_FLAG
1871 ,ap_dists.DETAIL_TAX_DIST_ID REC_NREC_TAX_DIST_ID
1872 ,ap_dists.line_type_lookup_code AP_DIST_LOOKUP_CODE
1873 -- DECODE(ap_dists.charge_applicable_to_dist_id, NULL, 1,
1874 ,RANK() OVER (PARTITION BY inv.invoice_id,
1875 ap_dists.charge_applicable_to_dist_id
1876 ORDER BY
1877 ap_dists.line_type_lookup_code desc,
1878 ap_dists.invoice_distribution_id) REC_NREC_TAX_DIST_NUMBER
1879 ,ptp.party_tax_profile_id CONTENT_OWNER_ID
1880 ,ap_dists.exchange_date CURRENCY_CONVERSION_DATE
1881 ,ap_dists.exchange_rate CURRENCY_CONVERSION_RATE
1882 ,ap_dists.exchange_rate_type CURRENCY_CONVERSION_TYPE
1883 ,ap_dists.set_of_books_id AP_LEDGER_ID
1884 ,fnd_curr.minimum_accountable_unit MINIMUM_ACCOUNTABLE_UNIT
1885 ,NVL(fnd_curr.precision, 0) PRECISION
1886 ,DECODE(NVL(lines1.po_release_id, lines1.po_header_id),
1887 NULL, NULL, 201) REF_DOC_APPLICATION_ID
1888 ,DECODE(lines1.po_release_id, NULL,
1889 DECODE(lines1.po_header_id, NULL, NULL,
1890 'PURCHASE_ORDER'), 'RELEASE') REF_DOC_ENTITY_CODE
1891 ,DECODE(lines1.po_release_id, NULL,
1892 DECODE(lines1.po_header_id, NULL, NULL,
1893 'PO_PA'), 'RELEASE') REF_DOC_EVENT_CLASS_CODE
1894 ,ap_dists.summary_tax_line_id SUMMARY_TAX_LINE_ID
1895 ,rates.TAX TAX
1896 -- ,DECODE(ap_dists.charge_applicable_to_dist_id,NULL,1,
1897 ,RANK() OVER (PARTITION BY inv.invoice_id,
1898 ap_dists1.invoice_line_number,
1899 rates.tax_regime_code, rates.tax
1900 ORDER BY
1901 ap_dists.invoice_distribution_id) TAX_APPORTIONMENT_LINE_NUMBER
1902 ,taxes.tax_currency_code -- TAX_CURRENCY_CODE
1903 ,ap_dists.exchange_date TAX_CURRENCY_CONVERSION_DATE
1904 ,ap_dists.exchange_rate TAX_CURRENCY_CONVERSION_RATE
1905 ,ap_dists.exchange_rate_type TAX_CURRENCY_CONVERSION_TYPE
1906 ,taxes.tax_id -- TAX_ID
1907 ,rates.percentage_rate TAX_RATE
1908 ,rates.tax_rate_code -- TAX_RATE_CODE
1909 ,rates.tax_rate_id -- TAX_RATE_ID
1910 ,rates.tax_regime_code -- TAX_REGIME_CODE
1911 ,regimes.tax_regime_id -- TAX_REGIME_ID
1912 ,rates.tax_status_code -- TAX_STATUS_CODE
1913 ,status.tax_status_id -- TAX_STATUS_ID
1914 ,'LINE' TRX_LEVEL_TYPE
1915 ,lines1.line_number TRX_LINE_ID
1916 ,lines1.line_number TRX_LINE_NUMBER
1917 ,ap_dists.dist_code_combination_id ACCOUNT_CCID
1918 -- ,NULL ACCOUNT_STRING
1919 -- ,NULL ADJUSTED_DOC_TAX_DIST_ID
1920 -- ,NULL APPLIED_FROM_TAX_DIST_ID
1921 -- ,NULL APPLIED_TO_DOC_CURR_CONV_RATE
1922 ,ap_dists.award_id -- AWARD_ID
1923 ,ap_dists.expenditure_item_date -- EXPENDITURE_ITEM_DATE
1924 ,ap_dists.expenditure_organization_id -- EXPENDITURE_ORGANIZATION_ID
1925 ,ap_dists.expenditure_type -- EXPENDITURE_TYPE
1926 ,NULL FUNC_CURR_ROUNDING_ADJUSTMENT
1927 ,ap_dists.ACCOUNTING_DATE GL_DATE
1928 ,ap_dists.intended_use -- INTENDED_USE
1929 ,ap_dists1.distribution_line_number ITEM_DIST_NUMBER
1930 -- ,NULL MRC_LINK_TO_TAX_DIST_ID
1931 -- ,NULL ORIG_REC_NREC_RATE
1932 -- ,NULL ORIG_REC_NREC_TAX_AMT
1933 -- ,NULL ORIG_REC_NREC_TAX_AMT_TAX_CURR
1934 -- ,NULL ORIG_REC_RATE_CODE
1935 -- ,NULL PER_TRX_CURR_UNIT_NR_AMT
1936 -- ,NULL PER_UNIT_NREC_TAX_AMT
1937 -- ,NULL PRD_TAX_AMT
1938 -- ,NULL PRICE_DIFF
1939 ,ap_dists.project_id -- PROJECT_ID
1940 -- ,NULL QTY_DIFF
1941 -- ,NULL RATE_TAX_FACTOR
1942 --,NVL(ap_dists.rec_nrec_rate, 0) REC_NREC_RATE
1943 ,100 REC_NREC_RATE
1944 ,NVL(ap_dists.amount,0) REC_NREC_TAX_AMT
1945 ,ap_dists.base_amount REC_NREC_TAX_AMT_FUNCL_CURR
1946 ,ap_dists.base_amount REC_NREC_TAX_AMT_TAX_CURR
1947 ,DECODE(ap_dists.line_type_lookup_code,
1948 'REC_TAX', 'AD_HOC_RECOVERY', NULL) RECOVERY_RATE_CODE
1949 ,DECODE(ap_dists.line_type_lookup_code,
1950 'REC_TAX', 'STANDARD', NULL) RECOVERY_TYPE_CODE
1951 ,NVL(ap_dists.amount,0) TAX_AMT
1952 ,ap_dists.base_amount TAX_AMT_FUNCL_CURR
1953 ,ap_dists.base_amount TAX_AMT_TAX_CURR
1954 -- ,NULL RECOVERY_TYPE_ID
1955 -- ,NULL REF_DOC_CURR_CONV_RATE
1956 ,ap_dists1.po_distribution_id REF_DOC_DIST_ID
1957 -- ,NULL REF_DOC_PER_UNIT_NREC_TAX_AMT
1958 -- ,NULL REF_DOC_TAX_DIST_ID
1959 -- ,NULL REF_DOC_TRX_LINE_DIST_QTY
1960 -- ,NULL REF_DOC_UNIT_PRICE
1961 -- ,NULL REF_PER_TRX_CURR_UNIT_NR_AMT
1962 ,ap_dists.parent_reversal_id REVERSED_TAX_DIST_ID
1963 -- ,NULL ROUNDING_RULE_CODE
1964 ,ap_dists.task_id -- TASK_ID
1965 ,ap_dists.taxable_base_amount TAXABLE_AMT_FUNCL_CURR
1966 ,ap_dists.taxable_base_amount TAXABLE_AMT_TAX_CURR
1967 ,ap_dists1.amount TRX_LINE_DIST_AMT
1968 ,ap_dists1.invoice_distribution_id TRX_LINE_DIST_ID
1969 ,NVL(ap_dists1.quantity_invoiced, 0) TRX_LINE_DIST_QTY
1970 ,DECODE(ap_dists.charge_applicable_to_dist_id, NULL,
1971 ap_dists.amount,
1972 SUM (ap_dists.amount) OVER
1973 (PARTITION BY ap_dists.invoice_id,
1974 ap_dists.charge_applicable_to_dist_id)) TRX_LINE_DIST_TAX_AMT
1975 -- ,NULL UNROUNDED_REC_NREC_TAX_AMT
1976 -- ,NULL UNROUNDED_TAXABLE_AMT
1977 ,ap_dists.TAXABLE_AMOUNT TAXABLE_AMT
1978 ,ap_dists.ATTRIBUTE_CATEGORY -- ATTRIBUTE_CATEGORY
1979 ,ap_dists.ATTRIBUTE1 -- ATTRIBUTE1
1980 ,ap_dists.ATTRIBUTE2 -- ATTRIBUTE2
1981 ,ap_dists.ATTRIBUTE3 -- ATTRIBUTE3
1982 ,ap_dists.ATTRIBUTE4 -- ATTRIBUTE4
1983 ,ap_dists.ATTRIBUTE5 -- ATTRIBUTE5
1984 ,ap_dists.ATTRIBUTE6 -- ATTRIBUTE6
1985 ,ap_dists.ATTRIBUTE7 -- ATTRIBUTE7
1986 ,ap_dists.ATTRIBUTE8 -- ATTRIBUTE8
1987 ,ap_dists.ATTRIBUTE9 -- ATTRIBUTE9
1988 ,ap_dists.ATTRIBUTE10 -- ATTRIBUTE10
1989 ,ap_dists.ATTRIBUTE11 -- ATTRIBUTE11
1990 ,ap_dists.ATTRIBUTE12 -- ATTRIBUTE12
1991 ,ap_dists.ATTRIBUTE13 -- ATTRIBUTE13
1992 ,ap_dists.ATTRIBUTE14 -- ATTRIBUTE14
1993 ,ap_dists.ATTRIBUTE15 -- ATTRIBUTE15
1994 ,ap_dists.GLOBAL_ATTRIBUTE_CATEGORY -- GLOBAL_ATTRIBUTE_CATEGORY
1995 ,ap_dists.GLOBAL_ATTRIBUTE1 -- GLOBAL_ATTRIBUTE1
1996 ,ap_dists.GLOBAL_ATTRIBUTE2 -- GLOBAL_ATTRIBUTE2
1997 ,ap_dists.GLOBAL_ATTRIBUTE3 -- GLOBAL_ATTRIBUTE3
1998 ,ap_dists.GLOBAL_ATTRIBUTE4 -- GLOBAL_ATTRIBUTE4
1999 ,ap_dists.GLOBAL_ATTRIBUTE5 -- GLOBAL_ATTRIBUTE5
2000 ,ap_dists.GLOBAL_ATTRIBUTE6 -- GLOBAL_ATTRIBUTE6
2001 ,ap_dists.GLOBAL_ATTRIBUTE7 -- GLOBAL_ATTRIBUTE7
2002 ,ap_dists.GLOBAL_ATTRIBUTE8 -- GLOBAL_ATTRIBUTE8
2003 ,ap_dists.GLOBAL_ATTRIBUTE9 -- GLOBAL_ATTRIBUTE9
2004 ,ap_dists.GLOBAL_ATTRIBUTE10 -- GLOBAL_ATTRIBUTE10
2005 ,ap_dists.GLOBAL_ATTRIBUTE11 -- GLOBAL_ATTRIBUTE11
2006 ,ap_dists.GLOBAL_ATTRIBUTE12 -- GLOBAL_ATTRIBUTE12
2007 ,ap_dists.GLOBAL_ATTRIBUTE13 -- GLOBAL_ATTRIBUTE13
2008 ,ap_dists.GLOBAL_ATTRIBUTE14 -- GLOBAL_ATTRIBUTE14
2009 ,ap_dists.GLOBAL_ATTRIBUTE15 -- GLOBAL_ATTRIBUTE15
2010 ,ap_dists.GLOBAL_ATTRIBUTE16 -- GLOBAL_ATTRIBUTE16
2011 ,ap_dists.GLOBAL_ATTRIBUTE17 -- GLOBAL_ATTRIBUTE17
2012 ,ap_dists.GLOBAL_ATTRIBUTE18 -- GLOBAL_ATTRIBUTE18
2013 ,ap_dists.GLOBAL_ATTRIBUTE19 -- GLOBAL_ATTRIBUTE19
2014 ,ap_dists.GLOBAL_ATTRIBUTE20 -- GLOBAL_ATTRIBUTE20
2015 ,'Y' HISTORICAL_FLAG
2016 ,'N' OVERRIDDEN_FLAG
2017 ,'N' SELF_ASSESSED_FLAG
2018 ,'Y' TAX_APPORTIONMENT_FLAG
2019 ,DECODE(ap_dists.charge_applicable_to_dist_id,
2020 NULL, 'Y', 'N') TAX_ONLY_LINE_FLAG
2021 ,'N' INCLUSIVE_FLAG
2022 ,'N' MRC_TAX_DIST_FLAG
2023 ,'N' REC_TYPE_RULE_FLAG
2024 ,'N' NEW_REC_RATE_CODE_FLAG
2025 ,NVL(ap_dists.tax_recoverable_flag, 'N') RECOVERABLE_FLAG
2026 ,ap_dists.reversal_flag REVERSE_FLAG
2027 ,'N' REC_RATE_DET_RULE_FLAG
2028 ,'N' BACKWARD_COMPATIBILITY_FLAG
2029 ,'N' FREEZE_FLAG
2030 ,DECODE(ap_dists.posted_flag, 'Y', 'A', NULL) POSTING_FLAG
2031 ,NVL(lines1.accounting_date,
2032 NVL(inv.invoice_date, sysdate)) TAX_DATE
2033 ,NVL(lines1.accounting_date,
2034 NVL(inv.invoice_date, sysdate)) TAX_DETERMINE_DATE
2035 ,NVL(lines1.accounting_date,
2036 NVL(inv.invoice_date, sysdate)) TAX_POINT_DATE
2037 ,1 CREATED_BY
2038 ,SYSDATE CREATION_DATE
2039 --,NULL LAST_MANUAL_ENTRY
2040 ,SYSDATE LAST_UPDATE_DATE
2041 ,1 LAST_UPDATE_LOGIN
2042 ,1 LAST_UPDATED_BY
2043 ,1 OBJECT_VERSION_NUMBER
2044 ,ap_dists1.old_dist_line_number ORIG_AP_CHRG_DIST_NUM
2045 ,ap_dists1.old_distribution_id ORIG_AP_CHRG_DIST_ID
2046 ,ap_dists.old_dist_line_number ORIG_AP_TAX_DIST_NUM
2047 ,ap_dists.old_distribution_id ORIG_AP_TAX_DIST_ID
2048 ,'N' MULTIPLE_JURISDICTIONS_FLAG
2049 ,DECODE(ap_dists.posted_flag, 'Y', '111111111111111',
2050 'P', '111111111111111',
2051 '000000000000000') LEGAL_REPORTING_STATUS
2052 ,DECODE(lines.discarded_flag, 'Y', 'Y', 'N') CANCEL_FLAG
2053 ,NVL(rates.def_rec_settlement_option_code,
2054 taxes.def_rec_settlement_option_code) DEF_REC_SETTLEMENT_OPTION_CODE
2055 --,TAX_JURISDICTION_ID
2056 ,rates.tax_rate_id ACCOUNT_SOURCE_TAX_RATE_ID
2057 ,(SELECT tax_rate_id FROM zx_rates_b
2058 WHERE tax_rate_code = 'AD_HOC_RECOVERY'
2059 AND rate_type_code = 'RECOVERY'
2060 AND tax_regime_code = rates.tax_regime_code
2061 AND tax = rates.tax
2062 AND content_owner_id = ptp.party_tax_profile_id
2063 AND record_type_code = 'MIGRATED'
2064 AND tax_class = 'INPUT') RECOVERY_RATE_ID
2065 ,DECODE(lines.line_source,'MANUAL LINE ENTRY','Y','N') MANUALLY_ENTERED_FLAG --BUG7146063
2066 ,DECODE(lines.line_source,'MANUAL LINE ENTRY','TAX_AMOUNT',NULL) LAST_MANUAL_ENTRY --BUG7146063
2067 FROM ap_invoices_all inv,
2068 fnd_currencies fnd_curr,
2069 -- fnd_document_sequences fds,
2070 ap_invoice_distributions_all ap_dists,
2071 ap_invoice_distributions_all ap_dists1,
2072 ap_invoice_lines_all lines1,
2073 ap_invoice_lines_all lines,
2074 zx_rates_b rates,
2075 zx_regimes_b regimes,
2076 zx_taxes_b taxes,
2077 zx_status_b status,
2078 zx_party_tax_profile ptp
2079 WHERE inv.invoice_id = p_upg_trx_info_rec.trx_id
2080 AND fnd_curr.currency_code = inv.invoice_currency_code
2081 -- AND inv.doc_sequence_id = fds.doc_sequence_id(+)
2082 AND ap_dists.invoice_id = inv.invoice_id
2083 AND ap_dists.line_type_lookup_code IN ('REC_TAX','NONREC_TAX')
2084 AND NVL(ap_dists.historical_flag, 'N') = 'Y'
2085 -- AND ap_dists1.invoice_id = ap_dists.invoice_id
2086 AND ap_dists1.invoice_distribution_id = NVL(ap_dists.charge_applicable_to_dist_id,
2087 ap_dists.invoice_distribution_id)
2088 AND lines1.invoice_id = ap_dists1.invoice_id
2089 AND lines1.line_number = ap_dists1.invoice_line_number
2090 AND NVL(lines1.historical_flag, 'N') = 'Y'
2091 AND lines.invoice_id = ap_dists.invoice_id
2092 AND lines.line_number = ap_dists.invoice_line_number
2093 AND NVL(lines.historical_flag, 'N') = 'Y'
2094 AND rates.source_id(+) = ap_dists.tax_code_id
2095 AND regimes.tax_regime_code(+) = rates.tax_regime_code
2096 AND taxes.tax_regime_code(+) = rates.tax_regime_code
2097 AND taxes.tax(+) = rates.tax
2098 AND taxes.content_owner_id(+) = rates.content_owner_id
2099 AND status.tax_regime_code(+) = rates.tax_regime_code
2100 AND status.tax(+) = rates.tax
2101 AND status.tax_status_code(+) = rates.tax_status_code
2102 AND status.content_owner_id(+) = rates.content_owner_id
2103 -- AND NVL(taxes.effective_from,
2104 -- NVL(lines1.accounting_date, NVL(inv.invoice_date, sysdate)))
2105 -- <= NVL(lines1.accounting_date, NVL(inv.invoice_date, sysdate))
2106 -- AND (NVL(taxes.effective_to,
2107 -- NVL(lines1.accounting_date,
2108 -- NVL(inv.invoice_date, sysdate)) )
2109 -- >= NVL(lines1.accounting_date, NVL(inv.invoice_date, sysdate))
2110 -- OR taxes.effective_to IS NULL)
2111 AND ptp.party_type_code = 'OU'
2112 AND ptp.party_id = DECODE(l_multi_org_flag,'N', l_org_id, ap_dists.org_id)
2113 AND NOT EXISTS -- Bug 6738188
2114 (SELECT 1 FROM zx_lines zxl
2115 WHERE zxl.application_id = 200
2116 AND zxl.event_class_code = DECODE(inv.INVOICE_TYPE_LOOKUP_CODE,
2117 'STANDARD', 'STANDARD INVOICES',
2118 'CREDIT' , 'STANDARD INVOICES',
2119 'DEBIT' , 'STANDARD INVOICES',
2120 'MIXED' , 'STANDARD INVOICES',
2121 'ADJUSTMENT','STANDARD INVOICES',
2122 'PO PRICE ADJUST','STANDARD INVOICES',
2123 'INVOICE REQUEST','STANDARD INVOICES',
2124 'CREDIT MEMO REQUEST','STANDARD INVOICES',
2125 'RETAINAGE RELEASE' ,'STANDARD INVOICES',
2126 'PREPAYMENT', 'PREPAYMENT INVOICES',
2127 'EXPENSE REPORT', 'EXPENSE REPORTS',
2128 'INTEREST INVOICE', 'INTEREST INVOICES','NA')
2129 AND zxl.trx_id = inv.invoice_id
2130 AND zxl.entity_code = 'AP_INVOICES'
2131 AND zxl.trx_line_id = lines1.line_number)
2132 );
2133
2134
2135 IF (g_level_procedure >= g_current_runtime_level ) THEN
2136 FND_LOG.STRING(g_level_procedure,
2137 'ZX.PLSQL.ZX_ON_FLY_TRX_UPGRADE_AP_PKG.upgrade_trx_on_fly_ap.END',
2138 'ZX_ON_FLY_TRX_UPGRADE_AP_PKG.upgrade_trx_on_fly_ap(+)');
2139 END IF;
2140
2141 EXCEPTION
2142 WHEN OTHERS THEN
2143 x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2144 IF (g_level_unexpected >= g_current_runtime_level ) THEN
2145 FND_LOG.STRING(g_level_unexpected,
2146 'ZX.PLSQL.ZX_ON_FLY_TRX_UPGRADE_AP_PKG.upgrade_trx_on_fly_ap',
2147 sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80));
2148 FND_LOG.STRING(g_level_unexpected,
2149 'ZX.PLSQL.ZX_ON_FLY_TRX_UPGRADE_AP_PKG.upgrade_trx_on_fly_ap.END',
2150 'ZX_ON_FLY_TRX_UPGRADE_AP_PKG.upgrade_trx_on_fly_ap(-)');
2151 END IF;
2152
2153 END upgrade_trx_on_fly_ap;
2154
2155 -------------------------------------------------------------------------------
2156 -- PUBLIC PROCEDURE
2157 -- upgrade_trx_on_fly_blk_ap
2158 --
2159 -- DESCRIPTION
2160 -- handle bulk on the fly migration for AP, called from validate and default API
2161 --
2162 -------------------------------------------------------------------------------
2163 PROCEDURE upgrade_trx_on_fly_blk_ap(
2164 x_return_status OUT NOCOPY VARCHAR2
2165 ) AS
2166
2167 l_multi_org_flag fnd_product_groups.multi_org_flag%TYPE;
2168 l_org_id NUMBER;
2169
2170 BEGIN
2171 g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
2172
2173 IF (g_level_procedure >= g_current_runtime_level ) THEN
2174 FND_LOG.STRING(g_level_procedure,
2175 'ZX.PLSQL.ZX_ON_FLY_TRX_UPGRADE_AP_PKG.upgrade_trx_on_fly_blk_ap.BEGIN',
2176 'ZX_ON_FLY_TRX_UPGRADE_AP_PKG.upgrade_trx_on_fly_blk_ap(+)');
2177 END IF;
2178
2179 x_return_status := FND_API.G_RET_STS_SUCCESS;
2180 SELECT multi_org_flag INTO l_multi_org_flag FROM fnd_product_groups;
2181
2182 -- for single org environment, get value of org_id from profile
2183 IF l_multi_org_flag = 'N' THEN
2184 FND_PROFILE.GET('ORG_ID',l_org_id);
2185 IF l_org_id is NULL THEN
2186 IF (g_level_unexpected >= g_current_runtime_level ) THEN
2187 FND_LOG.STRING(g_level_unexpected,
2188 'ZX.PLSQL.ZX_ON_FLY_TRX_UPGRADE_AP_PKG.upgrade_trx_on_fly_blk_ar',
2189 'Current envionment is a Single Org environment,'||
2190 ' but peofile ORG_ID is not set up');
2191 END IF;
2192
2193 END IF;
2194 END IF;
2195
2196 IF (g_level_statement >= g_current_runtime_level ) THEN
2197 FND_LOG.STRING(g_level_statement,
2198 'ZX.PLSQL.ZX_ON_FLY_TRX_UPGRADE_AP_PKG.upgrade_trx_on_fly_blk_ap',
2199 'Inserting data into zx_lines_det_factors and zx_lines_summary');
2200 END IF;
2201
2202 -- Insert data into zx_lines_det_factors and zx_lines_summary
2203 --
2204 INSERT ALL
2205 WHEN AP_LINE_LOOKUP_CODE IN ('ITEM', 'PREPAY','FREIGHT','MISCELLANEOUS') OR
2206 TAX_ONLY_LINE_FLAG = 'Y'
2207 THEN
2208 INTO ZX_LINES_DET_FACTORS (
2209 EVENT_ID
2210 ,OBJECT_VERSION_NUMBER
2211 ,INTERNAL_ORGANIZATION_ID
2212 ,APPLICATION_ID
2213 ,ENTITY_CODE
2214 ,EVENT_CLASS_CODE
2215 ,EVENT_TYPE_CODE
2216 ,TAX_EVENT_CLASS_CODE
2217 ,TAX_EVENT_TYPE_CODE
2218 -- ,DOC_EVENT_STATUS
2219 ,LINE_LEVEL_ACTION
2220 ,LINE_CLASS
2221 -- ,APPLICATION_DOC_STATUS
2222 ,TRX_ID
2223 ,TRX_LINE_ID
2224 ,TRX_LEVEL_TYPE
2225 ,TRX_DATE
2226 ,LEDGER_ID
2227 ,TRX_CURRENCY_CODE
2228 ,CURRENCY_CONVERSION_DATE
2229 ,CURRENCY_CONVERSION_RATE
2230 ,CURRENCY_CONVERSION_TYPE
2231 ,MINIMUM_ACCOUNTABLE_UNIT
2232 ,PRECISION
2233 ,LEGAL_ENTITY_ID
2234 -- ,ESTABLISHMENT_ID
2235 ,DEFAULT_TAXATION_COUNTRY
2236 ,TRX_NUMBER
2237 ,TRX_LINE_NUMBER
2238 ,TRX_LINE_DESCRIPTION
2239 ,TRX_DESCRIPTION
2240 ,TRX_COMMUNICATED_DATE
2241 ,TRX_LINE_GL_DATE
2242 ,BATCH_SOURCE_ID
2243 -- ,BATCH_SOURCE_NAME
2244 ,DOC_SEQ_ID
2245 ,DOC_SEQ_NAME
2246 ,DOC_SEQ_VALUE
2247 ,TRX_DUE_DATE
2248 -- ,TRX_TYPE_DESCRIPTION
2249 ,TRX_LINE_TYPE
2250 ,TRX_LINE_DATE
2251 -- ,TRX_SHIPPING_DATE
2252 -- ,TRX_RECEIPT_DATE
2253 ,LINE_AMT
2254 ,TRX_LINE_QUANTITY
2255 ,UNIT_PRICE
2256 ,PRODUCT_ID
2257 -- ,PRODUCT_ORG_ID
2258 ,UOM_CODE
2259 ,PRODUCT_TYPE
2260 -- ,PRODUCT_CODE
2261 ,PRODUCT_DESCRIPTION
2262 ,FIRST_PTY_ORG_ID
2263 -- ,ASSET_NUMBER
2264 -- ,ASSET_ACCUM_DEPRECIATION
2265 -- ,ASSET_TYPE
2266 -- ,ASSET_COST
2267 ,ACCOUNT_CCID
2268 -- ,ACCOUNT_STRING
2269 -- ,RELATED_DOC_APPLICATION_ID
2270 -- ,RELATED_DOC_ENTITY_CODE
2271 -- ,RELATED_DOC_EVENT_CLASS_CODE
2272 -- ,RELATED_DOC_TRX_ID
2273 -- ,RELATED_DOC_NUMBER
2274 -- ,RELATED_DOC_DATE
2275 ,APPLIED_FROM_APPLICATION_ID
2276 ,APPLIED_FROM_ENTITY_CODE
2277 ,APPLIED_FROM_EVENT_CLASS_CODE
2278 ,APPLIED_FROM_TRX_ID
2279 ,APPLIED_FROM_LINE_ID
2280 ,ADJUSTED_DOC_APPLICATION_ID
2281 ,ADJUSTED_DOC_ENTITY_CODE
2282 ,ADJUSTED_DOC_EVENT_CLASS_CODE
2283 ,ADJUSTED_DOC_TRX_ID
2284 ,ADJUSTED_DOC_LINE_ID
2285 -- ,ADJUSTED_DOC_NUMBER
2286 -- ,ADJUSTED_DOC_DATE
2287 ,APPLIED_TO_APPLICATION_ID
2288 ,APPLIED_TO_ENTITY_CODE
2289 ,APPLIED_TO_EVENT_CLASS_CODE
2290 ,APPLIED_TO_TRX_ID
2291 ,APPLIED_TO_TRX_LINE_ID
2292 -- ,APPLIED_TO_TRX_NUMBER
2293 ,REF_DOC_TRX_LEVEL_TYPE
2294 ,REF_DOC_APPLICATION_ID
2295 ,REF_DOC_ENTITY_CODE
2296 ,REF_DOC_EVENT_CLASS_CODE
2297 ,REF_DOC_TRX_ID
2298 ,REF_DOC_LINE_ID
2299 -- ,REF_DOC_LINE_QUANTITY
2300 ,APPLIED_TO_TRX_LEVEL_TYPE
2301 ,APPLIED_FROM_TRX_LEVEL_TYPE
2302 ,ADJUSTED_DOC_TRX_LEVEL_TYPE
2303 ,MERCHANT_PARTY_NAME
2304 ,MERCHANT_PARTY_DOCUMENT_NUMBER
2305 ,MERCHANT_PARTY_REFERENCE
2306 ,MERCHANT_PARTY_TAXPAYER_ID
2307 ,MERCHANT_PARTY_TAX_REG_NUMBER
2308 -- ,MERCHANT_PARTY_ID
2309 ,MERCHANT_PARTY_COUNTRY
2310 ,START_EXPENSE_DATE
2311 ,SHIP_TO_LOCATION_ID
2312 -- ,SHIP_FROM_LOCATION_ID
2313 -- ,BILL_TO_LOCATION_ID
2314 -- ,BILL_FROM_LOCATION_ID
2315 -- ,SHIP_TO_PARTY_TAX_PROF_ID
2316 -- ,SHIP_FROM_PARTY_TAX_PROF_ID
2317 -- ,BILL_TO_PARTY_TAX_PROF_ID
2318 -- ,BILL_FROM_PARTY_TAX_PROF_ID
2319 -- ,SHIP_TO_SITE_TAX_PROF_ID
2320 -- ,SHIP_FROM_SITE_TAX_PROF_ID
2321 -- ,BILL_TO_SITE_TAX_PROF_ID
2322 -- ,BILL_FROM_SITE_TAX_PROF_ID
2323 -- ,MERCHANT_PARTY_TAX_PROF_ID
2324 -- ,HQ_ESTB_PARTY_TAX_PROF_ID
2325 -- ,CTRL_TOTAL_LINE_TX_AMT
2326 -- ,CTRL_TOTAL_HDR_TX_AMT
2327 -- ,INPUT_TAX_CLASSIFICATION_CODE
2328 -- ,OUTPUT_TAX_CLASSIFICATION_CODE
2329 -- ,INTERNAL_ORG_LOCATION_ID
2330 ,RECORD_TYPE_CODE
2331 ,PRODUCT_FISC_CLASSIFICATION
2332 ,PRODUCT_CATEGORY
2333 ,USER_DEFINED_FISC_CLASS
2334 ,ASSESSABLE_VALUE
2335 ,TRX_BUSINESS_CATEGORY
2336 ,SUPPLIER_TAX_INVOICE_NUMBER
2337 ,SUPPLIER_TAX_INVOICE_DATE
2338 ,SUPPLIER_EXCHANGE_RATE
2339 ,TAX_INVOICE_DATE
2340 ,TAX_INVOICE_NUMBER
2341 ,DOCUMENT_SUB_TYPE
2342 ,LINE_INTENDED_USE
2343 ,PORT_OF_ENTRY_CODE
2344 -- ,SOURCE_APPLICATION_ID
2345 -- ,SOURCE_ENTITY_CODE
2346 -- ,SOURCE_EVENT_CLASS_CODE
2347 -- ,SOURCE_TRX_ID
2348 -- ,SOURCE_LINE_ID
2349 -- ,SOURCE_TRX_LEVEL_TYPE
2350 ,HISTORICAL_FLAG
2351 ,LINE_AMT_INCLUDES_TAX_FLAG
2352 ,CTRL_HDR_TX_APPL_FLAG
2353 ,TAX_REPORTING_FLAG
2354 ,TAX_AMT_INCLUDED_FLAG
2355 ,COMPOUNDING_TAX_FLAG
2356 ,INCLUSIVE_TAX_OVERRIDE_FLAG
2357 ,THRESHOLD_INDICATOR_FLAG
2358 ,USER_UPD_DET_FACTORS_FLAG
2359 ,TAX_PROCESSING_COMPLETED_FLAG
2360 ,ASSET_FLAG
2361 ,CREATION_DATE
2362 ,CREATED_BY
2363 ,LAST_UPDATE_DATE
2364 ,LAST_UPDATED_BY
2365 ,LAST_UPDATE_LOGIN
2366 ,EVENT_CLASS_MAPPING_ID
2367 ,SHIP_THIRD_PTY_ACCT_ID
2368 ,SHIP_THIRD_PTY_ACCT_SITE_ID
2369 ,GLOBAL_ATTRIBUTE_CATEGORY
2370 ,GLOBAL_ATTRIBUTE1
2371 -- ,ICX_SESSION_ID
2372 -- ,TRX_LINE_CURRENCY_CODE
2373 -- ,TRX_LINE_CURRENCY_CONV_RATE
2374 -- ,TRX_LINE_CURRENCY_CONV_DATE
2375 -- ,TRX_LINE_PRECISION
2376 -- ,TRX_LINE_MAU
2377 -- ,TRX_LINE_CURRENCY_CONV_TYPE
2378 -- ,INTERFACE_ENTITY_CODE
2379 -- ,INTERFACE_LINE_ID
2380 -- ,SOURCE_TAX_LINE_ID
2381 ,BILL_THIRD_PTY_ACCT_ID
2382 ,BILL_THIRD_PTY_ACCT_SITE_ID
2383 )
2384 VALUES(
2385 EVENT_ID
2386 ,OBJECT_VERSION_NUMBER
2387 ,INTERNAL_ORGANIZATION_ID
2388 ,APPLICATION_ID
2389 ,ENTITY_CODE
2390 ,EVENT_CLASS_CODE
2391 ,EVENT_TYPE_CODE
2392 ,TAX_EVENT_CLASS_CODE
2393 ,TAX_EVENT_TYPE_CODE
2394 -- ,DOC_EVENT_STATUS
2395 ,LINE_LEVEL_ACTION
2396 ,LINE_CLASS
2397 -- ,APPLICATION_DOC_STATUS
2398 ,TRX_ID
2399 ,TRX_LINE_ID
2400 ,TRX_LEVEL_TYPE
2401 ,TRX_DATE
2402 ,LEDGER_ID
2403 ,TRX_CURRENCY_CODE
2404 ,CURRENCY_CONVERSION_DATE
2405 ,CURRENCY_CONVERSION_RATE
2406 ,CURRENCY_CONVERSION_TYPE
2407 ,MINIMUM_ACCOUNTABLE_UNIT
2408 ,PRECISION
2409 ,LEGAL_ENTITY_ID
2410 -- ,ESTABLISHMENT_ID
2411 ,DEFAULT_TAXATION_COUNTRY
2412 ,TRX_NUMBER
2413 ,TRX_LINE_NUMBER
2414 ,TRX_LINE_DESCRIPTION
2415 ,TRX_DESCRIPTION
2416 ,TRX_COMMUNICATED_DATE
2417 ,TRX_LINE_GL_DATE
2418 ,BATCH_SOURCE_ID
2419 -- ,BATCH_SOURCE_NAME
2420 ,DOC_SEQ_ID
2421 ,DOC_SEQ_NAME
2422 ,DOC_SEQ_VALUE
2423 ,TRX_DUE_DATE
2424 -- ,TRX_TYPE_DESCRIPTION
2425 ,TRX_LINE_TYPE
2426 ,TRX_LINE_DATE
2427 -- ,TRX_SHIPPING_DATE
2428 -- ,TRX_RECEIPT_DATE
2429 ,LINE_AMT
2430 ,TRX_LINE_QUANTITY
2431 ,UNIT_PRICE
2432 ,PRODUCT_ID
2433 -- ,PRODUCT_ORG_ID
2434 ,UOM_CODE
2435 ,PRODUCT_TYPE
2436 -- ,PRODUCT_CODE
2437 ,PRODUCT_DESCRIPTION
2438 ,FIRST_PTY_ORG_ID
2439 -- ,ASSET_NUMBER
2440 -- ,ASSET_ACCUM_DEPRECIATION
2441 -- ,ASSET_TYPE
2442 -- ,ASSET_COST
2443 ,ACCOUNT_CCID
2444 -- ,ACCOUNT_STRING
2445 -- ,RELATED_DOC_APPLICATION_ID
2446 -- ,RELATED_DOC_ENTITY_CODE
2447 -- ,RELATED_DOC_EVENT_CLASS_CODE
2448 -- ,RELATED_DOC_TRX_ID
2449 -- ,RELATED_DOC_NUMBER
2450 -- ,RELATED_DOC_DATE
2451 ,APPLIED_FROM_APPLICATION_ID
2452 ,APPLIED_FROM_ENTITY_CODE
2453 ,APPLIED_FROM_EVENT_CLASS_CODE
2454 ,APPLIED_FROM_TRX_ID
2455 ,APPLIED_FROM_LINE_ID
2456 ,ADJUSTED_DOC_APPLICATION_ID
2457 ,ADJUSTED_DOC_ENTITY_CODE
2458 ,ADJUSTED_DOC_EVENT_CLASS_CODE
2459 ,ADJUSTED_DOC_TRX_ID
2460 ,ADJUSTED_DOC_LINE_ID
2461 -- ,ADJUSTED_DOC_NUMBER
2462 -- ,ADJUSTED_DOC_DATE
2463 ,APPLIED_TO_APPLICATION_ID
2464 ,APPLIED_TO_ENTITY_CODE
2465 ,APPLIED_TO_EVENT_CLASS_CODE
2466 ,APPLIED_TO_TRX_ID
2467 ,APPLIED_TO_TRX_LINE_ID
2468 -- ,APPLIED_TO_TRX_NUMBER
2469 ,REF_DOC_TRX_LEVEL_TYPE
2470 ,REF_DOC_APPLICATION_ID
2471 ,REF_DOC_ENTITY_CODE
2472 ,REF_DOC_EVENT_CLASS_CODE
2473 ,REF_DOC_TRX_ID
2474 ,REF_DOC_LINE_ID
2475 -- ,REF_DOC_LINE_QUANTITY
2476 ,APPLIED_TO_TRX_LEVEL_TYPE
2477 ,APPLIED_FROM_TRX_LEVEL_TYPE
2478 ,ADJUSTED_DOC_TRX_LEVEL_TYPE
2479 ,MERCHANT_PARTY_NAME
2480 ,MERCHANT_PARTY_DOCUMENT_NUMBER
2481 ,MERCHANT_PARTY_REFERENCE
2482 ,MERCHANT_PARTY_TAXPAYER_ID
2483 ,MERCHANT_PARTY_TAX_REG_NUMBER
2484 -- ,MERCHANT_PARTY_ID
2485 ,MERCHANT_PARTY_COUNTRY
2486 ,START_EXPENSE_DATE
2487 ,SHIP_TO_LOCATION_ID
2488 -- ,SHIP_FROM_LOCATION_ID
2489 -- ,BILL_TO_LOCATION_ID
2490 -- ,BILL_FROM_LOCATION_ID
2491 -- ,SHIP_TO_PARTY_TAX_PROF_ID
2492 -- ,SHIP_FROM_PARTY_TAX_PROF_ID
2493 -- ,BILL_TO_PARTY_TAX_PROF_ID
2494 -- ,BILL_FROM_PARTY_TAX_PROF_ID
2495 -- ,SHIP_TO_SITE_TAX_PROF_ID
2496 -- ,SHIP_FROM_SITE_TAX_PROF_ID
2497 -- ,BILL_TO_SITE_TAX_PROF_ID
2498 -- ,BILL_FROM_SITE_TAX_PROF_ID
2499 -- ,MERCHANT_PARTY_TAX_PROF_ID
2500 -- ,HQ_ESTB_PARTY_TAX_PROF_ID
2501 -- ,CTRL_TOTAL_LINE_TX_AMT
2502 -- ,CTRL_TOTAL_HDR_TX_AMT
2503 -- ,INPUT_TAX_CLASSIFICATION_CODE
2504 -- ,OUTPUT_TAX_CLASSIFICATION_CODE
2505 -- ,INTERNAL_ORG_LOCATION_ID
2506 ,RECORD_TYPE_CODE
2507 ,PRODUCT_FISC_CLASSIFICATION
2508 ,PRODUCT_CATEGORY
2509 ,USER_DEFINED_FISC_CLASS
2510 ,ASSESSABLE_VALUE
2511 ,TRX_BUSINESS_CATEGORY
2512 ,SUPPLIER_TAX_INVOICE_NUMBER
2513 ,SUPPLIER_TAX_INVOICE_DATE
2514 ,SUPPLIER_EXCHANGE_RATE
2515 ,TAX_INVOICE_DATE
2516 ,TAX_INVOICE_NUMBER
2517 ,DOCUMENT_SUB_TYPE
2518 ,LINE_INTENDED_USE
2519 ,PORT_OF_ENTRY_CODE
2520 -- ,SOURCE_APPLICATION_ID
2521 -- ,SOURCE_ENTITY_CODE
2522 -- ,SOURCE_EVENT_CLASS_CODE
2523 -- ,SOURCE_TRX_ID
2524 -- ,SOURCE_LINE_ID
2525 -- ,SOURCE_TRX_LEVEL_TYPE
2526 ,HISTORICAL_FLAG
2527 ,LINE_AMT_INCLUDES_TAX_FLAG
2528 ,CTRL_HDR_TX_APPL_FLAG
2529 ,TAX_REPORTING_FLAG
2530 ,TAX_AMT_INCLUDED_FLAG
2531 ,COMPOUNDING_TAX_FLAG
2532 ,INCLUSIVE_TAX_OVERRIDE_FLAG
2533 ,THRESHOLD_INDICATOR_FLAG
2534 ,USER_UPD_DET_FACTORS_FLAG
2535 ,TAX_PROCESSING_COMPLETED_FLAG
2536 ,ASSET_FLAG
2537 ,CREATION_DATE
2538 ,CREATED_BY
2539 ,LAST_UPDATE_DATE
2540 ,LAST_UPDATED_BY
2541 ,LAST_UPDATE_LOGIN
2542 ,EVENT_CLASS_MAPPING_ID
2543 ,SHIP_THIRD_PTY_ACCT_ID
2544 ,SHIP_THIRD_PTY_ACCT_SITE_ID
2545 ,GLOBAL_ATTRIBUTE_CATEGORY
2546 ,GLOBAL_ATTRIBUTE1
2547 -- ,ICX_SESSION_ID
2548 -- ,TRX_LINE_CURRENCY_CODE
2549 -- ,TRX_LINE_CURRENCY_CONV_RATE
2550 -- ,TRX_LINE_CURRENCY_CONV_DATE
2551 -- ,TRX_LINE_PRECISION
2552 -- ,TRX_LINE_MAU
2553 -- ,TRX_LINE_CURRENCY_CONV_TYPE
2554 -- ,INTERFACE_ENTITY_CODE
2555 -- ,INTERFACE_LINE_ID
2556 -- ,SOURCE_TAX_LINE_ID
2557 ,BILL_THIRD_PTY_ACCT_ID
2558 ,BILL_THIRD_PTY_ACCT_SITE_ID
2559 )
2560 WHEN AP_LINE_LOOKUP_CODE = 'TAX' THEN
2561 INTO ZX_LINES_SUMMARY (
2562 SUMMARY_TAX_LINE_ID
2563 ,INTERNAL_ORGANIZATION_ID
2564 ,APPLICATION_ID
2565 ,ENTITY_CODE
2566 ,EVENT_CLASS_CODE
2567 ,TRX_ID
2568 ,TRX_NUMBER
2569 ,APPLIED_FROM_APPLICATION_ID
2570 ,APPLIED_FROM_EVENT_CLASS_CODE
2571 ,APPLIED_FROM_ENTITY_CODE
2572 ,APPLIED_FROM_TRX_ID
2573 ,ADJUSTED_DOC_APPLICATION_ID
2574 ,ADJUSTED_DOC_ENTITY_CODE
2575 ,ADJUSTED_DOC_EVENT_CLASS_CODE
2576 ,ADJUSTED_DOC_TRX_ID
2577 ,SUMMARY_TAX_LINE_NUMBER
2578 ,CONTENT_OWNER_ID
2579 ,TAX_REGIME_CODE
2580 ,TAX
2581 ,TAX_STATUS_CODE
2582 ,TAX_RATE_ID
2583 ,TAX_RATE_CODE
2584 ,TAX_RATE
2585 ,TAX_AMT
2586 ,TAX_AMT_TAX_CURR
2587 ,TAX_AMT_FUNCL_CURR
2588 ,TAX_JURISDICTION_CODE
2589 ,TOTAL_REC_TAX_AMT
2590 ,TOTAL_REC_TAX_AMT_FUNCL_CURR
2591 ,TOTAL_NREC_TAX_AMT
2592 ,TOTAL_NREC_TAX_AMT_FUNCL_CURR
2593 ,LEDGER_ID
2594 ,LEGAL_ENTITY_ID
2595 -- ,ESTABLISHMENT_ID
2596 ,CURRENCY_CONVERSION_DATE
2597 ,CURRENCY_CONVERSION_TYPE
2598 ,CURRENCY_CONVERSION_RATE
2599 -- ,SUMMARIZATION_TEMPLATE_ID
2600 ,TAXABLE_BASIS_FORMULA
2601 ,TAX_CALCULATION_FORMULA
2602 ,HISTORICAL_FLAG
2603 ,CANCEL_FLAG
2604 ,DELETE_FLAG
2605 ,TAX_AMT_INCLUDED_FLAG
2606 ,COMPOUNDING_TAX_FLAG
2607 ,SELF_ASSESSED_FLAG
2608 ,OVERRIDDEN_FLAG
2609 ,REPORTING_ONLY_FLAG
2610 ,ASSOCIATED_CHILD_FROZEN_FLAG
2611 ,COPIED_FROM_OTHER_DOC_FLAG
2612 ,MANUALLY_ENTERED_FLAG
2613 ,LAST_MANUAL_ENTRY --BUG7146063
2614 ,RECORD_TYPE_CODE
2615 -- ,TAX_PROVIDER_ID
2616 ,TAX_ONLY_LINE_FLAG
2617 ,CREATED_BY
2618 ,CREATION_DATE
2619 ,LAST_UPDATED_BY
2620 ,LAST_UPDATE_DATE
2621 ,LAST_UPDATE_LOGIN
2622 ,ATTRIBUTE_CATEGORY
2623 ,ATTRIBUTE1
2624 ,ATTRIBUTE2
2625 ,ATTRIBUTE3
2626 ,ATTRIBUTE4
2627 ,ATTRIBUTE5
2628 ,ATTRIBUTE6
2629 ,ATTRIBUTE7
2630 ,ATTRIBUTE8
2631 ,ATTRIBUTE9
2632 ,ATTRIBUTE10
2633 ,ATTRIBUTE11
2634 ,ATTRIBUTE12
2635 ,ATTRIBUTE13
2636 ,ATTRIBUTE14
2637 ,ATTRIBUTE15
2638 ,APPLIED_FROM_LINE_ID
2639 ,APPLIED_TO_APPLICATION_ID
2640 ,APPLIED_TO_EVENT_CLASS_CODE
2641 ,APPLIED_TO_ENTITY_CODE
2642 ,APPLIED_TO_TRX_ID
2643 ,APPLIED_TO_LINE_ID
2644 -- ,TAX_EXEMPTION_ID
2645 -- ,TAX_RATE_BEFORE_EXEMPTION
2646 -- ,TAX_RATE_NAME_BEFORE_EXEMPTION
2647 -- ,EXEMPT_RATE_MODIFIER
2648 -- ,EXEMPT_CERTIFICATE_NUMBER
2649 -- ,EXEMPT_REASON
2650 -- ,EXEMPT_REASON_CODE
2651 -- ,TAX_RATE_BEFORE_EXCEPTION
2652 -- ,TAX_RATE_NAME_BEFORE_EXCEPTION
2653 -- ,TAX_EXCEPTION_ID
2654 -- ,EXCEPTION_RATE
2655 ,TOTAL_REC_TAX_AMT_TAX_CURR
2656 ,TOTAL_NREC_TAX_AMT_TAX_CURR
2657 ,MRC_TAX_LINE_FLAG
2658 ,GLOBAL_ATTRIBUTE_CATEGORY
2659 ,GLOBAL_ATTRIBUTE1
2660 ,GLOBAL_ATTRIBUTE2
2661 ,GLOBAL_ATTRIBUTE3
2662 ,GLOBAL_ATTRIBUTE4
2663 ,GLOBAL_ATTRIBUTE5
2664 ,GLOBAL_ATTRIBUTE6
2665 ,GLOBAL_ATTRIBUTE7
2666 ,GLOBAL_ATTRIBUTE8
2667 ,GLOBAL_ATTRIBUTE9
2668 ,GLOBAL_ATTRIBUTE10
2669 ,GLOBAL_ATTRIBUTE11
2670 ,GLOBAL_ATTRIBUTE12
2671 ,GLOBAL_ATTRIBUTE13
2672 ,GLOBAL_ATTRIBUTE14
2673 ,GLOBAL_ATTRIBUTE15
2674 ,GLOBAL_ATTRIBUTE16
2675 ,GLOBAL_ATTRIBUTE17
2676 ,GLOBAL_ATTRIBUTE18
2677 ,GLOBAL_ATTRIBUTE19
2678 ,GLOBAL_ATTRIBUTE20
2679 ,APPLIED_FROM_TRX_LEVEL_TYPE
2680 ,ADJUSTED_DOC_TRX_LEVEL_TYPE
2681 ,APPLIED_TO_TRX_LEVEL_TYPE
2682 ,TRX_LEVEL_TYPE
2683 ,ADJUST_TAX_AMT_FLAG
2684 ,OBJECT_VERSION_NUMBER)
2685 VALUES(
2686 SUMMARY_TAX_LINE_ID
2687 ,INTERNAL_ORGANIZATION_ID
2688 ,APPLICATION_ID
2689 ,ENTITY_CODE
2690 ,EVENT_CLASS_CODE
2691 ,TRX_ID
2692 ,TRX_NUMBER
2693 ,APPLIED_FROM_APPLICATION_ID
2694 ,APPLIED_FROM_EVENT_CLASS_CODE
2695 ,APPLIED_FROM_ENTITY_CODE
2696 ,APPLIED_FROM_TRX_ID
2697 ,ADJUSTED_DOC_APPLICATION_ID
2698 ,ADJUSTED_DOC_ENTITY_CODE
2699 ,ADJUSTED_DOC_EVENT_CLASS_CODE
2700 ,ADJUSTED_DOC_TRX_ID
2701 ,SUMMARY_TAX_LINE_NUMBER
2702 ,CONTENT_OWNER_ID
2703 ,TAX_REGIME_CODE
2704 ,TAX
2705 ,TAX_STATUS_CODE
2706 ,TAX_RATE_ID
2707 ,TAX_RATE_CODE
2708 ,TAX_RATE
2709 ,TAX_AMT
2710 ,TAX_AMT_TAX_CURR
2711 ,TAX_AMT_FUNCL_CURR
2712 ,TAX_JURISDICTION_CODE
2713 ,TOTAL_REC_TAX_AMT
2714 ,TOTAL_REC_TAX_AMT_FUNCL_CURR
2715 ,TOTAL_NREC_TAX_AMT
2716 ,TOTAL_NREC_TAX_AMT_FUNCL_CURR
2717 ,LEDGER_ID
2718 ,LEGAL_ENTITY_ID
2719 -- ,ESTABLISHMENT_ID
2720 ,CURRENCY_CONVERSION_DATE
2721 ,CURRENCY_CONVERSION_TYPE
2722 ,CURRENCY_CONVERSION_RATE
2723 -- ,NULL -- SUMMARIZATION_TEMPLATE_ID
2724 ,'STANDARD_TB' -- TAXABLE_BASIS_FORMULA
2725 ,'STANDARD_TC' -- TAX_CALCULATION_FORMULA
2726 ,HISTORICAL_FLAG
2727 ,CANCEL_FLAG
2728 ,'N' -- DELETE_FLAG
2729 ,TAX_AMT_INCLUDED_FLAG
2730 ,COMPOUNDING_TAX_FLAG
2731 ,SELF_ASSESSED_FLAG
2732 ,OVERRIDDEN_FLAG
2733 ,'N' -- REPORTING_ONLY_FLAG
2734 ,'N' -- ASSOCIATED_CHILD_FROZEN_FLAG
2735 ,'N' -- COPIED_FROM_OTHER_DOC_FLAG
2736 ,MANUALLY_ENTERED_FLAG --BUG7146063
2737 ,LAST_MANUAL_ENTRY --BUG7146063
2738 ,RECORD_TYPE_CODE
2739 -- ,NULL -- TAX_PROVIDER_ID
2740 ,TAX_ONLY_LINE_FLAG
2741 ,CREATED_BY
2742 ,CREATION_DATE
2743 ,LAST_UPDATED_BY
2744 ,LAST_UPDATE_DATE
2745 ,LAST_UPDATE_LOGIN
2746 ,ATTRIBUTE_CATEGORY
2747 ,ATTRIBUTE1
2748 ,ATTRIBUTE2
2749 ,ATTRIBUTE3
2750 ,ATTRIBUTE4
2751 ,ATTRIBUTE5
2752 ,ATTRIBUTE6
2753 ,ATTRIBUTE7
2754 ,ATTRIBUTE8
2755 ,ATTRIBUTE9
2756 ,ATTRIBUTE10
2757 ,ATTRIBUTE11
2758 ,ATTRIBUTE12
2759 ,ATTRIBUTE13
2760 ,ATTRIBUTE14
2761 ,ATTRIBUTE15
2762 ,APPLIED_FROM_LINE_ID
2763 ,APPLIED_TO_APPLICATION_ID
2764 ,APPLIED_TO_EVENT_CLASS_CODE
2765 ,APPLIED_TO_ENTITY_CODE
2766 ,APPLIED_TO_TRX_ID
2767 ,APPLIED_TO_TRX_LINE_ID -- APPLIED_TO_LINE_ID
2768 -- ,NULL -- TAX_EXEMPTION_ID
2769 -- ,NULL -- TAX_RATE_BEFORE_EXEMPTION
2770 -- ,NULL -- TAX_RATE_NAME_BEFORE_EXEMPTION
2771 -- ,NULL -- EXEMPT_RATE_MODIFIER
2772 -- ,NULL -- EXEMPT_CERTIFICATE_NUMBER
2773 -- ,NULL -- EXEMPT_REASON
2774 -- ,NULL -- EXEMPT_REASON_CODE
2775 -- ,NULL -- TAX_RATE_BEFORE_EXCEPTION
2776 -- ,NULL -- TAX_RATE_NAME_BEFORE_EXCEPTION
2777 -- ,NULL -- TAX_EXCEPTION_ID
2778 -- ,NULL -- EXCEPTION_RATE
2779 ,TOTAL_REC_TAX_AMT_FUNCL_CURR
2780 ,TOTAL_NREC_TAX_AMT_FUNCL_CURR
2781 ,'N' -- MRC_TAX_LINE_FLAG
2782 ,GLOBAL_ATTRIBUTE_CATEGORY
2783 ,GLOBAL_ATTRIBUTE1
2784 ,GLOBAL_ATTRIBUTE2
2785 ,GLOBAL_ATTRIBUTE3
2786 ,GLOBAL_ATTRIBUTE4
2787 ,GLOBAL_ATTRIBUTE5
2788 ,GLOBAL_ATTRIBUTE6
2789 ,GLOBAL_ATTRIBUTE7
2790 ,GLOBAL_ATTRIBUTE8
2791 ,GLOBAL_ATTRIBUTE9
2792 ,GLOBAL_ATTRIBUTE10
2793 ,GLOBAL_ATTRIBUTE11
2794 ,GLOBAL_ATTRIBUTE12
2795 ,GLOBAL_ATTRIBUTE13
2796 ,GLOBAL_ATTRIBUTE14
2797 ,GLOBAL_ATTRIBUTE15
2798 ,GLOBAL_ATTRIBUTE16
2799 ,GLOBAL_ATTRIBUTE17
2800 ,GLOBAL_ATTRIBUTE18
2801 ,GLOBAL_ATTRIBUTE19
2802 ,GLOBAL_ATTRIBUTE20
2803 ,APPLIED_FROM_TRX_LEVEL_TYPE
2804 ,ADJUSTED_DOC_TRX_LEVEL_TYPE
2805 ,APPLIED_TO_TRX_LEVEL_TYPE
2806 ,TRX_LEVEL_TYPE
2807 ,NULL -- ADJUST_TAX_AMT_FLAG
2808 ,OBJECT_VERSION_NUMBER
2809 )
2810 (SELECT /*+ ROWID(inv) ORDERED use_nl(fnd_curr,fds,lines,poll,ptp)*/
2811 NULL EVENT_ID
2812 ,1 OBJECT_VERSION_NUMBER
2813 ,NVL(lines.org_id,-99) INTERNAL_ORGANIZATION_ID
2814 ,200 APPLICATION_ID
2815 ,'AP_INVOICES' ENTITY_CODE
2816 ,DECODE(inv.INVOICE_TYPE_LOOKUP_CODE,
2817 'STANDARD', 'STANDARD INVOICES',
2818 'CREDIT' , 'STANDARD INVOICES', --Bug 6489409
2819 'DEBIT' , 'STANDARD INVOICES', --Bug 6489409
2820 'MIXED' , 'STANDARD INVOICES', --Bug 6489409
2821 'ADJUSTMENT','STANDARD INVOICES', --Bug 6489409
2822 'PO PRICE ADJUST','STANDARD INVOICES', --Bug 6489409
2823 'INVOICE REQUEST','STANDARD INVOICES', --Bug 6489409
2824 'CREDIT MEMO REQUEST','STANDARD INVOICES',--Bug 6489409
2825 'RETAINAGE RELEASE' ,'STANDARD INVOICES',--Bug 6489409
2826 'PREPAYMENT', 'PREPAYMENT INVOICES',
2827 'EXPENSE REPORT', 'EXPENSE REPORTS',
2828 'INTEREST INVOICE', 'INTEREST INVOICES','NA') EVENT_CLASS_CODE
2829 ,DECODE(inv.INVOICE_TYPE_LOOKUP_CODE, 'STANDARD', 1,
2830 'PREPAYMENT', 7, 'EXPENSE REPORT', 2, NULL) EVENT_CLASS_MAPPING_ID
2831 ,DECODE(inv.INVOICE_TYPE_LOOKUP_CODE,
2832 'STANDARD','STANDARD INVOICE CREATED',
2833 'PREPAYMENT','PREPAYMENT INVOICE CREATED',
2834 'EXPENSE REPORT','EXPENSE REPORT CREATED',
2835 'INTEREST INVOICE','INTEREST INVOICE CREATED','NA') EVENT_TYPE_CODE
2836 ,(CASE
2837 WHEN inv.invoice_type_lookup_code in
2838 ('ADJUSTMENT','CREDIT','DEBIT','INTEREST',
2839 'MIXED','QUICKDEFAULT','PO PRICE ADJUST',
2840 'QUICKMATCH','STANDARD','AWT')
2841 THEN 'PURCHASE_TRANSACTION'
2842 WHEN inv.invoice_type_lookup_code = 'PREPAYMENT'
2843 THEN 'PURCHASE_PREPAYMENTTRANSACTION'
2844 WHEN inv.invoice_type_lookup_code='EXPENSE REPORT'
2845 THEN 'EXPENSE_REPORT'
2846 ELSE NULL
2847 END) TAX_EVENT_CLASS_CODE
2848 ,'VALIDATE' TAX_EVENT_TYPE_CODE
2849 -- ,NULL DOC_EVENT_STATUS
2850 ,'CREATE' LINE_LEVEL_ACTION
2851 ,DECODE(lines.po_line_location_id,
2852 NULL, DECODE(lines.line_type_lookup_code,
2853 'PREPAY', 'PREPAY_APPLICATION',
2854 DECODE(inv.invoice_type_lookup_code,
2855 'STANDARD', 'STANDARD INVOICES',
2856 'CREDIT','AP_CREDIT_MEMO',
2857 'CREDIT MEMO REQUEST', 'AP_CREDIT_MEMO',
2858 'DEBIT','AP_DEBIT_MEMO',
2859 'PREPAYMENT','PREPAYMENT INVOICES',
2860 'EXPENSE REPORT','EXPENSE REPORTS',
2861 'STANDARD INVOICES'
2862 )
2863 ),
2864 DECODE(poll.shipment_type,
2865 'PREPAYMENT', DECODE(poll.payment_type,
2866 'ADVANCE', 'ADVANCE',
2867 'MILESTONE', 'FINANCING',
2868 'RATE', 'FINANCING',
2869 'LUMPSUM', 'FINANCING',
2870 DECODE(poll.matching_basis,
2871 'AMOUNT','AMOUNT_MATCHED',
2872 'STANDARD INVOICES')
2873 ),
2874 DECODE(poll.matching_basis,
2875 'AMOUNT','AMOUNT_MATCHED',
2876 'STANDARD INVOICES')
2877 )
2878 ) LINE_CLASS
2879 -- ,NULL APPLICATION_DOC_STATUS
2880 ,lines.line_type_lookup_code AP_LINE_LOOKUP_CODE
2881 ,lines.invoice_id TRX_ID
2882 ,NVL(inv.invoice_date,sysdate) TRX_DATE
2883 ,lines.set_of_books_id LEDGER_ID
2884 ,inv.invoice_currency_code TRX_CURRENCY_CODE
2885 ,NVL(inv.legal_entity_id, -99) LEGAL_ENTITY_ID
2886 -- ,NULL ESTABLISHMENT_ID
2887 ,inv.taxation_country DEFAULT_TAXATION_COUNTRY
2888 ,inv.invoice_num TRX_NUMBER
2889 ,lines.description TRX_LINE_DESCRIPTION
2890 ,inv.description TRX_DESCRIPTION
2891 ,inv.invoice_received_date TRX_COMMUNICATED_DATE
2892 ,NVL(lines.accounting_date,sysdate) TRX_LINE_GL_DATE
2893 ,inv.batch_id BATCH_SOURCE_ID
2894 -- ,NULL BATCH_SOURCE_NAME
2895 ,inv.doc_sequence_id DOC_SEQ_ID
2896 ,fds.name DOC_SEQ_NAME
2897 ,inv.doc_sequence_value DOC_SEQ_VALUE
2898 ,inv.terms_date TRX_DUE_DATE
2899 -- ,NULL TRX_TYPE_DESCRIPTION
2900 ,lines.line_type_lookup_code TRX_LINE_TYPE
2901 ,lines.accounting_date TRX_LINE_DATE
2902 -- ,NULL TRX_SHIPPING_DATE
2903 -- ,NULL TRX_RECEIPT_DATE
2904 ,NVL(lines.amount,0) LINE_AMT
2905 ,lines.quantity_invoiced TRX_LINE_QUANTITY
2906 ,lines.unit_price -- UNIT_PRICE
2907 ,lines.inventory_item_id PRODUCT_ID
2908 -- ,NULL PRODUCT_ORG_ID
2909 ,lines.unit_meas_lookup_code UOM_CODE
2910 ,lines.product_type -- PRODUCT_TYPE
2911 -- ,NULL PRODUCT_CODE
2912 ,lines.item_description PRODUCT_DESCRIPTION
2913 ,ptp.party_tax_profile_id FIRST_PTY_ORG_ID
2914 -- ,NULL ASSET_NUMBER
2915 -- ,NULL ASSET_ACCUM_DEPRECIATION
2916 -- ,NULL ASSET_TYPE
2917 -- ,NULL ASSET_COST
2918 -- ,NULL RELATED_DOC_APPLICATION_ID,
2919 -- ,NULL RELATED_DOC_ENTITY_CODE
2920 -- ,NULL RELATED_DOC_EVENT_CLASS_CODE
2921 -- ,NULL RELATED_DOC_TRX_ID
2922 -- ,NULL RELATED_DOC_NUMBER
2923 -- ,NULL RELATED_DOC_DATE
2924 ,DECODE(lines.prepay_invoice_id, NULL, NULL, 200) APPLIED_FROM_APPLICATION_ID
2925 ,DECODE(lines.prepay_invoice_id, NULL, NULL,
2926 'AP_INVOICES') APPLIED_FROM_ENTITY_CODE
2927 ,DECODE(lines.prepay_invoice_id, NULL, NULL,
2928 'PREPAYMENT INVOICES') APPLIED_FROM_EVENT_CLASS_CODE
2929 ,lines.prepay_invoice_id APPLIED_FROM_TRX_ID
2930 ,lines.prepay_line_number APPLIED_FROM_LINE_ID
2931 ,DECODE(lines.corrected_inv_id, NULL, NULL, 200) ADJUSTED_DOC_APPLICATION_ID
2932 ,DECODE(lines.corrected_inv_id, NULL, NULL,
2933 'AP_INVOICES') ADJUSTED_DOC_ENTITY_CODE
2934 ,DECODE(lines.corrected_inv_id, NULL, NULL,
2935 'STANDARD INVOICES') ADJUSTED_DOC_EVENT_CLASS_CODE
2936 ,lines.corrected_inv_id ADJUSTED_DOC_TRX_ID
2937 ,lines.corrected_line_number ADJUSTED_DOC_LINE_ID
2938 -- ,NULL ADJUSTED_DOC_NUMBER
2939 -- ,NULL ADJUSTED_DOC_DATE
2940 ,DECODE(lines.rcv_transaction_id, NULL, NULL, 707) APPLIED_TO_APPLICATION_ID
2941 ,DECODE(lines.rcv_transaction_id, NULL, NULL,
2942 'RCV_ACCOUNTING_EVENTS') APPLIED_TO_ENTITY_CODE
2943 ,DECODE(lines.rcv_transaction_id, NULL, NULL,
2944 'RCPT_REC_INSP') APPLIED_TO_EVENT_CLASS_CODE
2945 ,lines.rcv_transaction_id APPLIED_TO_TRX_ID
2946 ,lines.rcv_shipment_line_id APPLIED_TO_TRX_LINE_ID
2947 -- ,NULL APPLIED_TO_TRX_NUMBER
2948 ,DECODE(NVL(lines.po_release_id, lines.po_header_id),
2949 NULL, NULL, 'SHIPMENT') REF_DOC_TRX_LEVEL_TYPE
2950 ,NVL(lines.po_release_id, lines.po_header_id) REF_DOC_TRX_ID
2951 ,lines.po_line_location_id REF_DOC_LINE_ID
2952 -- ,NULL REF_DOC_LINE_QUANTITY
2953 ,DECODE(lines.rcv_transaction_id, NULL, NULL,
2954 'LINE') APPLIED_TO_TRX_LEVEL_TYPE
2955 ,DECODE(lines.prepay_invoice_id, NULL, NULL,
2956 'LINE') APPLIED_FROM_TRX_LEVEL_TYPE
2957 ,DECODE(lines.corrected_inv_id, NULL, NULL,
2958 'LINE') ADJUSTED_DOC_TRX_LEVEL_TYPE
2959 ,lines.merchant_name MERCHANT_PARTY_NAME
2960 ,lines.merchant_document_number MERCHANT_PARTY_DOCUMENT_NUMBER
2961 ,lines.merchant_reference MERCHANT_PARTY_REFERENCE
2962 ,lines.merchant_taxpayer_id MERCHANT_PARTY_TAXPAYER_ID
2963 ,lines.merchant_tax_reg_number MERCHANT_PARTY_TAX_REG_NUMBER
2964 -- ,NULL MERCHANT_PARTY_ID
2965 ,lines.country_of_supply MERCHANT_PARTY_COUNTRY
2966 ,lines.start_expense_date -- START_EXPENSE_DATE
2967 ,lines.ship_to_location_id -- SHIP_TO_LOCATION_ID
2968 -- ,NULL SHIP_FROM_LOCATION_ID
2969 -- ,NULL BILL_TO_LOCATION_ID
2970 -- ,NULL BILL_FROM_LOCATION_ID
2971 -- ,NULL SHIP_TO_PARTY_TAX_PROF_ID
2972 -- ,NULL SHIP_FROM_PARTY_TAX_PROF_ID
2973 -- ,NULL BILL_TO_PARTY_TAX_PROF_ID
2974 -- ,NULL BILL_FROM_PARTY_TAX_PROF_ID
2975 -- ,NULL SHIP_TO_SITE_TAX_PROF_ID
2976 -- ,NULL SHIP_FROM_SITE_TAX_PROF_ID
2977 -- ,NULL BILL_TO_SITE_TAX_PROF_ID
2978 -- ,NULL BILL_FROM_SITE_TAX_PROF_ID
2979 -- ,NULL MERCHANT_PARTY_TAX_PROF_ID
2980 -- ,NULL HQ_ESTB_PARTY_TAX_PROF_ID
2981 -- ,NULL CTRL_TOTAL_LINE_TX_AMT
2982 -- ,NULL CTRL_TOTAL_HDR_TX_AMT
2983 -- ,NULL INPUT_TAX_CLASSIFICATION_CODE
2984 -- ,NULL OUTPUT_TAX_CLASSIFICATION_CODE
2985 -- ,NULL INTERNAL_ORG_LOCATION_ID
2986 ,'MIGRATED' RECORD_TYPE_CODE
2987 ,lines.product_fisc_classification -- PRODUCT_FISC_CLASSIFICATION
2988 ,lines.product_category -- PRODUCT_CATEGORY
2989 ,lines.user_defined_fisc_class -- USER_DEFINED_FISC_CLASS
2990 ,lines.assessable_value -- ASSESSABLE_VALUE
2991 ,lines.trx_business_category -- TRX_BUSINESS_CATEGORY
2992 ,inv.supplier_tax_invoice_number -- SUPPLIER_TAX_INVOICE_NUMBER
2993 ,inv.supplier_tax_invoice_date -- SUPPLIER_TAX_INVOICE_DATE
2994 ,inv.supplier_tax_exchange_rate SUPPLIER_EXCHANGE_RATE
2995 ,inv.tax_invoice_recording_date TAX_INVOICE_DATE
2996 ,inv.tax_invoice_internal_seq TAX_INVOICE_NUMBER
2997 ,inv.document_sub_type -- DOCUMENT_SUB_TYPE
2998 ,lines.primary_intended_use LINE_INTENDED_USE
2999 ,inv.port_of_entry_code -- PORT_OF_ENTRY_CODE
3000 -- ,NULL SOURCE_APPLICATION_ID
3001 -- ,NULL SOURCE_ENTITY_CODE
3002 -- ,NULL SOURCE_EVENT_CLASS_CODE
3003 -- ,NULL SOURCE_TRX_ID,
3004 -- ,NULL SOURCE_LINE_ID,
3005 -- ,NULL SOURCE_TRX_LEVEL_TYPE
3006 ,'N' LINE_AMT_INCLUDES_TAX_FLAG
3007 ,'N' CTRL_HDR_TX_APPL_FLAG
3008 ,'Y' TAX_REPORTING_FLAG
3009 ,'N' TAX_AMT_INCLUDED_FLAG
3010 ,'N' COMPOUNDING_TAX_FLAG
3011 ,'N' INCLUSIVE_TAX_OVERRIDE_FLAG
3012 ,'N' THRESHOLD_INDICATOR_FLAG
3013 ,'N' USER_UPD_DET_FACTORS_FLAG
3014 ,'N' TAX_PROCESSING_COMPLETED_FLAG
3015 ,lines.assets_tracking_flag ASSET_FLAG
3016 ,ptp.party_tax_profile_id CONTENT_OWNER_ID
3017 ,inv.exchange_date CURRENCY_CONVERSION_DATE
3018 ,inv.exchange_rate CURRENCY_CONVERSION_RATE
3019 ,inv.exchange_rate_type CURRENCY_CONVERSION_TYPE
3020 ,fnd_curr.minimum_accountable_unit MINIMUM_ACCOUNTABLE_UNIT
3021 ,NVL(fnd_curr.precision,0) PRECISION
3022 ,DECODE(NVL(lines.po_release_id, lines.po_header_id),
3023 NULL, NULL, 201) REF_DOC_APPLICATION_ID
3024 ,DECODE(lines.po_release_id, NULL,
3025 DECODE(lines.po_header_id, NULL, NULL,
3026 'PURCHASE_ORDER'), 'RELEASE') REF_DOC_ENTITY_CODE
3027 ,DECODE(lines.po_release_id, NULL,
3028 DECODE(lines.po_header_id, NULL, NULL,
3029 'PO_PA'), 'RELEASE') REF_DOC_EVENT_CLASS_CODE
3030 ,lines.SUMMARY_TAX_LINE_ID SUMMARY_TAX_LINE_ID
3031 ,lines.TAX TAX
3032 ,DECODE(lines.line_type_lookup_code, 'TAX',
3033 RANK() OVER (PARTITION BY inv.invoice_id,
3034 lines.line_type_lookup_code
3035 ORDER BY lines.line_number), NULL) SUMMARY_TAX_LINE_NUMBER
3036 ,lines.tax_rate -- TAX_RATE
3037 ,lines.tax_rate_code -- TAX_RATE_CODE
3038 ,lines.tax_rate_id -- TAX_RATE_ID
3039 ,lines.tax_regime_code -- TAX_REGIME_CODE
3040 ,lines.tax_status_code -- TAX_STATUS_CODE
3041 ,lines.tax_jurisdiction_code -- TAX_JURISDICTION_CODE
3042 ,'LINE' TRX_LEVEL_TYPE
3043 ,lines.line_number TRX_LINE_ID
3044 ,lines.line_number TRX_LINE_NUMBER
3045 ,lines.default_dist_ccid ACCOUNT_CCID
3046 -- ,NULL ACCOUNT_STRING
3047 ,lines.amount TAX_AMT
3048 ,lines.base_amount TAX_AMT_TAX_CURR
3049 ,lines.base_amount TAX_AMT_FUNCL_CURR
3050 ,lines.attribute_category -- ATTRIBUTE_CATEGORY
3051 ,lines.attribute1 -- ATTRIBUTE1
3052 ,lines.attribute2 -- ATTRIBUTE2
3053 ,lines.attribute3 -- ATTRIBUTE3
3054 ,lines.attribute4 -- ATTRIBUTE4
3055 ,lines.attribute5 -- ATTRIBUTE5
3056 ,lines.attribute6 -- ATTRIBUTE6
3057 ,lines.attribute7 -- ATTRIBUTE7
3058 ,lines.attribute8 -- ATTRIBUTE8
3059 ,lines.attribute9 -- ATTRIBUTE9
3060 ,lines.attribute10 -- ATTRIBUTE10
3061 ,lines.attribute11 -- ATTRIBUTE11
3062 ,lines.attribute12 -- ATTRIBUTE12
3063 ,lines.attribute13 -- ATTRIBUTE13
3064 ,lines.attribute14 -- ATTRIBUTE14
3065 ,lines.attribute15 -- ATTRIBUTE15
3066 ,lines.global_attribute_category -- GLOBAL_ATTRIBUTE_CATEGORY
3067 ,lines.global_attribute1 -- GLOBAL_ATTRIBUTE1
3068 ,lines.global_attribute2 -- GLOBAL_ATTRIBUTE2
3069 ,lines.global_attribute3 -- GLOBAL_ATTRIBUTE3
3070 ,lines.global_attribute4 -- GLOBAL_ATTRIBUTE4
3071 ,lines.global_attribute5 -- GLOBAL_ATTRIBUTE5
3072 ,lines.global_attribute6 -- GLOBAL_ATTRIBUTE6
3073 ,lines.global_attribute7 -- GLOBAL_ATTRIBUTE7
3074 ,lines.global_attribute8 -- GLOBAL_ATTRIBUTE8
3075 ,lines.global_attribute9 -- GLOBAL_ATTRIBUTE9
3076 ,lines.global_attribute10 -- GLOBAL_ATTRIBUTE10
3077 ,lines.global_attribute11 -- GLOBAL_ATTRIBUTE11
3078 ,lines.global_attribute12 -- GLOBAL_ATTRIBUTE12
3079 ,lines.global_attribute13 -- GLOBAL_ATTRIBUTE13
3080 ,lines.global_attribute14 -- GLOBAL_ATTRIBUTE14
3081 ,lines.global_attribute15 -- GLOBAL_ATTRIBUTE15
3082 ,lines.global_attribute16 -- GLOBAL_ATTRIBUTE16
3083 ,lines.global_attribute17 -- GLOBAL_ATTRIBUTE17
3084 ,lines.global_attribute18 -- GLOBAL_ATTRIBUTE18
3085 ,lines.global_attribute19 -- GLOBAL_ATTRIBUTE19
3086 ,lines.global_attribute20 -- GLOBAL_ATTRIBUTE20
3087 ,'Y' HISTORICAL_FLAG
3088 ,'N' OVERRIDDEN_FLAG
3089 ,'N' SELF_ASSESSED_FLAG
3090 ,1 CREATED_BY
3091 ,SYSDATE CREATION_DATE
3092 ,SYSDATE LAST_UPDATE_DATE
3093 ,1 LAST_UPDATE_LOGIN
3094 ,1 LAST_UPDATED_BY
3095 -- ,NULL LAST_MANUAL_ENTRY
3096 ,CASE
3097 WHEN lines.line_type_lookup_code <> 'TAX'
3098 THEN NULL
3099 WHEN NOT EXISTS -- Tax Lines
3100 (SELECT 1
3101 FROM AP_INV_DISTS_TARGET dists
3102 WHERE dists.invoice_id = lines.invoice_id
3103 AND dists.invoice_line_number = lines.line_number
3104 AND dists.charge_applicable_to_dist_id IS NOT NULL
3105 )
3106 THEN 'Y'
3107 ELSE 'N'
3108 END TAX_ONLY_LINE_FLAG
3109 ,lines.total_rec_tax_amount TOTAL_REC_TAX_AMT
3110 ,lines.total_nrec_tax_amount TOTAL_NREC_TAX_AMT
3111 ,lines.total_rec_tax_amt_funcl_curr -- TOTAL_REC_TAX_AMT_FUNCL_CURR,
3112 ,lines.total_nrec_tax_amt_funcl_curr -- TOTAL_NREC_TAX_AMT_FUNCL_CURR,
3113 ,inv.vendor_id SHIP_THIRD_PTY_ACCT_ID
3114 ,inv.vendor_site_id SHIP_THIRD_PTY_ACCT_SITE_ID
3115 ,inv.vendor_id BILL_THIRD_PTY_ACCT_ID
3116 ,inv.vendor_site_id BILL_THIRD_PTY_ACCT_SITE_ID
3117 -- ,NULL ICX_SESSION_ID
3118 -- ,NULL TRX_LINE_CURRENCY_CODE
3119 -- ,NULL TRX_LINE_CURRENCY_CONV_RATE
3120 -- ,NULL TRX_LINE_CURRENCY_CONV_DATE
3121 -- ,NULL TRX_LINE_PRECISION
3122 -- ,NULL TRX_LINE_MAU
3123 -- ,NULL TRX_LINE_CURRENCY_CONV_TYPE
3124 -- ,NULL INTERFACE_ENTITY_CODE
3125 -- ,NULL INTERFACE_LINE_ID
3126 -- ,NULL SOURCE_TAX_LINE_ID
3127 ,DECODE(lines.discarded_flag, 'Y', 'Y', 'N') CANCEL_FLAG
3128 ,DECODE(lines.line_source,'MANUAL LINE ENTRY','Y','N') MANUALLY_ENTERED_FLAG --BUG7146063
3129 ,DECODE(lines.line_source,'MANUAL LINE ENTRY','TAX_AMOUNT',NULL) LAST_MANUAL_ENTRY --BUG7146063
3130 FROM ( select distinct other_doc_application_id,other_doc_trx_id from ZX_VALIDATION_ERRORS_GT ) zxvalerr, --Bug 5187701
3131 ap_invoices_all inv,
3132 fnd_currencies fnd_curr,
3133 fnd_document_sequences fds,
3134 ap_invoice_lines_all lines,
3135 po_line_locations_all poll,
3136 zx_party_tax_profile ptp
3137 WHERE zxvalerr.other_doc_application_id = 200
3138 AND inv.invoice_id = zxvalerr.other_doc_trx_id
3139 AND fnd_curr.currency_code = inv.invoice_currency_code
3140 AND inv.doc_sequence_id = fds.doc_sequence_id(+)
3141 AND lines.invoice_id = inv.invoice_id
3142 AND NVL(lines.historical_flag, 'N') = 'Y'
3143 AND poll.line_location_id(+) = lines.po_line_location_id
3144 AND ptp.party_type_code = 'OU'
3145 AND ptp.party_id = DECODE(l_multi_org_flag,'N',l_org_id,lines.org_id)
3146 );
3147
3148 IF (g_level_statement >= g_current_runtime_level ) THEN
3149 FND_LOG.STRING(g_level_statement,
3150 'ZX.PLSQL.ZX_ON_FLY_TRX_UPGRADE_AP_PKG.upgrade_trx_on_fly_blk_ap',
3151 'Inserting data into zx_lines and zx_rec_nrec_dist');
3152 END IF;
3153
3154 -- Insert data into zx_lines and zx_rec_nrec_dist
3155 --
3156 INSERT ALL
3157 INTO ZX_REC_NREC_DIST(
3158 TAX_LINE_ID
3159 ,REC_NREC_TAX_DIST_ID
3160 ,REC_NREC_TAX_DIST_NUMBER
3161 ,APPLICATION_ID
3162 ,CONTENT_OWNER_ID
3163 ,CURRENCY_CONVERSION_DATE
3164 ,CURRENCY_CONVERSION_RATE
3165 ,CURRENCY_CONVERSION_TYPE
3166 ,ENTITY_CODE
3167 ,EVENT_CLASS_CODE
3168 ,EVENT_TYPE_CODE
3169 ,LEDGER_ID
3170 ,MINIMUM_ACCOUNTABLE_UNIT
3171 ,PRECISION
3172 ,RECORD_TYPE_CODE
3173 ,REF_DOC_APPLICATION_ID
3174 ,REF_DOC_ENTITY_CODE
3175 ,REF_DOC_EVENT_CLASS_CODE
3176 ,REF_DOC_LINE_ID
3177 ,REF_DOC_TRX_ID
3178 ,REF_DOC_TRX_LEVEL_TYPE
3179 ,SUMMARY_TAX_LINE_ID
3180 ,TAX
3181 ,TAX_APPORTIONMENT_LINE_NUMBER
3182 ,TAX_CURRENCY_CODE
3183 ,TAX_CURRENCY_CONVERSION_DATE
3184 ,TAX_CURRENCY_CONVERSION_RATE
3185 ,TAX_CURRENCY_CONVERSION_TYPE
3186 ,TAX_EVENT_CLASS_CODE
3187 ,TAX_EVENT_TYPE_CODE
3188 ,TAX_ID
3189 ,TAX_LINE_NUMBER
3190 ,TAX_RATE
3191 ,TAX_RATE_CODE
3192 ,TAX_RATE_ID
3193 ,TAX_REGIME_CODE
3194 ,TAX_REGIME_ID
3195 ,TAX_STATUS_CODE
3196 ,TAX_STATUS_ID
3197 ,TRX_CURRENCY_CODE
3198 ,TRX_ID
3199 ,TRX_LEVEL_TYPE
3200 ,TRX_LINE_ID
3201 ,TRX_LINE_NUMBER
3202 ,TRX_NUMBER
3203 ,UNIT_PRICE
3204 ,ACCOUNT_CCID
3205 -- ,ACCOUNT_STRING
3206 -- ,ADJUSTED_DOC_TAX_DIST_ID
3207 -- ,APPLIED_FROM_TAX_DIST_ID
3208 -- ,APPLIED_TO_DOC_CURR_CONV_RATE
3209 ,AWARD_ID
3210 ,EXPENDITURE_ITEM_DATE
3211 ,EXPENDITURE_ORGANIZATION_ID
3212 ,EXPENDITURE_TYPE
3213 ,FUNC_CURR_ROUNDING_ADJUSTMENT
3214 ,GL_DATE
3215 ,INTENDED_USE
3216 ,ITEM_DIST_NUMBER
3217 -- ,MRC_LINK_TO_TAX_DIST_ID
3218 -- ,ORIG_REC_NREC_RATE
3219 -- ,ORIG_REC_NREC_TAX_AMT
3220 -- ,ORIG_REC_NREC_TAX_AMT_TAX_CURR
3221 -- ,ORIG_REC_RATE_CODE
3222 -- ,PER_TRX_CURR_UNIT_NR_AMT
3223 -- ,PER_UNIT_NREC_TAX_AMT
3224 -- ,PRD_TAX_AMT
3225 -- ,PRICE_DIFF
3226 ,PROJECT_ID
3227 -- ,QTY_DIFF
3228 -- ,RATE_TAX_FACTOR
3229 ,REC_NREC_RATE
3230 ,REC_NREC_TAX_AMT
3231 ,REC_NREC_TAX_AMT_FUNCL_CURR
3232 ,REC_NREC_TAX_AMT_TAX_CURR
3233 ,RECOVERY_RATE_CODE
3234 ,RECOVERY_TYPE_CODE
3235 -- ,RECOVERY_TYPE_ID
3236 -- ,REF_DOC_CURR_CONV_RATE
3237 ,REF_DOC_DIST_ID
3238 -- ,REF_DOC_PER_UNIT_NREC_TAX_AMT
3239 -- ,REF_DOC_TAX_DIST_ID
3240 -- ,REF_DOC_TRX_LINE_DIST_QTY
3241 -- ,REF_DOC_UNIT_PRICE
3242 -- ,REF_PER_TRX_CURR_UNIT_NR_AMT
3243 ,REVERSED_TAX_DIST_ID
3244 -- ,ROUNDING_RULE_CODE
3245 ,TASK_ID
3246 ,TAXABLE_AMT_FUNCL_CURR
3247 ,TAXABLE_AMT_TAX_CURR
3248 ,TRX_LINE_DIST_AMT
3249 ,TRX_LINE_DIST_ID
3250 ,TRX_LINE_DIST_QTY
3251 ,TRX_LINE_DIST_TAX_AMT
3252 -- ,UNROUNDED_REC_NREC_TAX_AMT
3253 -- ,UNROUNDED_TAXABLE_AMT
3254 ,TAXABLE_AMT
3255 ,ATTRIBUTE_CATEGORY
3256 ,ATTRIBUTE1
3257 ,ATTRIBUTE2
3258 ,ATTRIBUTE3
3259 ,ATTRIBUTE4
3260 ,ATTRIBUTE5
3261 ,ATTRIBUTE6
3262 ,ATTRIBUTE7
3263 ,ATTRIBUTE8
3264 ,ATTRIBUTE9
3265 ,ATTRIBUTE10
3266 ,ATTRIBUTE11
3267 ,ATTRIBUTE12
3268 ,ATTRIBUTE13
3269 ,ATTRIBUTE14
3270 ,ATTRIBUTE15
3271 ,GLOBAL_ATTRIBUTE_CATEGORY
3272 ,GLOBAL_ATTRIBUTE1
3273 ,GLOBAL_ATTRIBUTE2
3274 ,GLOBAL_ATTRIBUTE3
3275 ,GLOBAL_ATTRIBUTE4
3276 ,GLOBAL_ATTRIBUTE5
3277 ,GLOBAL_ATTRIBUTE6
3278 ,GLOBAL_ATTRIBUTE7
3279 ,GLOBAL_ATTRIBUTE8
3280 ,GLOBAL_ATTRIBUTE9
3281 ,GLOBAL_ATTRIBUTE10
3282 ,GLOBAL_ATTRIBUTE11
3283 ,GLOBAL_ATTRIBUTE12
3284 ,GLOBAL_ATTRIBUTE13
3285 ,GLOBAL_ATTRIBUTE14
3286 ,GLOBAL_ATTRIBUTE15
3287 ,GLOBAL_ATTRIBUTE16
3288 ,GLOBAL_ATTRIBUTE17
3289 ,GLOBAL_ATTRIBUTE18
3290 ,GLOBAL_ATTRIBUTE19
3291 ,GLOBAL_ATTRIBUTE20
3292 ,HISTORICAL_FLAG
3293 ,OVERRIDDEN_FLAG
3294 ,SELF_ASSESSED_FLAG
3295 ,TAX_APPORTIONMENT_FLAG
3296 ,TAX_ONLY_LINE_FLAG
3297 ,INCLUSIVE_FLAG
3298 ,MRC_TAX_DIST_FLAG
3299 ,REC_TYPE_RULE_FLAG
3300 ,NEW_REC_RATE_CODE_FLAG
3301 ,RECOVERABLE_FLAG
3302 ,REVERSE_FLAG
3303 ,REC_RATE_DET_RULE_FLAG
3304 ,BACKWARD_COMPATIBILITY_FLAG
3305 ,FREEZE_FLAG
3306 ,POSTING_FLAG
3307 ,LEGAL_ENTITY_ID
3308 ,CREATED_BY
3309 ,CREATION_DATE
3310 ,LAST_MANUAL_ENTRY
3311 ,LAST_UPDATE_DATE
3312 ,LAST_UPDATE_LOGIN
3313 ,LAST_UPDATED_BY
3314 ,OBJECT_VERSION_NUMBER
3315 ,ORIG_AP_CHRG_DIST_NUM
3316 ,ORIG_AP_CHRG_DIST_ID
3317 ,ORIG_AP_TAX_DIST_NUM
3318 ,ORIG_AP_TAX_DIST_ID
3319 ,INTERNAL_ORGANIZATION_ID
3320 ,DEF_REC_SETTLEMENT_OPTION_CODE
3321 --,TAX_JURISDICTION_ID
3322 ,ACCOUNT_SOURCE_TAX_RATE_ID
3323 ,RECOVERY_RATE_ID
3324 )
3325 VALUES(
3326 ZX_LINES_S.NEXTVAL
3327 ,REC_NREC_TAX_DIST_ID
3328 ,REC_NREC_TAX_DIST_NUMBER
3329 ,APPLICATION_ID
3330 ,CONTENT_OWNER_ID
3331 ,CURRENCY_CONVERSION_DATE
3332 ,CURRENCY_CONVERSION_RATE
3333 ,CURRENCY_CONVERSION_TYPE
3334 ,ENTITY_CODE
3335 ,EVENT_CLASS_CODE
3336 ,EVENT_TYPE_CODE
3337 ,AP_LEDGER_ID
3338 ,MINIMUM_ACCOUNTABLE_UNIT
3339 ,PRECISION
3340 ,RECORD_TYPE_CODE
3341 ,REF_DOC_APPLICATION_ID
3342 ,REF_DOC_ENTITY_CODE
3343 ,REF_DOC_EVENT_CLASS_CODE
3344 ,REF_DOC_LINE_ID
3345 ,REF_DOC_TRX_ID
3346 ,REF_DOC_TRX_LEVEL_TYPE
3347 ,SUMMARY_TAX_LINE_ID
3348 ,TAX
3349 ,TAX_APPORTIONMENT_LINE_NUMBER
3350 ,TAX_CURRENCY_CODE
3351 ,TAX_CURRENCY_CONVERSION_DATE
3352 ,TAX_CURRENCY_CONVERSION_RATE
3353 ,TAX_CURRENCY_CONVERSION_TYPE
3354 ,TAX_EVENT_CLASS_CODE
3355 ,TAX_EVENT_TYPE_CODE
3356 ,TAX_ID
3357 ,TAX_LINE_NUMBER
3358 ,TAX_RATE
3359 ,TAX_RATE_CODE
3360 ,TAX_RATE_ID
3361 ,TAX_REGIME_CODE
3362 ,TAX_REGIME_ID
3363 ,TAX_STATUS_CODE
3364 ,TAX_STATUS_ID
3365 ,TRX_CURRENCY_CODE
3366 ,TRX_ID
3367 ,TRX_LEVEL_TYPE
3368 ,TRX_LINE_ID
3369 ,TRX_LINE_NUMBER
3370 ,TRX_NUMBER
3371 ,UNIT_PRICE
3372 ,ACCOUNT_CCID
3373 -- ,ACCOUNT_STRING
3374 -- ,ADJUSTED_DOC_TAX_DIST_ID
3375 -- ,APPLIED_FROM_TAX_DIST_ID
3376 -- ,APPLIED_TO_DOC_CURR_CONV_RATE
3377 ,AWARD_ID
3378 ,EXPENDITURE_ITEM_DATE
3379 ,EXPENDITURE_ORGANIZATION_ID
3380 ,EXPENDITURE_TYPE
3381 ,FUNC_CURR_ROUNDING_ADJUSTMENT
3382 ,GL_DATE
3383 ,INTENDED_USE
3384 ,ITEM_DIST_NUMBER
3385 -- ,MRC_LINK_TO_TAX_DIST_ID
3386 -- ,ORIG_REC_NREC_RATE
3387 -- ,ORIG_REC_NREC_TAX_AMT
3388 -- ,ORIG_REC_NREC_TAX_AMT_TAX_CURR
3389 -- ,ORIG_REC_RATE_CODE
3390 -- ,PER_TRX_CURR_UNIT_NR_AMT
3391 -- ,PER_UNIT_NREC_TAX_AMT
3392 -- ,PRD_TAX_AMT
3393 -- ,PRICE_DIFF
3394 ,PROJECT_ID
3395 -- ,QTY_DIFF
3396 -- ,RATE_TAX_FACTOR
3397 ,REC_NREC_RATE
3398 ,REC_NREC_TAX_AMT
3399 ,REC_NREC_TAX_AMT_FUNCL_CURR
3400 ,REC_NREC_TAX_AMT_TAX_CURR
3401 ,RECOVERY_RATE_CODE
3402 ,RECOVERY_TYPE_CODE
3403 -- ,RECOVERY_TYPE_ID
3404 -- ,REF_DOC_CURR_CONV_RATE
3405 ,REF_DOC_DIST_ID
3406 -- ,REF_DOC_PER_UNIT_NREC_TAX_AMT
3407 -- ,REF_DOC_TAX_DIST_ID
3408 -- ,REF_DOC_TRX_LINE_DIST_QTY
3409 -- ,REF_DOC_UNIT_PRICE
3410 -- ,REF_PER_TRX_CURR_UNIT_NR_AMT
3411 ,REVERSED_TAX_DIST_ID
3412 -- ,ROUNDING_RULE_CODE
3413 ,TASK_ID
3414 ,TAXABLE_AMT_FUNCL_CURR
3415 ,TAXABLE_AMT_TAX_CURR
3416 ,TRX_LINE_DIST_AMT
3417 ,TRX_LINE_DIST_ID
3418 ,TRX_LINE_DIST_QTY
3419 ,TRX_LINE_DIST_TAX_AMT
3420 -- ,UNROUNDED_REC_NREC_TAX_AMT
3421 -- ,UNROUNDED_TAXABLE_AMT
3422 ,TAXABLE_AMT
3423 ,ATTRIBUTE_CATEGORY
3424 ,ATTRIBUTE1
3425 ,ATTRIBUTE2
3426 ,ATTRIBUTE3
3427 ,ATTRIBUTE4
3428 ,ATTRIBUTE5
3429 ,ATTRIBUTE6
3430 ,ATTRIBUTE7
3431 ,ATTRIBUTE8
3432 ,ATTRIBUTE9
3433 ,ATTRIBUTE10
3434 ,ATTRIBUTE11
3435 ,ATTRIBUTE12
3436 ,ATTRIBUTE13
3437 ,ATTRIBUTE14
3438 ,ATTRIBUTE15
3439 ,GLOBAL_ATTRIBUTE_CATEGORY
3440 ,GLOBAL_ATTRIBUTE1
3441 ,GLOBAL_ATTRIBUTE2
3442 ,GLOBAL_ATTRIBUTE3
3443 ,GLOBAL_ATTRIBUTE4
3444 ,GLOBAL_ATTRIBUTE5
3445 ,GLOBAL_ATTRIBUTE6
3446 ,GLOBAL_ATTRIBUTE7
3447 ,GLOBAL_ATTRIBUTE8
3448 ,GLOBAL_ATTRIBUTE9
3449 ,GLOBAL_ATTRIBUTE10
3450 ,GLOBAL_ATTRIBUTE11
3451 ,GLOBAL_ATTRIBUTE12
3452 ,GLOBAL_ATTRIBUTE13
3453 ,GLOBAL_ATTRIBUTE14
3454 ,GLOBAL_ATTRIBUTE15
3455 ,GLOBAL_ATTRIBUTE16
3456 ,GLOBAL_ATTRIBUTE17
3457 ,GLOBAL_ATTRIBUTE18
3458 ,GLOBAL_ATTRIBUTE19
3459 ,GLOBAL_ATTRIBUTE20
3460 ,HISTORICAL_FLAG
3461 ,OVERRIDDEN_FLAG
3462 ,SELF_ASSESSED_FLAG
3463 ,TAX_APPORTIONMENT_FLAG
3464 ,TAX_ONLY_LINE_FLAG
3465 ,INCLUSIVE_FLAG
3466 ,MRC_TAX_DIST_FLAG
3467 ,REC_TYPE_RULE_FLAG
3468 ,NEW_REC_RATE_CODE_FLAG
3469 ,RECOVERABLE_FLAG
3470 ,REVERSE_FLAG
3471 ,REC_RATE_DET_RULE_FLAG
3472 ,BACKWARD_COMPATIBILITY_FLAG
3473 ,FREEZE_FLAG
3474 ,POSTING_FLAG
3475 ,LEGAL_ENTITY_ID
3476 ,CREATED_BY
3477 ,CREATION_DATE
3478 ,LAST_MANUAL_ENTRY
3479 ,LAST_UPDATE_DATE
3480 ,LAST_UPDATE_LOGIN
3481 ,LAST_UPDATED_BY
3482 ,OBJECT_VERSION_NUMBER
3483 ,ORIG_AP_CHRG_DIST_NUM
3484 ,ORIG_AP_CHRG_DIST_ID
3485 ,ORIG_AP_TAX_DIST_NUM
3486 ,ORIG_AP_TAX_DIST_ID
3487 ,INTERNAL_ORGANIZATION_ID
3488 ,DEF_REC_SETTLEMENT_OPTION_CODE
3489 --,TAX_JURISDICTION_ID
3490 ,ACCOUNT_SOURCE_TAX_RATE_ID
3491 ,RECOVERY_RATE_ID
3492 )
3493 INTO ZX_LINES(
3494 TAX_LINE_ID
3495 ,TAX_LINE_NUMBER
3496 ,APPLICATION_ID
3497 ,CONTENT_OWNER_ID
3498 ,CURRENCY_CONVERSION_DATE
3499 ,CURRENCY_CONVERSION_RATE
3500 ,CURRENCY_CONVERSION_TYPE
3501 ,ENTITY_CODE
3502 ,EVENT_CLASS_CODE
3503 ,EVENT_TYPE_CODE
3504 ,LEDGER_ID
3505 ,MINIMUM_ACCOUNTABLE_UNIT
3506 ,PRECISION
3507 ,RECORD_TYPE_CODE
3508 ,REF_DOC_APPLICATION_ID
3509 ,REF_DOC_ENTITY_CODE
3510 ,REF_DOC_EVENT_CLASS_CODE
3511 ,REF_DOC_LINE_ID
3512 ,REF_DOC_TRX_ID
3513 ,REF_DOC_TRX_LEVEL_TYPE
3514 ,SUMMARY_TAX_LINE_ID
3515 ,TAX
3516 ,TAX_APPORTIONMENT_LINE_NUMBER
3517 ,TAX_CURRENCY_CODE
3518 ,TAX_CURRENCY_CONVERSION_DATE
3519 ,TAX_CURRENCY_CONVERSION_RATE
3520 ,TAX_CURRENCY_CONVERSION_TYPE
3521 ,TAX_EVENT_CLASS_CODE
3522 ,TAX_EVENT_TYPE_CODE
3523 ,TAX_ID
3524 ,TAX_RATE
3525 ,TAX_RATE_CODE
3526 ,TAX_RATE_ID
3527 ,TAX_REGIME_CODE
3528 ,TAX_REGIME_ID
3529 ,TAX_STATUS_CODE
3530 ,TAX_STATUS_ID
3531 ,TRX_CURRENCY_CODE
3532 ,TRX_ID
3533 ,TRX_LEVEL_TYPE
3534 ,TRX_LINE_ID
3535 ,TRX_LINE_NUMBER
3536 ,TRX_NUMBER
3537 ,UNIT_PRICE
3538 ,TAX_RATE_TYPE
3539 ,ADJUSTED_DOC_APPLICATION_ID
3540 -- ,ADJUSTED_DOC_DATE
3541 ,ADJUSTED_DOC_ENTITY_CODE
3542 ,ADJUSTED_DOC_EVENT_CLASS_CODE
3543 ,ADJUSTED_DOC_LINE_ID
3544 -- ,ADJUSTED_DOC_NUMBER
3545 ,ADJUSTED_DOC_TRX_ID
3546 ,ADJUSTED_DOC_TRX_LEVEL_TYPE
3547 ,APPLIED_FROM_APPLICATION_ID
3548 ,APPLIED_FROM_ENTITY_CODE
3549 ,APPLIED_FROM_EVENT_CLASS_CODE
3550 ,APPLIED_FROM_LINE_ID
3551 -- ,APPLIED_FROM_TRX_NUMBER
3552 ,APPLIED_FROM_TRX_ID
3553 ,APPLIED_FROM_TRX_LEVEL_TYPE
3554 ,APPLIED_TO_APPLICATION_ID
3555 ,APPLIED_TO_ENTITY_CODE
3556 ,APPLIED_TO_EVENT_CLASS_CODE
3557 ,APPLIED_TO_LINE_ID
3558 ,APPLIED_TO_TRX_ID
3559 ,APPLIED_TO_TRX_LEVEL_TYPE
3560 -- ,APPLIED_TO_TRX_NUMBER
3561 -- ,CAL_TAX_AMT
3562 -- ,CAL_TAX_AMT_FUNCL_CURR
3563 -- ,CAL_TAX_AMT_TAX_CURR
3564 -- ,DOC_EVENT_STATUS
3565 -- ,INTERNAL_ORG_LOCATION_ID
3566 ,INTERNAL_ORGANIZATION_ID
3567 ,LINE_AMT
3568 ,LINE_ASSESSABLE_VALUE
3569 -- ,MRC_LINK_TO_TAX_LINE_ID
3570 ,NREC_TAX_AMT
3571 ,NREC_TAX_AMT_FUNCL_CURR
3572 ,NREC_TAX_AMT_TAX_CURR
3573 -- ,OFFSET_LINK_TO_TAX_LINE_ID
3574 -- ,OFFSET_TAX_RATE_CODE
3575 -- ,ORIG_TAX_AMT
3576 -- ,ORIG_TAX_AMT_TAX_CURR
3577 -- ,ORIG_TAX_RATE
3578 -- ,ORIG_TAX_RATE_CODE
3579 -- ,ORIG_TAX_RATE_ID
3580 -- ,ORIG_TAX_STATUS_CODE
3581 -- ,ORIG_TAX_STATUS_ID
3582 -- ,ORIG_TAXABLE_AMT
3583 -- ,ORIG_TAXABLE_AMT_TAX_CURR
3584 -- ,OTHER_DOC_LINE_AMT
3585 -- ,OTHER_DOC_LINE_TAX_AMT
3586 -- ,OTHER_DOC_LINE_TAXABLE_AMT
3587 -- ,OTHER_DOC_SOURCE
3588 -- ,PRORATION_CODE
3589 ,REC_TAX_AMT
3590 ,REC_TAX_AMT_FUNCL_CURR
3591 ,REC_TAX_AMT_TAX_CURR
3592 -- ,REF_DOC_LINE_QUANTITY
3593 -- ,RELATED_DOC_APPLICATION_ID
3594 -- ,RELATED_DOC_DATE
3595 -- ,RELATED_DOC_ENTITY_CODE
3596 -- ,RELATED_DOC_EVENT_CLASS_CODE
3597 -- ,RELATED_DOC_NUMBER
3598 -- ,RELATED_DOC_TRX_ID
3599 -- ,RELATED_DOC_TRX_LEVEL_TYPE
3600 -- ,REPORTING_CURRENCY_CODE
3601 ,TAX_AMT
3602 ,TAX_AMT_FUNCL_CURR
3603 ,TAX_AMT_TAX_CURR
3604 ,TAX_CALCULATION_FORMULA
3605 -- ,TAX_CODE
3606 ,TAX_DATE
3607 ,TAX_DETERMINE_DATE
3608 ,TAX_POINT_DATE
3609 -- ,TAX_TYPE_CODE
3610 -- ,ROUNDING_RULE_CODE
3611 ,TAXABLE_AMT
3612 ,TAXABLE_AMT_FUNCL_CURR
3613 ,TAXABLE_AMT_TAX_CURR
3614 ,TAXABLE_BASIS_FORMULA
3615 ,TRX_DATE
3616 ,TRX_LINE_DATE
3617 ,TRX_LINE_QUANTITY
3618 -- ,UNROUNDED_TAX_AMT
3619 -- ,UNROUNDED_TAXABLE_AMT
3620 ,HISTORICAL_FLAG
3621 ,OVERRIDDEN_FLAG
3622 ,SELF_ASSESSED_FLAG
3623 ,TAX_APPORTIONMENT_FLAG
3624 ,TAX_ONLY_LINE_FLAG
3625 ,TAX_AMT_INCLUDED_FLAG
3626 ,MRC_TAX_LINE_FLAG
3627 ,OFFSET_FLAG
3628 ,PROCESS_FOR_RECOVERY_FLAG
3629 ,COMPOUNDING_TAX_FLAG
3630 ,ORIG_TAX_AMT_INCLUDED_FLAG
3631 ,ORIG_SELF_ASSESSED_FLAG
3632 ,CANCEL_FLAG
3633 ,PURGE_FLAG
3634 ,DELETE_FLAG
3635 ,MANUALLY_ENTERED_FLAG
3636 --,LAST_MANUAL_ENTRY --BUG7146063
3637 ,REPORTING_ONLY_FLAG
3638 ,FREEZE_UNTIL_OVERRIDDEN_FLAG
3639 ,COPIED_FROM_OTHER_DOC_FLAG
3640 ,RECALC_REQUIRED_FLAG
3641 ,SETTLEMENT_FLAG
3642 ,ITEM_DIST_CHANGED_FLAG
3643 ,ASSOCIATED_CHILD_FROZEN_FLAG
3644 ,COMPOUNDING_DEP_TAX_FLAG
3645 ,ENFORCE_FROM_NATURAL_ACCT_FLAG
3646 ,ATTRIBUTE_CATEGORY
3647 ,ATTRIBUTE1
3648 ,ATTRIBUTE2
3649 ,ATTRIBUTE3
3650 ,ATTRIBUTE4
3651 ,ATTRIBUTE5
3652 ,ATTRIBUTE6
3653 ,ATTRIBUTE7
3654 ,ATTRIBUTE8
3655 ,ATTRIBUTE9
3656 ,ATTRIBUTE10
3657 ,ATTRIBUTE11
3658 ,ATTRIBUTE12
3659 ,ATTRIBUTE13
3660 ,ATTRIBUTE14
3661 ,ATTRIBUTE15
3662 ,GLOBAL_ATTRIBUTE_CATEGORY
3663 ,GLOBAL_ATTRIBUTE1
3664 ,GLOBAL_ATTRIBUTE2
3665 ,GLOBAL_ATTRIBUTE3
3666 ,GLOBAL_ATTRIBUTE4
3667 ,GLOBAL_ATTRIBUTE5
3668 ,GLOBAL_ATTRIBUTE6
3669 ,GLOBAL_ATTRIBUTE7
3670 ,GLOBAL_ATTRIBUTE8
3671 ,GLOBAL_ATTRIBUTE9
3672 ,GLOBAL_ATTRIBUTE10
3673 ,GLOBAL_ATTRIBUTE11
3674 ,GLOBAL_ATTRIBUTE12
3675 ,GLOBAL_ATTRIBUTE13
3676 ,GLOBAL_ATTRIBUTE14
3677 ,GLOBAL_ATTRIBUTE15
3678 ,LAST_MANUAL_ENTRY
3679 ,LEGAL_ENTITY_ID
3680 -- ,ESTABLISHMENT_ID
3681 ,CREATED_BY
3682 ,CREATION_DATE
3683 ,LAST_UPDATE_DATE
3684 ,LAST_UPDATE_LOGIN
3685 ,LAST_UPDATED_BY
3686 ,OBJECT_VERSION_NUMBER
3687 ,MULTIPLE_JURISDICTIONS_FLAG
3688 ,LEGAL_REPORTING_STATUS
3689 ,ACCOUNT_SOURCE_TAX_RATE_ID
3690 )
3691 VALUES (
3692 ZX_LINES_S.NEXTVAL
3693 ,TAX_LINE_NUMBER
3694 ,APPLICATION_ID
3695 ,CONTENT_OWNER_ID
3696 ,CURRENCY_CONVERSION_DATE
3697 ,CURRENCY_CONVERSION_RATE
3698 ,CURRENCY_CONVERSION_TYPE
3699 ,ENTITY_CODE
3700 ,EVENT_CLASS_CODE
3701 ,EVENT_TYPE_CODE
3702 ,AP_LEDGER_ID
3703 ,MINIMUM_ACCOUNTABLE_UNIT
3704 ,PRECISION
3705 ,RECORD_TYPE_CODE
3706 ,REF_DOC_APPLICATION_ID
3707 ,REF_DOC_ENTITY_CODE
3708 ,REF_DOC_EVENT_CLASS_CODE
3709 ,REF_DOC_LINE_ID
3710 ,REF_DOC_TRX_ID
3711 ,REF_DOC_TRX_LEVEL_TYPE
3712 ,SUMMARY_TAX_LINE_ID
3713 ,TAX
3714 ,TAX_APPORTIONMENT_LINE_NUMBER
3715 ,TAX_CURRENCY_CODE
3716 ,TAX_CURRENCY_CONVERSION_DATE
3717 ,TAX_CURRENCY_CONVERSION_RATE
3718 ,TAX_CURRENCY_CONVERSION_TYPE
3719 ,TAX_EVENT_CLASS_CODE
3720 ,TAX_EVENT_TYPE_CODE
3721 ,TAX_ID
3722 ,TAX_RATE
3723 ,TAX_RATE_CODE
3724 ,TAX_RATE_ID
3725 ,TAX_REGIME_CODE
3726 ,TAX_REGIME_ID
3727 ,TAX_STATUS_CODE
3728 ,TAX_STATUS_ID
3729 ,TRX_CURRENCY_CODE
3730 ,TRX_ID
3731 ,TRX_LEVEL_TYPE
3732 ,TRX_LINE_ID
3733 ,TRX_LINE_NUMBER
3734 ,TRX_NUMBER
3735 ,UNIT_PRICE
3736 ,NULL
3737 ,ADJUSTED_DOC_APPLICATION_ID
3738 -- ,ADJUSTED_DOC_DATE
3739 ,ADJUSTED_DOC_ENTITY_CODE
3740 ,ADJUSTED_DOC_EVENT_CLASS_CODE
3741 ,ADJUSTED_DOC_LINE_ID
3742 -- ,ADJUSTED_DOC_NUMBER
3743 ,ADJUSTED_DOC_TRX_ID
3744 ,ADJUSTED_DOC_TRX_LEVEL_TYPE
3745 ,APPLIED_FROM_APPLICATION_ID
3746 ,APPLIED_FROM_ENTITY_CODE
3747 ,APPLIED_FROM_EVENT_CLASS_CODE
3748 ,APPLIED_FROM_LINE_ID
3749 -- ,APPLIED_FROM_TRX_NUMBER
3750 ,APPLIED_FROM_TRX_ID
3751 ,APPLIED_FROM_TRX_LEVEL_TYPE
3752 ,APPLIED_TO_APPLICATION_ID
3753 ,APPLIED_TO_ENTITY_CODE
3754 ,APPLIED_TO_EVENT_CLASS_CODE
3755 ,APPLIED_TO_LINE_ID
3756 ,APPLIED_TO_TRX_ID
3757 ,APPLIED_TO_TRX_LEVEL_TYPE
3758 -- ,APPLIED_TO_TRX_NUMBER
3759 -- ,NULL -- CAL_TAX_AMT
3760 -- ,NULL -- CAL_TAX_AMT_FUNCL_CURR
3761 -- ,NULL -- CAL_TAX_AMT_TAX_CURR
3762 -- ,DOC_EVENT_STATUS
3763 -- ,INTERNAL_ORG_LOCATION_ID
3764 ,INTERNAL_ORGANIZATION_ID
3765 ,LINE_AMT
3766 ,ASSESSABLE_VALUE
3767 -- ,NULL -- MRC_LINK_TO_TAX_LINE_ID
3768 ,DECODE(AP_DIST_LOOKUP_CODE,
3769 'NONREC_TAX', REC_NREC_TAX_AMT, NULL) -- NREC_TAX_AMT
3770 ,DECODE(AP_DIST_LOOKUP_CODE,
3771 'NONREC_TAX', REC_NREC_TAX_AMT_FUNCL_CURR, NULL) -- NREC_TAX_AMT_FUNCL_CURR
3772 ,DECODE(AP_DIST_LOOKUP_CODE,
3773 'NONREC_TAX', REC_NREC_TAX_AMT_TAX_CURR, NULL) -- NREC_TAX_AMT_TAX_CURR
3774 -- ,NULL -- OFFSET_LINK_TO_TAX_LINE_ID
3775 -- ,NULL -- OFFSET_TAX_RATE_CODE
3776 -- ,NULL -- ORIG_TAX_AMT
3777 -- ,NULL -- ORIG_TAX_AMT_TAX_CURR
3778 -- ,NULL -- ORIG_TAX_RATE
3779 -- ,NULL -- ORIG_TAX_RATE_CODE
3780 -- ,NULL -- ORIG_TAX_RATE_ID
3781 -- ,NULL -- ORIG_TAX_STATUS_CODE
3782 -- ,NULL -- ORIG_TAX_STATUS_ID
3783 -- ,NULL -- ORIG_TAXABLE_AMT
3784 -- ,NULL -- ORIG_TAXABLE_AMT_TAX_CURR
3785 -- ,NULL -- OTHER_DOC_LINE_AMT
3786 -- ,NULL -- OTHER_DOC_LINE_TAX_AMT
3787 -- ,NULL -- OTHER_DOC_LINE_TAXABLE_AMT
3788 -- ,NULL -- OTHER_DOC_SOURCE
3789 -- ,NULL -- PRORATION_CODE
3790 ,DECODE(AP_DIST_LOOKUP_CODE,
3791 'REC_TAX', REC_NREC_TAX_AMT, NULL) -- REC_TAX_AMT
3792 ,DECODE(AP_DIST_LOOKUP_CODE,
3793 'REC_TAX', REC_NREC_TAX_AMT_FUNCL_CURR, NULL) -- REC_TAX_AMT_FUNCL_CURR
3794 ,DECODE(AP_DIST_LOOKUP_CODE,
3795 'REC_TAX', REC_NREC_TAX_AMT_TAX_CURR, NULL) -- REC_TAX_AMT_TAX_CURR
3796 -- ,REF_DOC_LINE_QUANTITY
3797 -- ,RELATED_DOC_APPLICATION_ID
3798 -- ,RELATED_DOC_DATE
3799 -- ,RELATED_DOC_ENTITY_CODE
3800 -- ,RELATED_DOC_EVENT_CLASS_CODE
3801 -- ,RELATED_DOC_NUMBER
3802 -- ,RELATED_DOC_TRX_ID
3803 -- ,RELATED_DOC_TRX_LEVEL_TYPE
3804 -- ,NULL -- REPORTING_CURRENCY_CODE
3805 ,TAX_AMT
3806 ,TAX_AMT_FUNCL_CURR
3807 ,TAX_AMT_TAX_CURR
3808 ,'STANDARD_TC'
3809 -- ,NULL -- TAX_CODE
3810 ,TAX_DATE
3811 ,TAX_DETERMINE_DATE
3812 ,TAX_POINT_DATE
3813 -- ,NULL -- TAX_TYPE_CODE
3814 -- ,ROUNDING_RULE_CODE
3815 ,TAXABLE_AMT
3816 ,TAXABLE_AMT_FUNCL_CURR
3817 ,TAXABLE_AMT_TAX_CURR
3818 ,'STANDARD_TB' -- TAXABLE_BASIS_FORMULA
3819 ,TRX_DATE
3820 ,TRX_LINE_DATE
3821 ,TRX_LINE_QUANTITY
3822 -- ,NULL -- UNROUNDED_TAX_AMT
3823 -- ,NULL -- UNROUNDED_TAXABLE_AMT
3824 ,HISTORICAL_FLAG
3825 ,OVERRIDDEN_FLAG
3826 ,SELF_ASSESSED_FLAG
3827 ,TAX_APPORTIONMENT_FLAG
3828 ,TAX_ONLY_LINE_FLAG
3829 ,TAX_AMT_INCLUDED_FLAG
3830 ,'N' -- MRC_TAX_LINE_FLAG
3831 ,'N' -- OFFSET_FLAG
3832 ,'N' -- PROCESS_FOR_RECOVERY_FLAG
3833 ,COMPOUNDING_TAX_FLAG
3834 ,'N' -- ORIG_TAX_AMT_INCLUDED_FLAG
3835 ,'N' -- ORIG_SELF_ASSESSED_FLAG
3836 ,CANCEL_FLAG
3837 ,'N' -- PURGE_FLAG
3838 ,'N' -- DELETE_FLAG
3839 ,MANUALLY_ENTERED_FLAG
3840 --,LAST_MANUAL_ENTRY --BUG7146063
3841 ,'N' -- REPORTING_ONLY_FLAG
3842 ,'N' -- FREEZE_UNTIL_OVERRIDDEN_FLAG
3843 ,'N' -- COPIED_FROM_OTHER_DOC_FLAG
3844 ,'N' -- RECALC_REQUIRED_FLAG
3845 ,'N' -- SETTLEMENT_FLAG
3846 ,'N' -- ITEM_DIST_CHANGED_FLAG
3847 ,'N' -- ASSOCIATED_CHILD_FROZEN_FLAG
3848 ,'N' -- COMPOUNDING_DEP_TAX_FLAG
3849 ,'N' -- ENFORCE_FROM_NATURAL_ACCT_FLAG
3850 ,ATTRIBUTE_CATEGORY
3851 ,ATTRIBUTE1
3852 ,ATTRIBUTE2
3853 ,ATTRIBUTE3
3854 ,ATTRIBUTE4
3855 ,ATTRIBUTE5
3856 ,ATTRIBUTE6
3857 ,ATTRIBUTE7
3858 ,ATTRIBUTE8
3859 ,ATTRIBUTE9
3860 ,ATTRIBUTE10
3861 ,ATTRIBUTE11
3862 ,ATTRIBUTE12
3863 ,ATTRIBUTE13
3864 ,ATTRIBUTE14
3865 ,ATTRIBUTE15
3866 ,GLOBAL_ATTRIBUTE_CATEGORY
3867 ,GLOBAL_ATTRIBUTE1
3868 ,GLOBAL_ATTRIBUTE2
3869 ,GLOBAL_ATTRIBUTE3
3870 ,GLOBAL_ATTRIBUTE4
3871 ,GLOBAL_ATTRIBUTE5
3872 ,GLOBAL_ATTRIBUTE6
3873 ,GLOBAL_ATTRIBUTE7
3874 ,GLOBAL_ATTRIBUTE8
3875 ,GLOBAL_ATTRIBUTE9
3876 ,GLOBAL_ATTRIBUTE10
3877 ,GLOBAL_ATTRIBUTE11
3878 ,GLOBAL_ATTRIBUTE12
3879 ,GLOBAL_ATTRIBUTE13
3880 ,GLOBAL_ATTRIBUTE14
3881 ,GLOBAL_ATTRIBUTE15
3882 ,LAST_MANUAL_ENTRY
3883 ,LEGAL_ENTITY_ID
3884 -- ,ESTABLISHMENT_ID
3885 ,CREATED_BY
3886 ,CREATION_DATE
3887 ,LAST_UPDATE_DATE
3888 ,LAST_UPDATE_LOGIN
3889 ,LAST_UPDATED_BY
3890 ,OBJECT_VERSION_NUMBER
3891 ,MULTIPLE_JURISDICTIONS_FLAG
3892 ,LEGAL_REPORTING_STATUS
3893 ,ACCOUNT_SOURCE_TAX_RATE_ID
3894 )
3895 (SELECT /*+ ROWID(inv) NO_EXPAND ORDERED
3896 use_nl(fnd_curr,ap_dists,ap_dists1,lines1,rates,regimes,taxes,status,ptp)
3897 index(taxes,ZX_TAXES_B_U2) */
3898 NVL(lines1.org_id,-99) INTERNAL_ORGANIZATION_ID
3899 ,200 APPLICATION_ID
3900 ,'AP_INVOICES' ENTITY_CODE
3901 ,DECODE(inv.INVOICE_TYPE_LOOKUP_CODE ,
3902 'STANDARD', 'STANDARD INVOICES' ,
3903 'CREDIT' , 'STANDARD INVOICES', --Bug 6489409
3904 'DEBIT' , 'STANDARD INVOICES', --Bug 6489409
3905 'MIXED' , 'STANDARD INVOICES', --Bug 6489409
3906 'ADJUSTMENT','STANDARD INVOICES', --Bug 6489409
3907 'PO PRICE ADJUST','STANDARD INVOICES', --Bug 6489409
3908 'INVOICE REQUEST','STANDARD INVOICES', --Bug 6489409
3909 'CREDIT MEMO REQUEST','STANDARD INVOICES',--Bug 6489409
3910 'RETAINAGE RELEASE' ,'STANDARD INVOICES',--Bug 6489409
3911 'PREPAYMENT','PREPAYMENT INVOICES' ,
3912 'EXPENSE REPORT','EXPENSE REPORTS' ,
3913 'INTEREST INVOICE','INTEREST INVOICES','NA') EVENT_CLASS_CODE
3914 ,DECODE(inv.INVOICE_TYPE_LOOKUP_CODE,
3915 'STANDARD','STANDARD INVOICE CREATED',
3916 'PREPAYMENT','PREPAYMENT INVOICE CREATED',
3917 'EXPENSE REPORT','EXPENSE REPORT CREATED',
3918 'INTEREST INVOICE','INTEREST INVOICE CREATED','NA') EVENT_TYPE_CODE
3919 ,(CASE WHEN inv.invoice_type_lookup_code in
3920 ('ADJUSTMENT','CREDIT','DEBIT','INTEREST',
3921 'MIXED','QUICKDEFAULT','PO PRICE ADJUST',
3922 'QUICKMATCH','STANDARD','AWT')
3923 THEN 'PURCHASE_TRANSACTION'
3924 WHEN (inv.invoice_type_lookup_code =
3925 'PREPAYMENT')
3926 THEN 'PURCHASE_PREPAYMENTTRANSACTION'
3927 WHEN (inv.invoice_type_lookup_code =
3928 'EXPENSE REPORT')
3929 THEN 'EXPENSE_REPORT'
3930 ELSE NULL
3931 END) TAX_EVENT_CLASS_CODE
3932 ,'VALIDATE' TAX_EVENT_TYPE_CODE
3933 -- ,NULL DOC_EVENT_STATUS
3934 ,lines1.invoice_id TRX_ID
3935 ,NVL(inv.invoice_date,sysdate) TRX_DATE
3936 ,inv.invoice_currency_code TRX_CURRENCY_CODE
3937 ,NVL(inv.legal_entity_id, -99) LEGAL_ENTITY_ID
3938 -- ,NULL ESTABLISHMENT_ID
3939 ,inv.invoice_num TRX_NUMBER
3940 -- ,DECODE(ap_dists.charge_applicable_to_dist_id,NULL,1,
3941 ,(RANK() OVER (PARTITION BY inv.invoice_id ORDER BY
3942 ap_dists1.invoice_line_number,
3943 ap_dists.invoice_distribution_id)) TAX_LINE_NUMBER
3944 ,lines1.accounting_date TRX_LINE_DATE
3945 ,NVL(lines1.amount,0) LINE_AMT
3946 ,NVL(lines1.quantity_invoiced, 0) TRX_LINE_QUANTITY
3947 ,lines1.UNIT_PRICE UNIT_PRICE
3948 -- ,NULL RELATED_DOC_APPLICATION_ID
3949 -- ,NULL RELATED_DOC_ENTITY_CODE
3950 -- ,NULL RELATED_DOC_EVENT_CLASS_CODE
3951 -- ,NULL RELATED_DOC_TRX_ID
3952 -- ,NULL RELATED_DOC_TRX_LEVEL_TYPE
3953 -- ,NULL RELATED_DOC_NUMBER
3954 -- ,NULL RELATED_DOC_DATE
3955 ,DECODE(lines1.prepay_invoice_id, NULL, NULL, 200) APPLIED_FROM_APPLICATION_ID
3956 ,DECODE(lines1.prepay_invoice_id, NULL, NULL,
3957 'AP_INVOICES') APPLIED_FROM_ENTITY_CODE
3958 ,DECODE(lines1.prepay_invoice_id, NULL, NULL,
3959 'PREPAYMENT INVOICES') APPLIED_FROM_EVENT_CLASS_CODE
3960 ,lines1.prepay_invoice_id APPLIED_FROM_TRX_ID
3961 ,lines1.prepay_line_number APPLIED_FROM_LINE_ID
3962 -- ,NULL APPLIED_FROM_TRX_NUMBER
3963 ,DECODE(lines1.corrected_inv_id, NULL, NULL, 200) ADJUSTED_DOC_APPLICATION_ID
3964 ,DECODE(lines1.corrected_inv_id, NULL, NULL,
3965 'AP_INVOICES') ADJUSTED_DOC_ENTITY_CODE
3966 ,DECODE(lines1.corrected_inv_id, NULL, NULL,
3967 'STANDARD INVOICES') ADJUSTED_DOC_EVENT_CLASS_CODE
3968 ,lines1.corrected_inv_id ADJUSTED_DOC_TRX_ID
3969 ,lines1.Corrected_Line_Number ADJUSTED_DOC_LINE_ID
3970 -- ,NULL ADJUSTED_DOC_NUMBER
3971 -- ,NULL ADJUSTED_DOC_DATE
3972 ,DECODE(lines1.rcv_transaction_id, NULL, NULL, 707) APPLIED_TO_APPLICATION_ID
3973 ,DECODE(lines1.rcv_transaction_id, NULL, NULL,
3974 'RCV_ACCOUNTING_EVENTS') APPLIED_TO_ENTITY_CODE
3975 ,DECODE(lines1.rcv_transaction_id, NULL, NULL,
3976 'RCPT_REC_INSP') APPLIED_TO_EVENT_CLASS_CODE
3977 ,lines1.rcv_transaction_id APPLIED_TO_TRX_ID
3978 ,lines1.rcv_shipment_line_id APPLIED_TO_LINE_ID
3979 -- ,NULL APPLIED_TO_TRX_NUMBER
3980 ,DECODE(NVL(lines1.po_release_id,lines1.po_header_id),
3981 NULL, NULL, 'SHIPMENT') REF_DOC_TRX_LEVEL_TYPE
3982 ,NVL(lines1.po_release_id, lines1.po_header_id) REF_DOC_TRX_ID
3983 ,lines1.po_line_location_id REF_DOC_LINE_ID
3984 -- ,NULL REF_DOC_LINE_QUANTITY
3985 ,DECODE(lines1.rcv_transaction_id, NULL, NULL,
3986 'LINE') APPLIED_TO_TRX_LEVEL_TYPE
3987 ,DECODE(lines1.prepay_invoice_id, NULL, NULL,
3988 'LINE') APPLIED_FROM_TRX_LEVEL_TYPE
3989 ,DECODE(lines1.corrected_inv_id, NULL, NULL,
3990 'LINE') ADJUSTED_DOC_TRX_LEVEL_TYPE
3991 -- ,NULL INTERNAL_ORG_LOCATION_ID
3992 ,'MIGRATED' RECORD_TYPE_CODE
3993 ,lines1.ASSESSABLE_VALUE -- ASSESSABLE_VALUE
3994 ,'N' TAX_AMT_INCLUDED_FLAG
3995 ,'N' COMPOUNDING_TAX_FLAG
3996 ,ap_dists.DETAIL_TAX_DIST_ID REC_NREC_TAX_DIST_ID
3997 ,ap_dists.line_type_lookup_code AP_DIST_LOOKUP_CODE
3998 -- DECODE(ap_dists.charge_applicable_to_dist_id, NULL, 1,
3999 ,RANK() OVER (PARTITION BY inv.invoice_id,
4000 ap_dists.charge_applicable_to_dist_id
4001 ORDER BY
4002 ap_dists.line_type_lookup_code desc,
4003 ap_dists.invoice_distribution_id) REC_NREC_TAX_DIST_NUMBER
4004 ,ptp.party_tax_profile_id CONTENT_OWNER_ID
4005 ,ap_dists.exchange_date CURRENCY_CONVERSION_DATE
4006 ,ap_dists.exchange_rate CURRENCY_CONVERSION_RATE
4007 ,ap_dists.exchange_rate_type CURRENCY_CONVERSION_TYPE
4008 ,ap_dists.set_of_books_id AP_LEDGER_ID
4009 ,fnd_curr.minimum_accountable_unit MINIMUM_ACCOUNTABLE_UNIT
4010 ,NVL(fnd_curr.precision, 0) PRECISION
4011 ,DECODE(NVL(lines1.po_release_id, lines1.po_header_id),
4012 NULL, NULL, 201) REF_DOC_APPLICATION_ID
4013 ,DECODE(lines1.po_release_id, NULL,
4014 DECODE(lines1.po_header_id, NULL, NULL,
4015 'PURCHASE_ORDER'), 'RELEASE') REF_DOC_ENTITY_CODE
4016 ,DECODE(lines1.po_release_id, NULL,
4017 DECODE(lines1.po_header_id, NULL, NULL,
4018 'PO_PA'), 'RELEASE') REF_DOC_EVENT_CLASS_CODE
4019 ,ap_dists.summary_tax_line_id SUMMARY_TAX_LINE_ID
4020 ,rates.TAX TAX
4021 -- ,DECODE(ap_dists.charge_applicable_to_dist_id,NULL,1,
4022 ,RANK() OVER (PARTITION BY inv.invoice_id,
4023 ap_dists1.invoice_line_number,
4024 rates.tax_regime_code, rates.tax
4025 ORDER BY
4026 ap_dists.invoice_distribution_id) TAX_APPORTIONMENT_LINE_NUMBER
4027 ,taxes.tax_currency_code -- TAX_CURRENCY_CODE
4028 ,ap_dists.exchange_date TAX_CURRENCY_CONVERSION_DATE
4029 ,ap_dists.exchange_rate TAX_CURRENCY_CONVERSION_RATE
4030 ,ap_dists.exchange_rate_type TAX_CURRENCY_CONVERSION_TYPE
4031 ,taxes.tax_id -- TAX_ID
4032 ,rates.percentage_rate TAX_RATE
4033 ,rates.tax_rate_code -- TAX_RATE_CODE
4034 ,rates.tax_rate_id -- TAX_RATE_ID
4035 ,rates.tax_regime_code -- TAX_REGIME_CODE
4036 ,regimes.tax_regime_id -- TAX_REGIME_ID
4037 ,rates.tax_status_code -- TAX_STATUS_CODE
4038 ,status.tax_status_id -- TAX_STATUS_ID
4039 ,'LINE' TRX_LEVEL_TYPE
4040 ,lines1.line_number TRX_LINE_ID
4041 ,lines1.line_number TRX_LINE_NUMBER
4042 ,ap_dists.dist_code_combination_id ACCOUNT_CCID
4043 -- ,NULL ACCOUNT_STRING
4044 -- ,NULL ADJUSTED_DOC_TAX_DIST_ID
4045 -- ,NULL APPLIED_FROM_TAX_DIST_ID
4046 -- ,NULL APPLIED_TO_DOC_CURR_CONV_RATE
4047 ,ap_dists.award_id -- AWARD_ID
4048 ,ap_dists.expenditure_item_date -- EXPENDITURE_ITEM_DATE
4049 ,ap_dists.expenditure_organization_id -- EXPENDITURE_ORGANIZATION_ID
4050 ,ap_dists.expenditure_type -- EXPENDITURE_TYPE
4051 ,NULL FUNC_CURR_ROUNDING_ADJUSTMENT
4052 ,ap_dists.ACCOUNTING_DATE GL_DATE
4053 ,ap_dists.intended_use -- INTENDED_USE
4054 ,ap_dists1.distribution_line_number ITEM_DIST_NUMBER
4055 -- ,NULL MRC_LINK_TO_TAX_DIST_ID
4056 -- ,NULL ORIG_REC_NREC_RATE
4057 -- ,NULL ORIG_REC_NREC_TAX_AMT
4058 -- ,NULL ORIG_REC_NREC_TAX_AMT_TAX_CURR
4059 -- ,NULL ORIG_REC_RATE_CODE
4060 -- ,NULL PER_TRX_CURR_UNIT_NR_AMT
4061 -- ,NULL PER_UNIT_NREC_TAX_AMT
4062 -- ,NULL PRD_TAX_AMT
4063 -- ,NULL PRICE_DIFF
4064 ,ap_dists.project_id -- PROJECT_ID
4065 -- ,NULL QTY_DIFF
4066 -- ,NULL RATE_TAX_FACTOR
4067 --,NVL(ap_dists.rec_nrec_rate, 0) REC_NREC_RATE
4068 ,100 REC_NREC_RATE
4069 ,NVL(ap_dists.amount,0) REC_NREC_TAX_AMT
4070 ,ap_dists.base_amount REC_NREC_TAX_AMT_FUNCL_CURR
4071 ,ap_dists.base_amount REC_NREC_TAX_AMT_TAX_CURR
4072 ,DECODE(ap_dists.line_type_lookup_code,
4073 'REC_TAX', 'AD_HOC_RECOVERY', NULL) RECOVERY_RATE_CODE
4074 ,DECODE(ap_dists.line_type_lookup_code,
4075 'REC_TAX', 'STANDARD', NULL) RECOVERY_TYPE_CODE
4076 ,NVL(ap_dists.amount,0) TAX_AMT
4077 ,ap_dists.base_amount TAX_AMT_FUNCL_CURR
4078 ,ap_dists.base_amount TAX_AMT_TAX_CURR
4079 -- ,NULL RECOVERY_TYPE_ID
4080 -- ,NULL REF_DOC_CURR_CONV_RATE
4081 ,ap_dists1.po_distribution_id REF_DOC_DIST_ID
4082 -- ,NULL REF_DOC_PER_UNIT_NREC_TAX_AMT
4083 -- ,NULL REF_DOC_TAX_DIST_ID
4084 -- ,NULL REF_DOC_TRX_LINE_DIST_QTY
4085 -- ,NULL REF_DOC_UNIT_PRICE
4086 -- ,NULL REF_PER_TRX_CURR_UNIT_NR_AMT
4087 ,ap_dists.parent_reversal_id REVERSED_TAX_DIST_ID
4088 -- ,NULL ROUNDING_RULE_CODE
4089 ,ap_dists.task_id -- TASK_ID
4090 ,ap_dists.taxable_base_amount TAXABLE_AMT_FUNCL_CURR
4091 ,ap_dists.taxable_base_amount TAXABLE_AMT_TAX_CURR
4092 ,ap_dists1.amount TRX_LINE_DIST_AMT
4093 ,ap_dists1.invoice_distribution_id TRX_LINE_DIST_ID
4094 ,NVL(ap_dists1.quantity_invoiced, 0) TRX_LINE_DIST_QTY
4095 ,DECODE(ap_dists.charge_applicable_to_dist_id, NULL,
4096 ap_dists.amount,
4097 SUM (ap_dists.amount) OVER
4098 (PARTITION BY ap_dists.invoice_id,
4099 ap_dists.charge_applicable_to_dist_id)) TRX_LINE_DIST_TAX_AMT
4100 -- ,NULL UNROUNDED_REC_NREC_TAX_AMT
4101 -- ,NULL UNROUNDED_TAXABLE_AMT
4102 ,ap_dists.TAXABLE_AMOUNT TAXABLE_AMT
4103 ,ap_dists.ATTRIBUTE_CATEGORY -- ATTRIBUTE_CATEGORY
4104 ,ap_dists.ATTRIBUTE1 -- ATTRIBUTE1
4105 ,ap_dists.ATTRIBUTE2 -- ATTRIBUTE2
4106 ,ap_dists.ATTRIBUTE3 -- ATTRIBUTE3
4107 ,ap_dists.ATTRIBUTE4 -- ATTRIBUTE4
4108 ,ap_dists.ATTRIBUTE5 -- ATTRIBUTE5
4109 ,ap_dists.ATTRIBUTE6 -- ATTRIBUTE6
4110 ,ap_dists.ATTRIBUTE7 -- ATTRIBUTE7
4111 ,ap_dists.ATTRIBUTE8 -- ATTRIBUTE8
4112 ,ap_dists.ATTRIBUTE9 -- ATTRIBUTE9
4113 ,ap_dists.ATTRIBUTE10 -- ATTRIBUTE10
4114 ,ap_dists.ATTRIBUTE11 -- ATTRIBUTE11
4115 ,ap_dists.ATTRIBUTE12 -- ATTRIBUTE12
4116 ,ap_dists.ATTRIBUTE13 -- ATTRIBUTE13
4117 ,ap_dists.ATTRIBUTE14 -- ATTRIBUTE14
4118 ,ap_dists.ATTRIBUTE15 -- ATTRIBUTE15
4119 ,ap_dists.GLOBAL_ATTRIBUTE_CATEGORY -- GLOBAL_ATTRIBUTE_CATEGORY
4120 ,ap_dists.GLOBAL_ATTRIBUTE1 -- GLOBAL_ATTRIBUTE1
4121 ,ap_dists.GLOBAL_ATTRIBUTE2 -- GLOBAL_ATTRIBUTE2
4122 ,ap_dists.GLOBAL_ATTRIBUTE3 -- GLOBAL_ATTRIBUTE3
4123 ,ap_dists.GLOBAL_ATTRIBUTE4 -- GLOBAL_ATTRIBUTE4
4124 ,ap_dists.GLOBAL_ATTRIBUTE5 -- GLOBAL_ATTRIBUTE5
4125 ,ap_dists.GLOBAL_ATTRIBUTE6 -- GLOBAL_ATTRIBUTE6
4126 ,ap_dists.GLOBAL_ATTRIBUTE7 -- GLOBAL_ATTRIBUTE7
4127 ,ap_dists.GLOBAL_ATTRIBUTE8 -- GLOBAL_ATTRIBUTE8
4128 ,ap_dists.GLOBAL_ATTRIBUTE9 -- GLOBAL_ATTRIBUTE9
4129 ,ap_dists.GLOBAL_ATTRIBUTE10 -- GLOBAL_ATTRIBUTE10
4130 ,ap_dists.GLOBAL_ATTRIBUTE11 -- GLOBAL_ATTRIBUTE11
4131 ,ap_dists.GLOBAL_ATTRIBUTE12 -- GLOBAL_ATTRIBUTE12
4132 ,ap_dists.GLOBAL_ATTRIBUTE13 -- GLOBAL_ATTRIBUTE13
4133 ,ap_dists.GLOBAL_ATTRIBUTE14 -- GLOBAL_ATTRIBUTE14
4134 ,ap_dists.GLOBAL_ATTRIBUTE15 -- GLOBAL_ATTRIBUTE15
4135 ,ap_dists.GLOBAL_ATTRIBUTE16 -- GLOBAL_ATTRIBUTE16
4136 ,ap_dists.GLOBAL_ATTRIBUTE17 -- GLOBAL_ATTRIBUTE17
4137 ,ap_dists.GLOBAL_ATTRIBUTE18 -- GLOBAL_ATTRIBUTE18
4138 ,ap_dists.GLOBAL_ATTRIBUTE19 -- GLOBAL_ATTRIBUTE19
4139 ,ap_dists.GLOBAL_ATTRIBUTE20 -- GLOBAL_ATTRIBUTE20
4140 ,'Y' HISTORICAL_FLAG
4141 ,'N' OVERRIDDEN_FLAG
4142 ,'N' SELF_ASSESSED_FLAG
4143 ,'Y' TAX_APPORTIONMENT_FLAG
4144 ,DECODE(ap_dists.charge_applicable_to_dist_id,
4145 NULL, 'Y', 'N') TAX_ONLY_LINE_FLAG
4146 ,'N' INCLUSIVE_FLAG
4147 ,'N' MRC_TAX_DIST_FLAG
4148 ,'N' REC_TYPE_RULE_FLAG
4149 ,'N' NEW_REC_RATE_CODE_FLAG
4150 ,NVL(ap_dists.tax_recoverable_flag, 'N') RECOVERABLE_FLAG
4151 ,ap_dists.reversal_flag REVERSE_FLAG
4152 ,'N' REC_RATE_DET_RULE_FLAG
4153 ,'N' BACKWARD_COMPATIBILITY_FLAG
4154 ,'N' FREEZE_FLAG
4155 ,DECODE(ap_dists.posted_flag, 'Y', 'A', NULL) POSTING_FLAG
4156 ,NVL(lines1.accounting_date,
4157 NVL(inv.invoice_date, sysdate)) TAX_DATE
4158 ,NVL(lines1.accounting_date,
4159 NVL(inv.invoice_date, sysdate)) TAX_DETERMINE_DATE
4160 ,NVL(lines1.accounting_date,
4161 NVL(inv.invoice_date, sysdate)) TAX_POINT_DATE
4162 ,1 CREATED_BY
4163 ,SYSDATE CREATION_DATE
4164 --,NULL LAST_MANUAL_ENTRY
4165 ,SYSDATE LAST_UPDATE_DATE
4166 ,1 LAST_UPDATE_LOGIN
4167 ,1 LAST_UPDATED_BY
4168 ,1 OBJECT_VERSION_NUMBER
4169 ,ap_dists1.old_dist_line_number ORIG_AP_CHRG_DIST_NUM
4170 ,ap_dists1.old_distribution_id ORIG_AP_CHRG_DIST_ID
4171 ,ap_dists.old_dist_line_number ORIG_AP_TAX_DIST_NUM
4172 ,ap_dists.old_distribution_id ORIG_AP_TAX_DIST_ID
4173 ,'N' MULTIPLE_JURISDICTIONS_FLAG
4174 ,DECODE(ap_dists.posted_flag, 'Y', '111111111111111',
4175 'P', '111111111111111',
4176 '000000000000000') LEGAL_REPORTING_STATUS
4177 ,DECODE(lines.discarded_flag, 'Y', 'Y', 'N') CANCEL_FLAG
4178 ,NVL(rates.def_rec_settlement_option_code,
4179 taxes.def_rec_settlement_option_code) DEF_REC_SETTLEMENT_OPTION_CODE
4180 --,TAX_JURISDICTION_ID
4181 ,rates.tax_rate_id ACCOUNT_SOURCE_TAX_RATE_ID
4182 ,(SELECT tax_rate_id FROM zx_rates_b
4183 WHERE tax_rate_code = 'AD_HOC_RECOVERY'
4184 AND rate_type_code = 'RECOVERY'
4185 AND tax_regime_code = rates.tax_regime_code
4186 AND tax = rates.tax
4187 AND content_owner_id = ptp.party_tax_profile_id
4188 AND record_type_code = 'MIGRATED'
4189 AND tax_class = 'INPUT') RECOVERY_RATE_ID
4190 ,DECODE(lines.line_source,'MANUAL LINE ENTRY','Y','N') MANUALLY_ENTERED_FLAG --BUG7146063
4191 ,DECODE(lines.line_source,'MANUAL LINE ENTRY','TAX_AMOUNT',NULL) LAST_MANUAL_ENTRY --BUG7146063
4192 FROM ( select distinct other_doc_application_id,other_doc_trx_id from ZX_VALIDATION_ERRORS_GT ) zxvalerr, --Bug 5187701
4193 ap_invoices_all inv,
4194 fnd_currencies fnd_curr,
4195 -- fnd_document_sequences fds,
4196 ap_invoice_distributions_all ap_dists,
4197 ap_invoice_distributions_all ap_dists1,
4198 ap_invoice_lines_all lines1,
4199 ap_invoice_lines_all lines,
4200 zx_rates_b rates,
4201 zx_regimes_b regimes,
4202 zx_taxes_b taxes,
4203 zx_status_b status,
4204 zx_party_tax_profile ptp
4205 WHERE zxvalerr.other_doc_application_id = 200
4206 AND inv.invoice_id = zxvalerr.other_doc_trx_id
4207 AND fnd_curr.currency_code = inv.invoice_currency_code
4208 -- AND inv.doc_sequence_id = fds.doc_sequence_id(+)
4209 AND ap_dists.invoice_id = inv.invoice_id
4210 AND ap_dists.line_type_lookup_code IN ('REC_TAX','NONREC_TAX')
4211 AND NVL(ap_dists.historical_flag, 'N') = 'Y'
4212 -- AND ap_dists1.invoice_id = ap_dists.invoice_id
4213 AND ap_dists1.invoice_distribution_id = NVL(ap_dists.charge_applicable_to_dist_id,
4214 ap_dists.invoice_distribution_id)
4215 AND lines1.invoice_id = ap_dists1.invoice_id
4216 AND lines1.line_number = ap_dists1.invoice_line_number
4217 AND NVL(lines1.historical_flag, 'N') = 'Y'
4218 AND lines.invoice_id = ap_dists.invoice_id
4219 AND lines.line_number = ap_dists.invoice_line_number
4220 AND NVL(lines.historical_flag, 'N') = 'Y'
4221 AND rates.source_id(+) = ap_dists.tax_code_id
4222 AND regimes.tax_regime_code(+) = rates.tax_regime_code
4223 AND taxes.tax_regime_code(+) = rates.tax_regime_code
4224 AND taxes.tax(+) = rates.tax
4225 AND taxes.content_owner_id(+) = rates.content_owner_id
4226 AND status.tax_regime_code(+) = rates.tax_regime_code
4227 AND status.tax(+) = rates.tax
4228 AND status.tax_status_code(+) = rates.tax_status_code
4229 AND status.content_owner_id(+) = rates.content_owner_id
4230 -- AND NVL(taxes.effective_from,
4231 -- NVL(lines1.accounting_date, NVL(inv.invoice_date, sysdate)))
4232 -- <= NVL(lines1.accounting_date, NVL(inv.invoice_date, sysdate))
4233 -- AND (NVL(taxes.effective_to,
4234 -- NVL(lines1.accounting_date,
4235 -- NVL(inv.invoice_date, sysdate)) )
4236 -- >= NVL(lines1.accounting_date, NVL(inv.invoice_date, sysdate))
4237 -- OR taxes.effective_to IS NULL)
4238 AND ptp.party_type_code = 'OU'
4239 AND ptp.party_id = DECODE(l_multi_org_flag,'N', l_org_id, ap_dists.org_id));
4240
4241 IF (g_level_procedure >= g_current_runtime_level ) THEN
4242 FND_LOG.STRING(g_level_procedure,
4243 'ZX.PLSQL.ZX_ON_FLY_TRX_UPGRADE_AP_PKG.upgrade_trx_on_fly_blk_ap.END',
4244 'ZX_ON_FLY_TRX_UPGRADE_AP_PKG.upgrade_trx_on_fly_blk_ap(+)');
4245 END IF;
4246
4247 EXCEPTION
4248 WHEN OTHERS THEN
4249 x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4250 IF (g_level_unexpected >= g_current_runtime_level ) THEN
4251 FND_LOG.STRING(g_level_unexpected,
4252 'ZX.PLSQL.ZX_ON_FLY_TRX_UPGRADE_AP_PKG.upgrade_trx_on_fly_blk_ap',
4253 sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80));
4254 FND_LOG.STRING(g_level_unexpected,
4255 'ZX.PLSQL.ZX_ON_FLY_TRX_UPGRADE_AP_PKG.upgrade_trx_on_fly_blk_ap.END',
4256 'ZX_ON_FLY_TRX_UPGRADE_AP_PKG.upgrade_trx_on_fly_blk_ap(-)');
4257 END IF;
4258
4259 END upgrade_trx_on_fly_blk_ap;
4260
4261 END ZX_ON_FLY_TRX_UPGRADE_AP_PKG;
4262