[Home] [Help]
144109: WHEN 21 THEN fvl165.meaning
144110:
144111: ELSE null
144112: END source_meaning
144113: FROM xla_events_gt xet
144114: , AP_INVOICE_EXTRACT_HEADER_V h2
144115: , AP_SYSTEM_PARAMETERS_EXTRACT_V h4
144116: , fnd_lookup_values fvl15
144117: , fnd_lookup_values fvl47
144461: WHEN 47 THEN fvl142.meaning
144462:
144463: ELSE null
144464: END source_meaning
144465: FROM xla_events_gt xet
144466: , AP_INVOICE_EXTRACT_DETAILS_V l1
144467: , AP_PO_HEADERS_EXTRACT_V l3
144468: , ZX_AP_DEF_TAX_EXTRACT_V l5
144469: , ZX_AP_TAX_JRNL_LINE_DESC_V l6
144832: , h2.INV_EXCHANGE_RATE_TYPE source_145
144833: , h2.AI_INVOICE_TYPE_LOOKUP_CODE source_165
144834: , fvl165.meaning source_165_meaning
144835: , h2.INV_DOC_SEQUENCE_IDENTIFIER source_168
144836: FROM xla_events_gt xet
144837: , AP_INVOICE_EXTRACT_HEADER_V h2
144838: , AP_SYSTEM_PARAMETERS_EXTRACT_V h4
144839: , fnd_lookup_values fvl15
144840: , fnd_lookup_values fvl47
144940: , l1.POD_ACCRUE_ON_RECEIPT_FLAG source_96
144941: , fvl96.meaning source_96_meaning
144942: , l1.SELF_ASSESSED_TAX_FLAG source_142
144943: , fvl142.meaning source_142_meaning
144944: FROM xla_events_gt xet
144945: , AP_INVOICE_EXTRACT_DETAILS_V l1
144946: , AP_PO_HEADERS_EXTRACT_V l3
144947: , ZX_AP_DEF_TAX_EXTRACT_V l5
144948: , ZX_AP_TAX_JRNL_LINE_DESC_V l6
147403: WHEN 12 THEN fvl47.meaning
147404:
147405: ELSE null
147406: END source_meaning
147407: FROM xla_events_gt xet
147408: , AP_INVOICE_EXTRACT_HEADER_V h2
147409: , AP_SYSTEM_PARAMETERS_EXTRACT_V h4
147410: , fnd_lookup_values fvl15
147411: , fnd_lookup_values fvl47
147745: WHEN 46 THEN fvl142.meaning
147746:
147747: ELSE null
147748: END source_meaning
147749: FROM xla_events_gt xet
147750: , AP_INVOICE_EXTRACT_DETAILS_V l1
147751: , AP_PO_HEADERS_EXTRACT_V l3
147752: , ZX_AP_DEF_TAX_EXTRACT_V l5
147753: , ZX_AP_TAX_JRNL_LINE_DESC_V l6
148109: , h2.INV_EXCHANGE_DATE source_143
148110: , h2.INV_EXCHANGE_RATE source_144
148111: , h2.INV_EXCHANGE_RATE_TYPE source_145
148112: , h2.INV_DOC_SEQUENCE_IDENTIFIER source_168
148113: FROM xla_events_gt xet
148114: , AP_INVOICE_EXTRACT_HEADER_V h2
148115: , AP_SYSTEM_PARAMETERS_EXTRACT_V h4
148116: , fnd_lookup_values fvl15
148117: , fnd_lookup_values fvl47
148211: , l1.POD_ACCRUE_ON_RECEIPT_FLAG source_96
148212: , fvl96.meaning source_96_meaning
148213: , l1.SELF_ASSESSED_TAX_FLAG source_142
148214: , fvl142.meaning source_142_meaning
148215: FROM xla_events_gt xet
148216: , AP_INVOICE_EXTRACT_DETAILS_V l1
148217: , AP_PO_HEADERS_EXTRACT_V l3
148218: , ZX_AP_DEF_TAX_EXTRACT_V l5
148219: , ZX_AP_TAX_JRNL_LINE_DESC_V l6
150670: WHEN 20 THEN fvl113.meaning
150671:
150672: ELSE null
150673: END source_meaning
150674: FROM xla_events_gt xet
150675: , AP_PAYMENT_EXTRACT_HEADER_V h2
150676: , AP_SYSTEM_PARAMETERS_EXTRACT_V h3
150677: , fnd_lookup_values fvl15
150678: , fnd_lookup_values fvl47
150911: WHEN 23 THEN fvl137.meaning
150912:
150913: ELSE null
150914: END source_meaning
150915: FROM xla_events_gt xet
150916: , AP_PAYMENT_EXTRACT_DETAILS_V l1
150917: , ZX_AP_DEF_TAX_EXTRACT_V l4
150918: , fnd_lookup_values fvl33
150919: , fnd_lookup_values fvl80
151242: , h2.AC_EXCHANGE_RATE source_118
151243: , h2.AC_EXCHANGE_RATE_TYPE source_119
151244: , h2.AC_DOC_CATEGORY_CODE source_170
151245: , h2.PAYMENT_DOCUMENT_SEQUENCE_ID source_171
151246: FROM xla_events_gt xet
151247: , AP_PAYMENT_EXTRACT_HEADER_V h2
151248: , AP_SYSTEM_PARAMETERS_EXTRACT_V h3
151249: , fnd_lookup_values fvl15
151250: , fnd_lookup_values fvl47
151327: , l4.DEF_REC_SETTLEMENT_OPTION_CODE source_137
151328: , fvl137.meaning source_137_meaning
151329: , l1.PMT_MAT_BASE_AMT_DIFF source_154
151330: , l1.PMT_MAT_GAIN_LOSS_INDICATOR source_161
151331: FROM xla_events_gt xet
151332: , AP_PAYMENT_EXTRACT_DETAILS_V l1
151333: , ZX_AP_DEF_TAX_EXTRACT_V l4
151334: , fnd_lookup_values fvl33
151335: , fnd_lookup_values fvl80
153024: WHEN 21 THEN fvl165.meaning
153025:
153026: ELSE null
153027: END source_meaning
153028: FROM xla_events_gt xet
153029: , AP_INVOICE_EXTRACT_HEADER_V h2
153030: , AP_SYSTEM_PARAMETERS_EXTRACT_V h4
153031: , fnd_lookup_values fvl15
153032: , fnd_lookup_values fvl47
153386: WHEN 47 THEN fvl142.meaning
153387:
153388: ELSE null
153389: END source_meaning
153390: FROM xla_events_gt xet
153391: , AP_INVOICE_EXTRACT_DETAILS_V l1
153392: , AP_PO_HEADERS_EXTRACT_V l3
153393: , ZX_AP_DEF_TAX_EXTRACT_V l5
153394: , ZX_AP_TAX_JRNL_LINE_DESC_V l6
153761: , h2.INV_EXCHANGE_RATE_TYPE source_145
153762: , h2.AI_INVOICE_TYPE_LOOKUP_CODE source_165
153763: , fvl165.meaning source_165_meaning
153764: , h2.INV_DOC_SEQUENCE_IDENTIFIER source_168
153765: FROM xla_events_gt xet
153766: , AP_INVOICE_EXTRACT_HEADER_V h2
153767: , AP_SYSTEM_PARAMETERS_EXTRACT_V h4
153768: , fnd_lookup_values fvl15
153769: , fnd_lookup_values fvl47
153871: , l1.SELF_ASSESSED_TAX_FLAG source_142
153872: , fvl142.meaning source_142_meaning
153873: , l1.BUS_FLOW_RET_INV_DIST_ID source_166
153874: , l1.BUS_FLOW_RET_INV_ID source_167
153875: FROM xla_events_gt xet
153876: , AP_INVOICE_EXTRACT_DETAILS_V l1
153877: , AP_PO_HEADERS_EXTRACT_V l3
153878: , ZX_AP_DEF_TAX_EXTRACT_V l5
153879: , ZX_AP_TAX_JRNL_LINE_DESC_V l6
156495: WHEN 39 THEN fvl172.meaning
156496:
156497: ELSE null
156498: END source_meaning
156499: FROM xla_events_gt xet
156500: , AP_PAYMENT_EXTRACT_HEADER_V h2
156501: , AP_SYSTEM_PARAMETERS_EXTRACT_V h3
156502: , fnd_lookup_values fvl15
156503: , fnd_lookup_values fvl19
156803: WHEN 34 THEN fvl164.meaning
156804:
156805: ELSE null
156806: END source_meaning
156807: FROM xla_events_gt xet
156808: , AP_PAYMENT_EXTRACT_DETAILS_V l1
156809: , ZX_AP_DEF_TAX_EXTRACT_V l4
156810: , ZX_AP_TAX_JRNL_LINE_DESC_V l5
156811: , fnd_lookup_values fvl33
157212: , h2.AC_DOC_CATEGORY_CODE source_170
157213: , h2.PAYMENT_DOCUMENT_SEQUENCE_ID source_171
157214: , h2.TRANSAC_REVERSAL_FLAG source_172
157215: , fvl172.meaning source_172_meaning
157216: FROM xla_events_gt xet
157217: , AP_PAYMENT_EXTRACT_HEADER_V h2
157218: , AP_SYSTEM_PARAMETERS_EXTRACT_V h3
157219: , fnd_lookup_values fvl15
157220: , fnd_lookup_values fvl19
157328: , l1.AI_INVOICE_TYPE_PAID source_163
157329: , fvl163.meaning source_163_meaning
157330: , l1.AWT_AT_PMT_TIME source_164
157331: , fvl164.meaning source_164_meaning
157332: FROM xla_events_gt xet
157333: , AP_PAYMENT_EXTRACT_DETAILS_V l1
157334: , ZX_AP_DEF_TAX_EXTRACT_V l4
157335: , ZX_AP_TAX_JRNL_LINE_DESC_V l5
157336: , fnd_lookup_values fvl33
159552: WHEN 7 THEN fvl15.meaning
159553:
159554: ELSE null
159555: END source_meaning
159556: FROM xla_events_gt xet
159557: , AP_INVOICE_EXTRACT_HEADER_V h1
159558: , AP_SYSTEM_PARAMETERS_EXTRACT_V h4
159559: , fnd_lookup_values fvl15
159560: ,(select rownum r from all_objects where rownum <= 20 and owner = p_apps_owner)
159897: WHEN 38 THEN fvl137.meaning
159898:
159899: ELSE null
159900: END source_meaning
159901: FROM xla_events_gt xet
159902: , AP_PREPAYAPP_EXTRACT_DETAILS_V l2
159903: , AP_PREPAY_DEF_TAX_EXTRACT_V l3
159904: , ZX_AP_DEF_TAX_EXTRACT_V l5
159905: , ZX_AP_TAX_JRNL_LINE_DESC_V l6
160248: , h1.INV_EXCHANGE_DATE source_143
160249: , h1.INV_EXCHANGE_RATE source_144
160250: , h1.INV_EXCHANGE_RATE_TYPE source_145
160251: , h1.INV_DOC_SEQUENCE_IDENTIFIER source_168
160252: FROM xla_events_gt xet
160253: , AP_INVOICE_EXTRACT_HEADER_V h1
160254: , AP_SYSTEM_PARAMETERS_EXTRACT_V h4
160255: , fnd_lookup_values fvl15
160256: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
160345: , l2.BF_ACCRUAL_PP_INV source_149
160346: , l2.BASE_AMT_AT_PP_PAY_XRATE source_150
160347: , l2.APAD_BASE_AMOUNT_DIFF source_155
160348: , l2.INV_PREPMT_GAIN_LOSS_INDICATOR source_162
160349: FROM xla_events_gt xet
160350: , AP_PREPAYAPP_EXTRACT_DETAILS_V l2
160351: , AP_PREPAY_DEF_TAX_EXTRACT_V l3
160352: , ZX_AP_DEF_TAX_EXTRACT_V l5
160353: , ZX_AP_TAX_JRNL_LINE_DESC_V l6
161980: WHEN 12 THEN fvl47.meaning
161981:
161982: ELSE null
161983: END source_meaning
161984: FROM xla_events_gt xet
161985: , AP_INVOICE_EXTRACT_HEADER_V h2
161986: , AP_SYSTEM_PARAMETERS_EXTRACT_V h4
161987: , fnd_lookup_values fvl15
161988: , fnd_lookup_values fvl31
162318: WHEN 44 THEN fvl142.meaning
162319:
162320: ELSE null
162321: END source_meaning
162322: FROM xla_events_gt xet
162323: , AP_INVOICE_EXTRACT_DETAILS_V l1
162324: , AP_PO_HEADERS_EXTRACT_V l3
162325: , ZX_AP_DEF_TAX_EXTRACT_V l5
162326: , ZX_AP_TAX_JRNL_LINE_DESC_V l6
162686: , h2.INV_EXCHANGE_DATE source_143
162687: , h2.INV_EXCHANGE_RATE source_144
162688: , h2.INV_EXCHANGE_RATE_TYPE source_145
162689: , h2.INV_DOC_SEQUENCE_IDENTIFIER source_168
162690: FROM xla_events_gt xet
162691: , AP_INVOICE_EXTRACT_HEADER_V h2
162692: , AP_SYSTEM_PARAMETERS_EXTRACT_V h4
162693: , fnd_lookup_values fvl15
162694: , fnd_lookup_values fvl31
162792: , l5.DEF_REC_SETTLEMENT_OPTION_CODE source_137
162793: , fvl137.meaning source_137_meaning
162794: , l1.SELF_ASSESSED_TAX_FLAG source_142
162795: , fvl142.meaning source_142_meaning
162796: FROM xla_events_gt xet
162797: , AP_INVOICE_EXTRACT_DETAILS_V l1
162798: , AP_PO_HEADERS_EXTRACT_V l3
162799: , ZX_AP_DEF_TAX_EXTRACT_V l5
162800: , ZX_AP_TAX_JRNL_LINE_DESC_V l6
165343: WHEN 35 THEN fvl122.meaning
165344:
165345: ELSE null
165346: END source_meaning
165347: FROM xla_events_gt xet
165348: , AP_PAYMENT_EXTRACT_HEADER_V h2
165349: , AP_SYSTEM_PARAMETERS_EXTRACT_V h3
165350: , fnd_lookup_values fvl15
165351: , fnd_lookup_values fvl19
165681: WHEN 42 THEN fvl164.meaning
165682:
165683: ELSE null
165684: END source_meaning
165685: FROM xla_events_gt xet
165686: , AP_PAYMENT_EXTRACT_DETAILS_V l1
165687: , ZX_AP_DEF_TAX_EXTRACT_V l4
165688: , fnd_lookup_values fvl33
165689: , fnd_lookup_values fvl80
166095: , h2.PAYMENT_TYPE source_122
166096: , fvl122.meaning source_122_meaning
166097: , h2.AC_DOC_CATEGORY_CODE source_170
166098: , h2.PAYMENT_DOCUMENT_SEQUENCE_ID source_171
166099: FROM xla_events_gt xet
166100: , AP_PAYMENT_EXTRACT_HEADER_V h2
166101: , AP_SYSTEM_PARAMETERS_EXTRACT_V h3
166102: , fnd_lookup_values fvl15
166103: , fnd_lookup_values fvl19
166209: , l1.AI_INVOICE_TYPE_PAID source_163
166210: , fvl163.meaning source_163_meaning
166211: , l1.AWT_AT_PMT_TIME source_164
166212: , fvl164.meaning source_164_meaning
166213: FROM xla_events_gt xet
166214: , AP_PAYMENT_EXTRACT_DETAILS_V l1
166215: , ZX_AP_DEF_TAX_EXTRACT_V l4
166216: , fnd_lookup_values fvl33
166217: , fnd_lookup_values fvl80
168458: WHEN 31 THEN fvl172.meaning
168459:
168460: ELSE null
168461: END source_meaning
168462: FROM xla_events_gt xet
168463: , AP_PAYMENT_EXTRACT_HEADER_V h2
168464: , AP_SYSTEM_PARAMETERS_EXTRACT_V h3
168465: , fnd_lookup_values fvl15
168466: , fnd_lookup_values fvl19
168723: WHEN 17 THEN fvl98.meaning
168724:
168725: ELSE null
168726: END source_meaning
168727: FROM xla_events_gt xet
168728: , AP_PAYMENT_EXTRACT_DETAILS_V l1
168729: , ZX_AP_DEF_TAX_EXTRACT_V l4
168730: , ZX_AP_TAX_JRNL_LINE_DESC_V l5
168731: , fnd_lookup_values fvl33
169074: , h2.AC_DOC_CATEGORY_CODE source_170
169075: , h2.PAYMENT_DOCUMENT_SEQUENCE_ID source_171
169076: , h2.TRANSAC_REVERSAL_FLAG source_172
169077: , fvl172.meaning source_172_meaning
169078: FROM xla_events_gt xet
169079: , AP_PAYMENT_EXTRACT_HEADER_V h2
169080: , AP_SYSTEM_PARAMETERS_EXTRACT_V h3
169081: , fnd_lookup_values fvl15
169082: , fnd_lookup_values fvl19
169175: , l1.INV_EXCHANGE_RATE source_144
169176: , l1.INV_EXCHANGE_RATE_TYPE source_145
169177: , l1.INV_PMT_BASE_AMT_DIFF source_153
169178: , l1.INV_PMT_GAIN_LOSS_INDICATOR source_158
169179: FROM xla_events_gt xet
169180: , AP_PAYMENT_EXTRACT_DETAILS_V l1
169181: , ZX_AP_DEF_TAX_EXTRACT_V l4
169182: , ZX_AP_TAX_JRNL_LINE_DESC_V l5
169183: , fnd_lookup_values fvl33
171071: ,p_level => C_LEVEL_STATEMENT
171072: ,p_module => l_log_module);
171073:
171074: trace
171075: (p_msg => '# of events in xla_events_gt: '
171076: ||xla_context_pkg.get_event_count_context
171077: ,p_level => C_LEVEL_STATEMENT
171078: ,p_module => l_log_module);
171079: