[Home] [Help]
143979: WHEN 22 THEN fvl164.meaning
143980:
143981: ELSE null
143982: END source_meaning
143983: FROM xla_events_gt xet
143984: , AP_INVOICE_EXTRACT_HEADER_V h2
143985: , AP_SYSTEM_PARAMETERS_EXTRACT_V h4
143986: , fnd_lookup_values fvl15
143987: , fnd_lookup_values fvl47
144336: WHEN 47 THEN fvl135.meaning
144337:
144338: ELSE null
144339: END source_meaning
144340: FROM xla_events_gt xet
144341: , AP_INVOICE_EXTRACT_DETAILS_V l1
144342: , AP_PO_HEADERS_EXTRACT_V l3
144343: , ZX_AP_DEF_TAX_EXTRACT_V l5
144344: , ZX_AP_TAX_JRNL_LINE_DESC_V l6
144712: , h2.AI_SOURCE source_163
144713: , h2.AI_INVOICE_TYPE_LOOKUP_CODE source_164
144714: , fvl164.meaning source_164_meaning
144715: , h2.INV_DOC_SEQUENCE_IDENTIFIER source_168
144716: FROM xla_events_gt xet
144717: , AP_INVOICE_EXTRACT_HEADER_V h2
144718: , AP_SYSTEM_PARAMETERS_EXTRACT_V h4
144719: , fnd_lookup_values fvl15
144720: , fnd_lookup_values fvl47
144821: , fvl95.meaning source_95_meaning
144822: , l1.SELF_ASSESSED_TAX_FLAG source_135
144823: , fvl135.meaning source_135_meaning
144824: , l1.AID_PROJECT_ID source_146
144825: FROM xla_events_gt xet
144826: , AP_INVOICE_EXTRACT_DETAILS_V l1
144827: , AP_PO_HEADERS_EXTRACT_V l3
144828: , ZX_AP_DEF_TAX_EXTRACT_V l5
144829: , ZX_AP_TAX_JRNL_LINE_DESC_V l6
147298: WHEN 12 THEN fvl47.meaning
147299:
147300: ELSE null
147301: END source_meaning
147302: FROM xla_events_gt xet
147303: , AP_INVOICE_EXTRACT_HEADER_V h2
147304: , AP_SYSTEM_PARAMETERS_EXTRACT_V h4
147305: , fnd_lookup_values fvl15
147306: , fnd_lookup_values fvl47
147645: WHEN 46 THEN fvl135.meaning
147646:
147647: ELSE null
147648: END source_meaning
147649: FROM xla_events_gt xet
147650: , AP_INVOICE_EXTRACT_DETAILS_V l1
147651: , AP_PO_HEADERS_EXTRACT_V l3
147652: , ZX_AP_DEF_TAX_EXTRACT_V l5
147653: , ZX_AP_TAX_JRNL_LINE_DESC_V l6
148014: , h2.INV_EXCHANGE_RATE source_137
148015: , h2.INV_EXCHANGE_RATE_TYPE source_138
148016: , h2.AI_SOURCE source_163
148017: , h2.INV_DOC_SEQUENCE_IDENTIFIER source_168
148018: FROM xla_events_gt xet
148019: , AP_INVOICE_EXTRACT_HEADER_V h2
148020: , AP_SYSTEM_PARAMETERS_EXTRACT_V h4
148021: , fnd_lookup_values fvl15
148022: , fnd_lookup_values fvl47
148117: , fvl95.meaning source_95_meaning
148118: , l1.SELF_ASSESSED_TAX_FLAG source_135
148119: , fvl135.meaning source_135_meaning
148120: , l1.AID_PROJECT_ID source_146
148121: FROM xla_events_gt xet
148122: , AP_INVOICE_EXTRACT_DETAILS_V l1
148123: , AP_PO_HEADERS_EXTRACT_V l3
148124: , ZX_AP_DEF_TAX_EXTRACT_V l5
148125: , ZX_AP_TAX_JRNL_LINE_DESC_V l6
150590: WHEN 21 THEN fvl113.meaning
150591:
150592: ELSE null
150593: END source_meaning
150594: FROM xla_events_gt xet
150595: , AP_PAYMENT_EXTRACT_HEADER_V h2
150596: , AP_SYSTEM_PARAMETERS_EXTRACT_V h3
150597: , fnd_lookup_values fvl15
150598: , fnd_lookup_values fvl47
150831: WHEN 23 THEN fvl125.meaning
150832:
150833: ELSE null
150834: END source_meaning
150835: FROM xla_events_gt xet
150836: , AP_PAYMENT_EXTRACT_DETAILS_V l1
150837: , ZX_AP_DEF_TAX_EXTRACT_V l4
150838: , fnd_lookup_values fvl33
150839: , fnd_lookup_values fvl79
151165: , h2.AC_EXCHANGE_RATE source_118
151166: , h2.AC_EXCHANGE_RATE_TYPE source_119
151167: , h2.AC_DOC_CATEGORY_CODE source_170
151168: , h2.PAYMENT_DOCUMENT_SEQUENCE_ID source_171
151169: FROM xla_events_gt xet
151170: , AP_PAYMENT_EXTRACT_HEADER_V h2
151171: , AP_SYSTEM_PARAMETERS_EXTRACT_V h3
151172: , fnd_lookup_values fvl15
151173: , fnd_lookup_values fvl47
151250: , l4.DEF_REC_SETTLEMENT_OPTION_CODE source_125
151251: , fvl125.meaning source_125_meaning
151252: , l1.PMT_MAT_BASE_AMT_DIFF source_151
151253: , l1.PMT_MAT_GAIN_LOSS_INDICATOR source_158
151254: FROM xla_events_gt xet
151255: , AP_PAYMENT_EXTRACT_DETAILS_V l1
151256: , ZX_AP_DEF_TAX_EXTRACT_V l4
151257: , fnd_lookup_values fvl33
151258: , fnd_lookup_values fvl79
152968: WHEN 22 THEN fvl164.meaning
152969:
152970: ELSE null
152971: END source_meaning
152972: FROM xla_events_gt xet
152973: , AP_INVOICE_EXTRACT_HEADER_V h2
152974: , AP_SYSTEM_PARAMETERS_EXTRACT_V h4
152975: , fnd_lookup_values fvl15
152976: , fnd_lookup_values fvl47
153335: WHEN 47 THEN fvl135.meaning
153336:
153337: ELSE null
153338: END source_meaning
153339: FROM xla_events_gt xet
153340: , AP_INVOICE_EXTRACT_DETAILS_V l1
153341: , AP_PO_HEADERS_EXTRACT_V l3
153342: , ZX_AP_DEF_TAX_EXTRACT_V l5
153343: , ZX_AP_TAX_JRNL_LINE_DESC_V l6
153715: , h2.AI_SOURCE source_163
153716: , h2.AI_INVOICE_TYPE_LOOKUP_CODE source_164
153717: , fvl164.meaning source_164_meaning
153718: , h2.INV_DOC_SEQUENCE_IDENTIFIER source_168
153719: FROM xla_events_gt xet
153720: , AP_INVOICE_EXTRACT_HEADER_V h2
153721: , AP_SYSTEM_PARAMETERS_EXTRACT_V h4
153722: , fnd_lookup_values fvl15
153723: , fnd_lookup_values fvl47
153826: , fvl135.meaning source_135_meaning
153827: , l1.AID_PROJECT_ID source_146
153828: , l1.BUS_FLOW_RET_INV_DIST_ID source_166
153829: , l1.BUS_FLOW_RET_INV_ID source_167
153830: FROM xla_events_gt xet
153831: , AP_INVOICE_EXTRACT_DETAILS_V l1
153832: , AP_PO_HEADERS_EXTRACT_V l3
153833: , ZX_AP_DEF_TAX_EXTRACT_V l5
153834: , ZX_AP_TAX_JRNL_LINE_DESC_V l6
156459: WHEN 39 THEN fvl172.meaning
156460:
156461: ELSE null
156462: END source_meaning
156463: FROM xla_events_gt xet
156464: , AP_PAYMENT_EXTRACT_HEADER_V h2
156465: , AP_SYSTEM_PARAMETERS_EXTRACT_V h3
156466: , fnd_lookup_values fvl15
156467: , fnd_lookup_values fvl19
156767: WHEN 34 THEN fvl161.meaning
156768:
156769: ELSE null
156770: END source_meaning
156771: FROM xla_events_gt xet
156772: , AP_PAYMENT_EXTRACT_DETAILS_V l1
156773: , ZX_AP_DEF_TAX_EXTRACT_V l4
156774: , ZX_AP_TAX_JRNL_LINE_DESC_V l5
156775: , fnd_lookup_values fvl33
157176: , h2.AC_DOC_CATEGORY_CODE source_170
157177: , h2.PAYMENT_DOCUMENT_SEQUENCE_ID source_171
157178: , h2.TRANSAC_REVERSAL_FLAG source_172
157179: , fvl172.meaning source_172_meaning
157180: FROM xla_events_gt xet
157181: , AP_PAYMENT_EXTRACT_HEADER_V h2
157182: , AP_SYSTEM_PARAMETERS_EXTRACT_V h3
157183: , fnd_lookup_values fvl15
157184: , fnd_lookup_values fvl19
157292: , l1.AI_INVOICE_TYPE_PAID source_160
157293: , fvl160.meaning source_160_meaning
157294: , l1.AWT_AT_PMT_TIME source_161
157295: , fvl161.meaning source_161_meaning
157296: FROM xla_events_gt xet
157297: , AP_PAYMENT_EXTRACT_DETAILS_V l1
157298: , ZX_AP_DEF_TAX_EXTRACT_V l4
157299: , ZX_AP_TAX_JRNL_LINE_DESC_V l5
157300: , fnd_lookup_values fvl33
159471: WHEN 3 THEN fvl15.meaning
159472:
159473: ELSE null
159474: END source_meaning
159475: FROM xla_events_gt xet
159476: , AP_INVOICE_EXTRACT_HEADER_V h1
159477: , AP_SYSTEM_PARAMETERS_EXTRACT_V h4
159478: , fnd_lookup_values fvl15
159479: ,(select rownum r from all_objects where rownum <= 16 and owner = p_apps_owner)
159801: WHEN 45 THEN fvl165.meaning
159802:
159803: ELSE null
159804: END source_meaning
159805: FROM xla_events_gt xet
159806: , AP_PREPAYAPP_EXTRACT_DETAILS_V l2
159807: , AP_PREPAY_DEF_TAX_EXTRACT_V l3
159808: , ZX_AP_DEF_TAX_EXTRACT_V l5
159809: , ZX_AP_TAX_JRNL_LINE_DESC_V l6
160134: , h1.INV_EXCHANGE_DATE source_136
160135: , h1.INV_EXCHANGE_RATE source_137
160136: , h1.INV_EXCHANGE_RATE_TYPE source_138
160137: , h1.INV_DOC_SEQUENCE_IDENTIFIER source_168
160138: FROM xla_events_gt xet
160139: , AP_INVOICE_EXTRACT_HEADER_V h1
160140: , AP_SYSTEM_PARAMETERS_EXTRACT_V h4
160141: , fnd_lookup_values fvl15
160142: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
160228: , l2.APAD_BASE_AMOUNT_DIFF source_152
160229: , l2.INV_PREPMT_GAIN_LOSS_INDICATOR source_159
160230: , l3.DEF_REC_PP_SET_OPTION_CODE source_165
160231: , fvl165.meaning source_165_meaning
160232: FROM xla_events_gt xet
160233: , AP_PREPAYAPP_EXTRACT_DETAILS_V l2
160234: , AP_PREPAY_DEF_TAX_EXTRACT_V l3
160235: , ZX_AP_DEF_TAX_EXTRACT_V l5
160236: , ZX_AP_TAX_JRNL_LINE_DESC_V l6
161790: WHEN 12 THEN fvl47.meaning
161791:
161792: ELSE null
161793: END source_meaning
161794: FROM xla_events_gt xet
161795: , AP_INVOICE_EXTRACT_HEADER_V h2
161796: , AP_SYSTEM_PARAMETERS_EXTRACT_V h4
161797: , fnd_lookup_values fvl15
161798: , fnd_lookup_values fvl31
162133: WHEN 44 THEN fvl135.meaning
162134:
162135: ELSE null
162136: END source_meaning
162137: FROM xla_events_gt xet
162138: , AP_INVOICE_EXTRACT_DETAILS_V l1
162139: , AP_PO_HEADERS_EXTRACT_V l3
162140: , ZX_AP_DEF_TAX_EXTRACT_V l5
162141: , ZX_AP_TAX_JRNL_LINE_DESC_V l6
162506: , h2.INV_EXCHANGE_RATE source_137
162507: , h2.INV_EXCHANGE_RATE_TYPE source_138
162508: , h2.AI_SOURCE source_163
162509: , h2.INV_DOC_SEQUENCE_IDENTIFIER source_168
162510: FROM xla_events_gt xet
162511: , AP_INVOICE_EXTRACT_HEADER_V h2
162512: , AP_SYSTEM_PARAMETERS_EXTRACT_V h4
162513: , fnd_lookup_values fvl15
162514: , fnd_lookup_values fvl31
162613: , fvl125.meaning source_125_meaning
162614: , l1.SELF_ASSESSED_TAX_FLAG source_135
162615: , fvl135.meaning source_135_meaning
162616: , l1.AID_PROJECT_ID source_146
162617: FROM xla_events_gt xet
162618: , AP_INVOICE_EXTRACT_DETAILS_V l1
162619: , AP_PO_HEADERS_EXTRACT_V l3
162620: , ZX_AP_DEF_TAX_EXTRACT_V l5
162621: , ZX_AP_TAX_JRNL_LINE_DESC_V l6
165178: WHEN 36 THEN fvl122.meaning
165179:
165180: ELSE null
165181: END source_meaning
165182: FROM xla_events_gt xet
165183: , AP_PAYMENT_EXTRACT_HEADER_V h2
165184: , AP_SYSTEM_PARAMETERS_EXTRACT_V h3
165185: , fnd_lookup_values fvl15
165186: , fnd_lookup_values fvl19
165516: WHEN 42 THEN fvl161.meaning
165517:
165518: ELSE null
165519: END source_meaning
165520: FROM xla_events_gt xet
165521: , AP_PAYMENT_EXTRACT_DETAILS_V l1
165522: , ZX_AP_DEF_TAX_EXTRACT_V l4
165523: , fnd_lookup_values fvl33
165524: , fnd_lookup_values fvl79
165933: , h2.PAYMENT_TYPE source_122
165934: , fvl122.meaning source_122_meaning
165935: , h2.AC_DOC_CATEGORY_CODE source_170
165936: , h2.PAYMENT_DOCUMENT_SEQUENCE_ID source_171
165937: FROM xla_events_gt xet
165938: , AP_PAYMENT_EXTRACT_HEADER_V h2
165939: , AP_SYSTEM_PARAMETERS_EXTRACT_V h3
165940: , fnd_lookup_values fvl15
165941: , fnd_lookup_values fvl19
166047: , l1.AI_INVOICE_TYPE_PAID source_160
166048: , fvl160.meaning source_160_meaning
166049: , l1.AWT_AT_PMT_TIME source_161
166050: , fvl161.meaning source_161_meaning
166051: FROM xla_events_gt xet
166052: , AP_PAYMENT_EXTRACT_DETAILS_V l1
166053: , ZX_AP_DEF_TAX_EXTRACT_V l4
166054: , fnd_lookup_values fvl33
166055: , fnd_lookup_values fvl79
168273: WHEN 32 THEN fvl172.meaning
168274:
168275: ELSE null
168276: END source_meaning
168277: FROM xla_events_gt xet
168278: , AP_PAYMENT_EXTRACT_HEADER_V h2
168279: , AP_SYSTEM_PARAMETERS_EXTRACT_V h3
168280: , fnd_lookup_values fvl15
168281: , fnd_lookup_values fvl19
168538: WHEN 17 THEN fvl97.meaning
168539:
168540: ELSE null
168541: END source_meaning
168542: FROM xla_events_gt xet
168543: , AP_PAYMENT_EXTRACT_DETAILS_V l1
168544: , ZX_AP_DEF_TAX_EXTRACT_V l4
168545: , ZX_AP_TAX_JRNL_LINE_DESC_V l5
168546: , fnd_lookup_values fvl33
168892: , h2.AC_DOC_CATEGORY_CODE source_170
168893: , h2.PAYMENT_DOCUMENT_SEQUENCE_ID source_171
168894: , h2.TRANSAC_REVERSAL_FLAG source_172
168895: , fvl172.meaning source_172_meaning
168896: FROM xla_events_gt xet
168897: , AP_PAYMENT_EXTRACT_HEADER_V h2
168898: , AP_SYSTEM_PARAMETERS_EXTRACT_V h3
168899: , fnd_lookup_values fvl15
168900: , fnd_lookup_values fvl19
168993: , l1.INV_EXCHANGE_RATE source_137
168994: , l1.INV_EXCHANGE_RATE_TYPE source_138
168995: , l1.INV_PMT_BASE_AMT_DIFF source_150
168996: , l1.INV_PMT_GAIN_LOSS_INDICATOR source_155
168997: FROM xla_events_gt xet
168998: , AP_PAYMENT_EXTRACT_DETAILS_V l1
168999: , ZX_AP_DEF_TAX_EXTRACT_V l4
169000: , ZX_AP_TAX_JRNL_LINE_DESC_V l5
169001: , fnd_lookup_values fvl33
170905: ,p_level => C_LEVEL_STATEMENT
170906: ,p_module => l_log_module);
170907:
170908: trace
170909: (p_msg => '# of events in xla_events_gt: '
170910: ||xla_context_pkg.get_event_count_context
170911: ,p_level => C_LEVEL_STATEMENT
170912: ,p_module => l_log_module);
170913: