[Home] [Help]
96788: WHEN 20 THEN fvl117.meaning
96789:
96790: ELSE null
96791: END source_meaning
96792: FROM xla_events_gt xet
96793: , AP_PAYMENT_EXTRACT_HEADER_V h2
96794: , AP_SYSTEM_PARAMETERS_EXTRACT_V h3
96795: , fnd_lookup_values fvl16
96796: , fnd_lookup_values fvl42
96987: WHEN 13 THEN fvl64.meaning
96988:
96989: ELSE null
96990: END source_meaning
96991: FROM xla_events_gt xet
96992: , AP_PAYMENT_EXTRACT_DETAILS_V l1
96993: , fnd_lookup_values fvl51
96994: , fnd_lookup_values fvl64
96995: , (select rownum r from all_objects where rownum <= 17 and owner = p_apps_owner)
97289: , h2.AC_EXCHANGE_RATE source_122
97290: , h2.AC_EXCHANGE_RATE_TYPE source_123
97291: , h2.AC_DOC_CATEGORY_CODE source_156
97292: , h2.PAYMENT_DOCUMENT_SEQUENCE_ID source_157
97293: FROM xla_events_gt xet
97294: , AP_PAYMENT_EXTRACT_HEADER_V h2
97295: , AP_SYSTEM_PARAMETERS_EXTRACT_V h3
97296: , fnd_lookup_values fvl16
97297: , fnd_lookup_values fvl42
97364: , l1.APHD_REV_PAY_HIST_DIST_ID source_68
97365: , l1.APHD_MATURED_BASE_AMOUNT source_124
97366: , l1.PMT_MAT_BASE_AMT_DIFF source_135
97367: , l1.PMT_MAT_GAIN_LOSS_INDICATOR source_140
97368: FROM xla_events_gt xet
97369: , AP_PAYMENT_EXTRACT_DETAILS_V l1
97370: , fnd_lookup_values fvl51
97371: , fnd_lookup_values fvl64
97372: WHERE xet.event_id between x_first_event_id and x_last_event_id
98896: WHEN 38 THEN fvl159.meaning
98897:
98898: ELSE null
98899: END source_meaning
98900: FROM xla_events_gt xet
98901: , AP_PAYMENT_EXTRACT_HEADER_V h2
98902: , AP_SYSTEM_PARAMETERS_EXTRACT_V h4
98903: , fnd_lookup_values fvl15
98904: , fnd_lookup_values fvl16
99204: WHEN 31 THEN fvl112.meaning
99205:
99206: ELSE null
99207: END source_meaning
99208: FROM xla_events_gt xet
99209: , AP_PAYMENT_EXTRACT_DETAILS_V l1
99210: , AP_PO_HEADERS_EXTRACT_V l3
99211: , ZX_AP_DEF_TAX_EXTRACT_V l5
99212: , ZX_AP_TAX_JRNL_LINE_DESC_V l6
99611: , h2.AC_DOC_CATEGORY_CODE source_156
99612: , h2.PAYMENT_DOCUMENT_SEQUENCE_ID source_157
99613: , h2.TRANSAC_REVERSAL_FLAG source_159
99614: , fvl159.meaning source_159_meaning
99615: FROM xla_events_gt xet
99616: , AP_PAYMENT_EXTRACT_HEADER_V h2
99617: , AP_SYSTEM_PARAMETERS_EXTRACT_V h4
99618: , fnd_lookup_values fvl15
99619: , fnd_lookup_values fvl16
99731: , l1.AI_INVOICE_TYPE_PAID source_112
99732: , fvl112.meaning source_112_meaning
99733: , l1.BF_RETAINED_INV_DIST_ID_PMT source_153
99734: , l1.BF_RETAINED_INV_ID_PMT source_154
99735: FROM xla_events_gt xet
99736: , AP_PAYMENT_EXTRACT_DETAILS_V l1
99737: , AP_PO_HEADERS_EXTRACT_V l3
99738: , ZX_AP_DEF_TAX_EXTRACT_V l5
99739: , ZX_AP_TAX_JRNL_LINE_DESC_V l6
102245: WHEN 11 THEN fvl42.meaning
102246:
102247: ELSE null
102248: END source_meaning
102249: FROM xla_events_gt xet
102250: , AP_INVOICE_EXTRACT_HEADER_V h1
102251: , AP_SYSTEM_PARAMETERS_EXTRACT_V h4
102252: , fnd_lookup_values fvl16
102253: , fnd_lookup_values fvl42
102662: WHEN 59 THEN fvl148.meaning
102663:
102664: ELSE null
102665: END source_meaning
102666: FROM xla_events_gt xet
102667: , AP_PO_HEADERS_EXTRACT_V l2
102668: , AP_PREPAYAPP_EXTRACT_DETAILS_V l3
102669: , ZX_AP_DEF_TAX_EXTRACT_V l5
102670: , ZX_AP_TAX_JRNL_LINE_DESC_V l6
103059: , h1.INV_EXCHANGE_DATE source_131
103060: , h1.INV_EXCHANGE_RATE source_132
103061: , h1.INV_EXCHANGE_RATE_TYPE source_133
103062: , h1.INV_DOC_SEQUENCE_IDENTIFIER source_160
103063: FROM xla_events_gt xet
103064: , AP_INVOICE_EXTRACT_HEADER_V h1
103065: , AP_SYSTEM_PARAMETERS_EXTRACT_V h4
103066: , fnd_lookup_values fvl16
103067: , fnd_lookup_values fvl42
103176: , l3.AI_RECIPIENT_INV_TYPE source_148
103177: , fvl148.meaning source_148_meaning
103178: , l3.BF_RET_DIST_ASSOC_TO_PP_RECIP source_149
103179: , l3.BF_RET_INV_ASSOC_TO_PP_RECIP source_150
103180: FROM xla_events_gt xet
103181: , AP_PO_HEADERS_EXTRACT_V l2
103182: , AP_PREPAYAPP_EXTRACT_DETAILS_V l3
103183: , ZX_AP_DEF_TAX_EXTRACT_V l5
103184: , ZX_AP_TAX_JRNL_LINE_DESC_V l6
106464: WHEN 34 THEN fvl117.meaning
106465:
106466: ELSE null
106467: END source_meaning
106468: FROM xla_events_gt xet
106469: , AP_PAYMENT_EXTRACT_HEADER_V h2
106470: , AP_SYSTEM_PARAMETERS_EXTRACT_V h4
106471: , fnd_lookup_values fvl15
106472: , fnd_lookup_values fvl16
106778: WHEN 37 THEN fvl155.meaning
106779:
106780: ELSE null
106781: END source_meaning
106782: FROM xla_events_gt xet
106783: , AP_PAYMENT_EXTRACT_DETAILS_V l1
106784: , AP_PO_HEADERS_EXTRACT_V l3
106785: , ZX_AP_DEF_TAX_EXTRACT_V l5
106786: , fnd_lookup_values fvl19
107198: , h2.AC_EXCHANGE_RATE source_122
107199: , h2.AC_EXCHANGE_RATE_TYPE source_123
107200: , h2.AC_DOC_CATEGORY_CODE source_156
107201: , h2.PAYMENT_DOCUMENT_SEQUENCE_ID source_157
107202: FROM xla_events_gt xet
107203: , AP_PAYMENT_EXTRACT_HEADER_V h2
107204: , AP_SYSTEM_PARAMETERS_EXTRACT_V h4
107205: , fnd_lookup_values fvl15
107206: , fnd_lookup_values fvl16
107308: , l1.BF_RETAINED_INV_DIST_ID_CLR source_151
107309: , l1.BF_RETAINED_INV_ID_CLR source_152
107310: , l1.AWT_AT_PMT_TIME source_155
107311: , fvl155.meaning source_155_meaning
107312: FROM xla_events_gt xet
107313: , AP_PAYMENT_EXTRACT_DETAILS_V l1
107314: , AP_PO_HEADERS_EXTRACT_V l3
107315: , ZX_AP_DEF_TAX_EXTRACT_V l5
107316: , fnd_lookup_values fvl19
109968: WHEN 28 THEN fvl159.meaning
109969:
109970: ELSE null
109971: END source_meaning
109972: FROM xla_events_gt xet
109973: , AP_PAYMENT_EXTRACT_HEADER_V h2
109974: , AP_SYSTEM_PARAMETERS_EXTRACT_V h4
109975: , fnd_lookup_values fvl15
109976: , fnd_lookup_values fvl16
110230: WHEN 26 THEN fvl111.meaning
110231:
110232: ELSE null
110233: END source_meaning
110234: FROM xla_events_gt xet
110235: , AP_PAYMENT_EXTRACT_DETAILS_V l1
110236: , AP_PO_HEADERS_EXTRACT_V l3
110237: , ZX_AP_DEF_TAX_EXTRACT_V l5
110238: , ZX_AP_TAX_JRNL_LINE_DESC_V l6
110583: , h2.AC_DOC_CATEGORY_CODE source_156
110584: , h2.PAYMENT_DOCUMENT_SEQUENCE_ID source_157
110585: , h2.TRANSAC_REVERSAL_FLAG source_159
110586: , fvl159.meaning source_159_meaning
110587: FROM xla_events_gt xet
110588: , AP_PAYMENT_EXTRACT_HEADER_V h2
110589: , AP_SYSTEM_PARAMETERS_EXTRACT_V h4
110590: , fnd_lookup_values fvl15
110591: , fnd_lookup_values fvl16
110685: , l1.BUS_FLOW_INV_ID source_76
110686: , l6.REC_NREC_TAX_DIST_ID source_77
110687: , l1.POD_ACCRUE_ON_RECEIPT_FLAG source_111
110688: , fvl111.meaning source_111_meaning
110689: FROM xla_events_gt xet
110690: , AP_PAYMENT_EXTRACT_DETAILS_V l1
110691: , AP_PO_HEADERS_EXTRACT_V l3
110692: , ZX_AP_DEF_TAX_EXTRACT_V l5
110693: , ZX_AP_TAX_JRNL_LINE_DESC_V l6
112776: ,p_level => C_LEVEL_STATEMENT
112777: ,p_module => l_log_module);
112778:
112779: trace
112780: (p_msg => '# of events in xla_events_gt: '
112781: ||xla_context_pkg.get_event_count_context
112782: ,p_level => C_LEVEL_STATEMENT
112783: ,p_module => l_log_module);
112784: