[Home] [Help]
152697: WHEN 15 THEN fvl167.meaning
152698:
152699: ELSE null
152700: END source_meaning
152701: FROM xla_events_gt xet
152702: , AP_INVOICE_EXTRACT_HEADER_V h2
152703: , AP_SYSTEM_PARAMETERS_EXTRACT_V h4
152704: , fnd_lookup_values fvl10
152705: , fnd_lookup_values fvl43
153049: WHEN 47 THEN fvl145.meaning
153050:
153051: ELSE null
153052: END source_meaning
153053: FROM xla_events_gt xet
153054: , AP_INVOICE_EXTRACT_DETAILS_V l1
153055: , AP_PO_HEADERS_EXTRACT_V l3
153056: , ZX_AP_DEF_TAX_EXTRACT_V l5
153057: , ZX_AP_TAX_JRNL_LINE_DESC_V l6
153408: , fvl167.meaning source_167_meaning
153409: , h2.INV_DOC_SEQUENCE_CATEGORY source_171
153410: , h2.INV_DOC_SEQUENCE_IDENTIFIER source_172
153411: , h2.INV_DOC_SEQUENCE_VALUE source_173
153412: FROM xla_events_gt xet
153413: , AP_INVOICE_EXTRACT_HEADER_V h2
153414: , AP_SYSTEM_PARAMETERS_EXTRACT_V h4
153415: , fnd_lookup_values fvl10
153416: , fnd_lookup_values fvl43
153516: , l1.BUS_FLOW_INV_DIST_ID source_99
153517: , l1.BUS_FLOW_INV_ID source_100
153518: , l1.SELF_ASSESSED_TAX_FLAG source_145
153519: , fvl145.meaning source_145_meaning
153520: FROM xla_events_gt xet
153521: , AP_INVOICE_EXTRACT_DETAILS_V l1
153522: , AP_PO_HEADERS_EXTRACT_V l3
153523: , ZX_AP_DEF_TAX_EXTRACT_V l5
153524: , ZX_AP_TAX_JRNL_LINE_DESC_V l6
155945: WHEN 6 THEN fvl43.meaning
155946:
155947: ELSE null
155948: END source_meaning
155949: FROM xla_events_gt xet
155950: , AP_INVOICE_EXTRACT_HEADER_V h2
155951: , AP_SYSTEM_PARAMETERS_EXTRACT_V h4
155952: , fnd_lookup_values fvl10
155953: , fnd_lookup_values fvl43
156287: WHEN 46 THEN fvl145.meaning
156288:
156289: ELSE null
156290: END source_meaning
156291: FROM xla_events_gt xet
156292: , AP_INVOICE_EXTRACT_DETAILS_V l1
156293: , AP_PO_HEADERS_EXTRACT_V l3
156294: , ZX_AP_DEF_TAX_EXTRACT_V l5
156295: , ZX_AP_TAX_JRNL_LINE_DESC_V l6
156639: , h2.INV_EXCHANGE_RATE_TYPE source_148
156640: , h2.INV_DOC_SEQUENCE_CATEGORY source_171
156641: , h2.INV_DOC_SEQUENCE_IDENTIFIER source_172
156642: , h2.INV_DOC_SEQUENCE_VALUE source_173
156643: FROM xla_events_gt xet
156644: , AP_INVOICE_EXTRACT_HEADER_V h2
156645: , AP_SYSTEM_PARAMETERS_EXTRACT_V h4
156646: , fnd_lookup_values fvl10
156647: , fnd_lookup_values fvl43
156741: , l1.BUS_FLOW_INV_DIST_ID source_99
156742: , l1.BUS_FLOW_INV_ID source_100
156743: , l1.SELF_ASSESSED_TAX_FLAG source_145
156744: , fvl145.meaning source_145_meaning
156745: FROM xla_events_gt xet
156746: , AP_INVOICE_EXTRACT_DETAILS_V l1
156747: , AP_PO_HEADERS_EXTRACT_V l3
156748: , ZX_AP_DEF_TAX_EXTRACT_V l5
156749: , ZX_AP_TAX_JRNL_LINE_DESC_V l6
159166: WHEN 16 THEN fvl116.meaning
159167:
159168: ELSE null
159169: END source_meaning
159170: FROM xla_events_gt xet
159171: , AP_PAYMENT_EXTRACT_HEADER_V h2
159172: , AP_SYSTEM_PARAMETERS_EXTRACT_V h3
159173: , fnd_lookup_values fvl10
159174: , fnd_lookup_values fvl43
159407: WHEN 23 THEN fvl140.meaning
159408:
159409: ELSE null
159410: END source_meaning
159411: FROM xla_events_gt xet
159412: , AP_PAYMENT_EXTRACT_DETAILS_V l1
159413: , ZX_AP_DEF_TAX_EXTRACT_V l4
159414: , fnd_lookup_values fvl28
159415: , fnd_lookup_values fvl85
159726: , h2.AC_EXCHANGE_RATE source_121
159727: , h2.AC_EXCHANGE_RATE_TYPE source_122
159728: , h2.AC_DOC_CATEGORY_CODE source_175
159729: , h2.PAYMENT_DOCUMENT_SEQUENCE_ID source_176
159730: FROM xla_events_gt xet
159731: , AP_PAYMENT_EXTRACT_HEADER_V h2
159732: , AP_SYSTEM_PARAMETERS_EXTRACT_V h3
159733: , fnd_lookup_values fvl10
159734: , fnd_lookup_values fvl43
159811: , l4.DEF_REC_SETTLEMENT_OPTION_CODE source_140
159812: , fvl140.meaning source_140_meaning
159813: , l1.PMT_MAT_BASE_AMT_DIFF source_157
159814: , l1.PMT_MAT_GAIN_LOSS_INDICATOR source_164
159815: FROM xla_events_gt xet
159816: , AP_PAYMENT_EXTRACT_DETAILS_V l1
159817: , ZX_AP_DEF_TAX_EXTRACT_V l4
159818: , fnd_lookup_values fvl28
159819: , fnd_lookup_values fvl85
161466: WHEN 15 THEN fvl167.meaning
161467:
161468: ELSE null
161469: END source_meaning
161470: FROM xla_events_gt xet
161471: , AP_INVOICE_EXTRACT_HEADER_V h2
161472: , AP_SYSTEM_PARAMETERS_EXTRACT_V h4
161473: , fnd_lookup_values fvl10
161474: , fnd_lookup_values fvl43
161828: WHEN 47 THEN fvl145.meaning
161829:
161830: ELSE null
161831: END source_meaning
161832: FROM xla_events_gt xet
161833: , AP_INVOICE_EXTRACT_DETAILS_V l1
161834: , AP_PO_HEADERS_EXTRACT_V l3
161835: , ZX_AP_DEF_TAX_EXTRACT_V l5
161836: , ZX_AP_TAX_JRNL_LINE_DESC_V l6
162191: , fvl167.meaning source_167_meaning
162192: , h2.INV_DOC_SEQUENCE_CATEGORY source_171
162193: , h2.INV_DOC_SEQUENCE_IDENTIFIER source_172
162194: , h2.INV_DOC_SEQUENCE_VALUE source_173
162195: FROM xla_events_gt xet
162196: , AP_INVOICE_EXTRACT_HEADER_V h2
162197: , AP_SYSTEM_PARAMETERS_EXTRACT_V h4
162198: , fnd_lookup_values fvl10
162199: , fnd_lookup_values fvl43
162301: , l1.SELF_ASSESSED_TAX_FLAG source_145
162302: , fvl145.meaning source_145_meaning
162303: , l1.BUS_FLOW_RET_INV_DIST_ID source_168
162304: , l1.BUS_FLOW_RET_INV_ID source_169
162305: FROM xla_events_gt xet
162306: , AP_INVOICE_EXTRACT_DETAILS_V l1
162307: , AP_PO_HEADERS_EXTRACT_V l3
162308: , ZX_AP_DEF_TAX_EXTRACT_V l5
162309: , ZX_AP_TAX_JRNL_LINE_DESC_V l6
164921: WHEN 41 THEN fvl177.meaning
164922:
164923: ELSE null
164924: END source_meaning
164925: FROM xla_events_gt xet
164926: , AP_PAYMENT_EXTRACT_HEADER_V h2
164927: , AP_SYSTEM_PARAMETERS_EXTRACT_V h3
164928: , FV_XLA_PAYMENTS_V h5
164929: , fnd_lookup_values fvl10
165271: WHEN 42 THEN fvl166.meaning
165272:
165273: ELSE null
165274: END source_meaning
165275: FROM xla_events_gt xet
165276: , AP_PAYMENT_EXTRACT_DETAILS_V l1
165277: , FV_XLA_AP_REF_V l4
165278: , ZX_AP_DEF_TAX_EXTRACT_V l6
165279: , ZX_AP_TAX_JRNL_LINE_DESC_V l7
165710: , h2.AC_DOC_CATEGORY_CODE source_175
165711: , h2.PAYMENT_DOCUMENT_SEQUENCE_ID source_176
165712: , h2.TRANSAC_REVERSAL_FLAG source_177
165713: , fvl177.meaning source_177_meaning
165714: FROM xla_events_gt xet
165715: , AP_PAYMENT_EXTRACT_HEADER_V h2
165716: , AP_SYSTEM_PARAMETERS_EXTRACT_V h3
165717: , FV_XLA_PAYMENTS_V h5
165718: , fnd_lookup_values fvl10
165836: , l1.INV_PMT_BASE_AMT_DIFF source_156
165837: , l1.INV_PMT_GAIN_LOSS_INDICATOR source_161
165838: , l1.AWT_AT_PMT_TIME source_166
165839: , fvl166.meaning source_166_meaning
165840: FROM xla_events_gt xet
165841: , AP_PAYMENT_EXTRACT_DETAILS_V l1
165842: , FV_XLA_AP_REF_V l4
165843: , ZX_AP_DEF_TAX_EXTRACT_V l6
165844: , ZX_AP_TAX_JRNL_LINE_DESC_V l7
168584: WHEN 1 THEN fvl10.meaning
168585:
168586: ELSE null
168587: END source_meaning
168588: FROM xla_events_gt xet
168589: , AP_INVOICE_EXTRACT_HEADER_V h1
168590: , AP_SYSTEM_PARAMETERS_EXTRACT_V h4
168591: , fnd_lookup_values fvl10
168592: ,(select rownum r from all_objects where rownum <= 16 and owner = p_apps_owner)
168929: WHEN 38 THEN fvl140.meaning
168930:
168931: ELSE null
168932: END source_meaning
168933: FROM xla_events_gt xet
168934: , AP_PREPAYAPP_EXTRACT_DETAILS_V l2
168935: , AP_PREPAY_DEF_TAX_EXTRACT_V l3
168936: , ZX_AP_DEF_TAX_EXTRACT_V l5
168937: , ZX_AP_TAX_JRNL_LINE_DESC_V l6
169268: , h1.INV_EXCHANGE_RATE_TYPE source_148
169269: , h1.INV_DOC_SEQUENCE_CATEGORY source_171
169270: , h1.INV_DOC_SEQUENCE_IDENTIFIER source_172
169271: , h1.INV_DOC_SEQUENCE_VALUE source_173
169272: FROM xla_events_gt xet
169273: , AP_INVOICE_EXTRACT_HEADER_V h1
169274: , AP_SYSTEM_PARAMETERS_EXTRACT_V h4
169275: , fnd_lookup_values fvl10
169276: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
169365: , l2.BF_ACCRUAL_PP_INV source_152
169366: , l2.BASE_AMT_AT_PP_PAY_XRATE source_153
169367: , l2.APAD_BASE_AMOUNT_DIFF source_158
169368: , l2.INV_PREPMT_GAIN_LOSS_INDICATOR source_165
169369: FROM xla_events_gt xet
169370: , AP_PREPAYAPP_EXTRACT_DETAILS_V l2
169371: , AP_PREPAY_DEF_TAX_EXTRACT_V l3
169372: , ZX_AP_DEF_TAX_EXTRACT_V l5
169373: , ZX_AP_TAX_JRNL_LINE_DESC_V l6
170958: WHEN 6 THEN fvl43.meaning
170959:
170960: ELSE null
170961: END source_meaning
170962: FROM xla_events_gt xet
170963: , AP_INVOICE_EXTRACT_HEADER_V h2
170964: , AP_SYSTEM_PARAMETERS_EXTRACT_V h4
170965: , fnd_lookup_values fvl10
170966: , fnd_lookup_values fvl26
171296: WHEN 44 THEN fvl145.meaning
171297:
171298: ELSE null
171299: END source_meaning
171300: FROM xla_events_gt xet
171301: , AP_INVOICE_EXTRACT_DETAILS_V l1
171302: , AP_PO_HEADERS_EXTRACT_V l3
171303: , ZX_AP_DEF_TAX_EXTRACT_V l5
171304: , ZX_AP_TAX_JRNL_LINE_DESC_V l6
171652: , h2.INV_EXCHANGE_RATE_TYPE source_148
171653: , h2.INV_DOC_SEQUENCE_CATEGORY source_171
171654: , h2.INV_DOC_SEQUENCE_IDENTIFIER source_172
171655: , h2.INV_DOC_SEQUENCE_VALUE source_173
171656: FROM xla_events_gt xet
171657: , AP_INVOICE_EXTRACT_HEADER_V h2
171658: , AP_SYSTEM_PARAMETERS_EXTRACT_V h4
171659: , fnd_lookup_values fvl10
171660: , fnd_lookup_values fvl26
171758: , l5.DEF_REC_SETTLEMENT_OPTION_CODE source_140
171759: , fvl140.meaning source_140_meaning
171760: , l1.SELF_ASSESSED_TAX_FLAG source_145
171761: , fvl145.meaning source_145_meaning
171762: FROM xla_events_gt xet
171763: , AP_INVOICE_EXTRACT_DETAILS_V l1
171764: , AP_PO_HEADERS_EXTRACT_V l3
171765: , ZX_AP_DEF_TAX_EXTRACT_V l5
171766: , ZX_AP_TAX_JRNL_LINE_DESC_V l6
174267: WHEN 31 THEN fvl125.meaning
174268:
174269: ELSE null
174270: END source_meaning
174271: FROM xla_events_gt xet
174272: , AP_PAYMENT_EXTRACT_HEADER_V h2
174273: , AP_SYSTEM_PARAMETERS_EXTRACT_V h3
174274: , fnd_lookup_values fvl10
174275: , fnd_lookup_values fvl14
174605: WHEN 42 THEN fvl166.meaning
174606:
174607: ELSE null
174608: END source_meaning
174609: FROM xla_events_gt xet
174610: , AP_PAYMENT_EXTRACT_DETAILS_V l1
174611: , ZX_AP_DEF_TAX_EXTRACT_V l4
174612: , fnd_lookup_values fvl28
174613: , fnd_lookup_values fvl56
175007: , h2.PAYMENT_TYPE source_125
175008: , fvl125.meaning source_125_meaning
175009: , h2.AC_DOC_CATEGORY_CODE source_175
175010: , h2.PAYMENT_DOCUMENT_SEQUENCE_ID source_176
175011: FROM xla_events_gt xet
175012: , AP_PAYMENT_EXTRACT_HEADER_V h2
175013: , AP_SYSTEM_PARAMETERS_EXTRACT_V h3
175014: , fnd_lookup_values fvl10
175015: , fnd_lookup_values fvl14
175121: , l1.PMT_CLR_GAIN_LOSS_INDICATOR source_162
175122: , l1.PMT_CLR_BASE_AMT_DIFF source_163
175123: , l1.AWT_AT_PMT_TIME source_166
175124: , fvl166.meaning source_166_meaning
175125: FROM xla_events_gt xet
175126: , AP_PAYMENT_EXTRACT_DETAILS_V l1
175127: , ZX_AP_DEF_TAX_EXTRACT_V l4
175128: , fnd_lookup_values fvl28
175129: , fnd_lookup_values fvl56
177328: WHEN 27 THEN fvl177.meaning
177329:
177330: ELSE null
177331: END source_meaning
177332: FROM xla_events_gt xet
177333: , AP_PAYMENT_EXTRACT_HEADER_V h2
177334: , AP_SYSTEM_PARAMETERS_EXTRACT_V h3
177335: , fnd_lookup_values fvl10
177336: , fnd_lookup_values fvl14
177593: WHEN 17 THEN fvl101.meaning
177594:
177595: ELSE null
177596: END source_meaning
177597: FROM xla_events_gt xet
177598: , AP_PAYMENT_EXTRACT_DETAILS_V l1
177599: , ZX_AP_DEF_TAX_EXTRACT_V l4
177600: , ZX_AP_TAX_JRNL_LINE_DESC_V l5
177601: , fnd_lookup_values fvl28
177932: , h2.AC_DOC_CATEGORY_CODE source_175
177933: , h2.PAYMENT_DOCUMENT_SEQUENCE_ID source_176
177934: , h2.TRANSAC_REVERSAL_FLAG source_177
177935: , fvl177.meaning source_177_meaning
177936: FROM xla_events_gt xet
177937: , AP_PAYMENT_EXTRACT_HEADER_V h2
177938: , AP_SYSTEM_PARAMETERS_EXTRACT_V h3
177939: , fnd_lookup_values fvl10
177940: , fnd_lookup_values fvl14
178033: , l1.INV_EXCHANGE_RATE source_147
178034: , l1.INV_EXCHANGE_RATE_TYPE source_148
178035: , l1.INV_PMT_BASE_AMT_DIFF source_156
178036: , l1.INV_PMT_GAIN_LOSS_INDICATOR source_161
178037: FROM xla_events_gt xet
178038: , AP_PAYMENT_EXTRACT_DETAILS_V l1
178039: , ZX_AP_DEF_TAX_EXTRACT_V l4
178040: , ZX_AP_TAX_JRNL_LINE_DESC_V l5
178041: , fnd_lookup_values fvl28
179907: ,p_level => C_LEVEL_STATEMENT
179908: ,p_module => l_log_module);
179909:
179910: trace
179911: (p_msg => '# of events in xla_events_gt: '
179912: ||xla_context_pkg.get_event_count_context
179913: ,p_level => C_LEVEL_STATEMENT
179914: ,p_module => l_log_module);
179915: