[Home] [Help]
118608:
118609: ELSE null
118610: END source_value
118611: , null source_meaning
118612: FROM xla_events_gt xet
118613: , AP_INVOICE_EXTRACT_HEADER_V h2
118614: ,(select rownum r from all_objects where rownum <= 5 and owner = p_apps_owner)
118615: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
118616: AND xet.event_class_code = C_EVENT_CLASS_CODE
118781:
118782: ELSE null
118783: END source_value
118784: , null source_meaning
118785: FROM xla_events_gt xet
118786: , AP_INVOICE_EXTRACT_DETAILS_V l1
118787: , ZX_AP_DEF_TAX_EXTRACT_V l3
118788: , ZX_AP_TAX_JRNL_LINE_DESC_V l4
118789: , (select rownum r from all_objects where rownum <= 16 and owner = p_apps_owner)
119002: , h2.AI_INVOICE_CURRENCY_CODE source_80
119003: , h2.INV_DOC_SEQUENCE_CATEGORY source_152
119004: , h2.INV_DOC_SEQUENCE_IDENTIFIER source_153
119005: , h2.INV_DOC_SEQUENCE_VALUE source_154
119006: FROM xla_events_gt xet
119007: , AP_INVOICE_EXTRACT_HEADER_V h2
119008: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
119009: and xet.event_class_code = C_EVENT_CLASS_CODE
119010: and xet.event_status_code <> 'N' AND h2.event_id = xet.event_id
119058: , l1.UPG_CR_ENC_TYPE_ID source_96
119059: , l1.UPG_DR_ENC_TYPE_ID source_97
119060: , l1.AID_INVOICE_DIST_ID source_156
119061: , l1.AID_PARENT_REVERSAL_ID source_157
119062: FROM xla_events_gt xet
119063: , AP_INVOICE_EXTRACT_DETAILS_V l1
119064: , ZX_AP_DEF_TAX_EXTRACT_V l3
119065: , ZX_AP_TAX_JRNL_LINE_DESC_V l4
119066: WHERE xet.event_id between x_first_event_id and x_last_event_id
119865:
119866: ELSE null
119867: END source_value
119868: , null source_meaning
119869: FROM xla_events_gt xet
119870: , AP_INVOICE_EXTRACT_HEADER_V h2
119871: ,(select rownum r from all_objects where rownum <= 5 and owner = p_apps_owner)
119872: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
119873: AND xet.event_class_code = C_EVENT_CLASS_CODE
120038:
120039: ELSE null
120040: END source_value
120041: , null source_meaning
120042: FROM xla_events_gt xet
120043: , AP_INVOICE_EXTRACT_DETAILS_V l1
120044: , ZX_AP_DEF_TAX_EXTRACT_V l3
120045: , ZX_AP_TAX_JRNL_LINE_DESC_V l4
120046: , (select rownum r from all_objects where rownum <= 16 and owner = p_apps_owner)
120259: , h2.AI_INVOICE_CURRENCY_CODE source_80
120260: , h2.INV_DOC_SEQUENCE_CATEGORY source_152
120261: , h2.INV_DOC_SEQUENCE_IDENTIFIER source_153
120262: , h2.INV_DOC_SEQUENCE_VALUE source_154
120263: FROM xla_events_gt xet
120264: , AP_INVOICE_EXTRACT_HEADER_V h2
120265: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
120266: and xet.event_class_code = C_EVENT_CLASS_CODE
120267: and xet.event_status_code <> 'N' AND h2.event_id = xet.event_id
120315: , l1.UPG_CR_ENC_TYPE_ID source_96
120316: , l1.UPG_DR_ENC_TYPE_ID source_97
120317: , l1.AID_INVOICE_DIST_ID source_156
120318: , l1.AID_PARENT_REVERSAL_ID source_157
120319: FROM xla_events_gt xet
120320: , AP_INVOICE_EXTRACT_DETAILS_V l1
120321: , ZX_AP_DEF_TAX_EXTRACT_V l3
120322: , ZX_AP_TAX_JRNL_LINE_DESC_V l4
120323: WHERE xet.event_id between x_first_event_id and x_last_event_id
121213: WHEN 15 THEN fvl110.meaning
121214:
121215: ELSE null
121216: END source_meaning
121217: FROM xla_events_gt xet
121218: , AP_PAYMENT_EXTRACT_HEADER_V h2
121219: , AP_SYSTEM_PARAMETERS_EXTRACT_V h3
121220: , fnd_lookup_values fvl4
121221: , fnd_lookup_values fvl30
121412: WHEN 13 THEN fvl53.meaning
121413:
121414: ELSE null
121415: END source_meaning
121416: FROM xla_events_gt xet
121417: , AP_PAYMENT_EXTRACT_DETAILS_V l1
121418: , fnd_lookup_values fvl39
121419: , fnd_lookup_values fvl53
121420: , (select rownum r from all_objects where rownum <= 17 and owner = p_apps_owner)
121702: , h2.AC_EXCHANGE_RATE_TYPE source_116
121703: , h2.AC_DOC_CATEGORY_CODE source_158
121704: , h2.PAYMENT_DOCUMENT_SEQUENCE_ID source_159
121705: , h2.AC_DOC_SEQUENCE_VALUE source_160
121706: FROM xla_events_gt xet
121707: , AP_PAYMENT_EXTRACT_HEADER_V h2
121708: , AP_SYSTEM_PARAMETERS_EXTRACT_V h3
121709: , fnd_lookup_values fvl4
121710: , fnd_lookup_values fvl30
121777: , l1.APHD_REV_PAY_HIST_DIST_ID source_57
121778: , l1.APHD_MATURED_BASE_AMOUNT source_117
121779: , l1.PMT_MAT_BASE_AMT_DIFF source_128
121780: , l1.PMT_MAT_GAIN_LOSS_INDICATOR source_133
121781: FROM xla_events_gt xet
121782: , AP_PAYMENT_EXTRACT_DETAILS_V l1
121783: , fnd_lookup_values fvl39
121784: , fnd_lookup_values fvl53
121785: WHERE xet.event_id between x_first_event_id and x_last_event_id
123111:
123112: ELSE null
123113: END source_value
123114: , null source_meaning
123115: FROM xla_events_gt xet
123116: , AP_INVOICE_EXTRACT_HEADER_V h2
123117: ,(select rownum r from all_objects where rownum <= 5 and owner = p_apps_owner)
123118: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
123119: AND xet.event_class_code = C_EVENT_CLASS_CODE
123284:
123285: ELSE null
123286: END source_value
123287: , null source_meaning
123288: FROM xla_events_gt xet
123289: , AP_INVOICE_EXTRACT_DETAILS_V l1
123290: , ZX_AP_DEF_TAX_EXTRACT_V l3
123291: , ZX_AP_TAX_JRNL_LINE_DESC_V l4
123292: , (select rownum r from all_objects where rownum <= 16 and owner = p_apps_owner)
123505: , h2.AI_INVOICE_CURRENCY_CODE source_80
123506: , h2.INV_DOC_SEQUENCE_CATEGORY source_152
123507: , h2.INV_DOC_SEQUENCE_IDENTIFIER source_153
123508: , h2.INV_DOC_SEQUENCE_VALUE source_154
123509: FROM xla_events_gt xet
123510: , AP_INVOICE_EXTRACT_HEADER_V h2
123511: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
123512: and xet.event_class_code = C_EVENT_CLASS_CODE
123513: and xet.event_status_code <> 'N' AND h2.event_id = xet.event_id
123561: , l1.UPG_CR_ENC_TYPE_ID source_96
123562: , l1.UPG_DR_ENC_TYPE_ID source_97
123563: , l1.AID_INVOICE_DIST_ID source_156
123564: , l1.AID_PARENT_REVERSAL_ID source_157
123565: FROM xla_events_gt xet
123566: , AP_INVOICE_EXTRACT_DETAILS_V l1
123567: , ZX_AP_DEF_TAX_EXTRACT_V l3
123568: , ZX_AP_TAX_JRNL_LINE_DESC_V l4
123569: WHERE xet.event_id between x_first_event_id and x_last_event_id
124429:
124430: ELSE null
124431: END source_value
124432: , null source_meaning
124433: FROM xla_events_gt xet
124434: , PA_XLA_BC_PKT_AP_DETAIL_V l1
124435: , (select rownum r from all_objects where rownum <= 17 and owner = p_apps_owner)
124436: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
124437: AND xet.event_class_code = C_EVENT_CLASS_CODE
124635: ,xet.reference_date_3
124636: ,xet.reference_date_4
124637: ,xet.event_created_by
124638: ,xet.budgetary_control_flag
124639: FROM xla_events_gt xet
124640: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
124641: and xet.event_class_code = C_EVENT_CLASS_CODE
124642: and xet.event_status_code <> 'N'
124643: ORDER BY event_id
124690: , l1.AP_SECOND_DIST_ID source_171
124691: , l1.ACCT_REV_DISTRIBUTION_TYPE source_172
124692: , l1.ENC_UPG_CR_ENC_TYPE_ID source_173
124693: , l1.ENC_UPG_DR_ENC_TYPE_ID source_174
124694: FROM xla_events_gt xet
124695: , PA_XLA_BC_PKT_AP_DETAIL_V l1
124696: WHERE xet.event_id between x_first_event_id and x_last_event_id
124697: and xet.event_date between p_pad_start_date and p_pad_end_date
124698: and xet.event_class_code = C_EVENT_CLASS_CODE
125642: WHEN 35 THEN fvl175.meaning
125643:
125644: ELSE null
125645: END source_meaning
125646: FROM xla_events_gt xet
125647: , AP_PAYMENT_EXTRACT_HEADER_V h2
125648: , AP_SYSTEM_PARAMETERS_EXTRACT_V h4
125649: , fnd_lookup_values fvl3
125650: , fnd_lookup_values fvl4
125981: WHEN 33 THEN fvl104.meaning
125982:
125983: ELSE null
125984: END source_meaning
125985: FROM xla_events_gt xet
125986: , AP_PAYMENT_EXTRACT_DETAILS_V l1
125987: , AP_PO_HEADERS_EXTRACT_V l3
125988: , ZX_AP_DEF_TAX_EXTRACT_V l5
125989: , ZX_AP_TAX_JRNL_LINE_DESC_V l6
126397: , h2.PAYMENT_DOCUMENT_SEQUENCE_ID source_159
126398: , h2.AC_DOC_SEQUENCE_VALUE source_160
126399: , h2.TRANSAC_REVERSAL_FLAG source_175
126400: , fvl175.meaning source_175_meaning
126401: FROM xla_events_gt xet
126402: , AP_PAYMENT_EXTRACT_HEADER_V h2
126403: , AP_SYSTEM_PARAMETERS_EXTRACT_V h4
126404: , fnd_lookup_values fvl3
126405: , fnd_lookup_values fvl4
126528: , l1.APHD_INV_BASE_QTY_VARIANCE source_142
126529: , l1.APHD_QUANTITY_VARIANCE source_143
126530: , l1.BF_RETAINED_INV_DIST_ID_PMT source_149
126531: , l1.BF_RETAINED_INV_ID_PMT source_150
126532: FROM xla_events_gt xet
126533: , AP_PAYMENT_EXTRACT_DETAILS_V l1
126534: , AP_PO_HEADERS_EXTRACT_V l3
126535: , ZX_AP_DEF_TAX_EXTRACT_V l5
126536: , ZX_AP_TAX_JRNL_LINE_DESC_V l6
129651: WHEN 13 THEN fvl102.meaning
129652:
129653: ELSE null
129654: END source_meaning
129655: FROM xla_events_gt xet
129656: , AP_INVOICE_EXTRACT_HEADER_V h1
129657: , AP_SYSTEM_PARAMETERS_EXTRACT_V h4
129658: , fnd_lookup_values fvl4
129659: , fnd_lookup_values fvl30
130084: WHEN 61 THEN fvl144.meaning
130085:
130086: ELSE null
130087: END source_meaning
130088: FROM xla_events_gt xet
130089: , AP_PO_HEADERS_EXTRACT_V l2
130090: , AP_PREPAYAPP_EXTRACT_DETAILS_V l3
130091: , ZX_AP_DEF_TAX_EXTRACT_V l5
130092: , ZX_AP_TAX_JRNL_LINE_DESC_V l6
130484: , h1.INV_EXCHANGE_RATE_TYPE source_126
130485: , h1.INV_DOC_SEQUENCE_CATEGORY source_152
130486: , h1.INV_DOC_SEQUENCE_IDENTIFIER source_153
130487: , h1.INV_DOC_SEQUENCE_VALUE source_154
130488: FROM xla_events_gt xet
130489: , AP_INVOICE_EXTRACT_HEADER_V h1
130490: , AP_SYSTEM_PARAMETERS_EXTRACT_V h4
130491: , fnd_lookup_values fvl4
130492: , fnd_lookup_values fvl30
130609: , l3.AI_RECIPIENT_INV_TYPE source_144
130610: , fvl144.meaning source_144_meaning
130611: , l3.BF_RET_DIST_ASSOC_TO_PP_RECIP source_145
130612: , l3.BF_RET_INV_ASSOC_TO_PP_RECIP source_146
130613: FROM xla_events_gt xet
130614: , AP_PO_HEADERS_EXTRACT_V l2
130615: , AP_PREPAYAPP_EXTRACT_DETAILS_V l3
130616: , ZX_AP_DEF_TAX_EXTRACT_V l5
130617: , ZX_AP_TAX_JRNL_LINE_DESC_V l6
133766:
133767: ELSE null
133768: END source_value
133769: , null source_meaning
133770: FROM xla_events_gt xet
133771: , AP_INVOICE_EXTRACT_HEADER_V h2
133772: ,(select rownum r from all_objects where rownum <= 5 and owner = p_apps_owner)
133773: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
133774: AND xet.event_class_code = C_EVENT_CLASS_CODE
133939:
133940: ELSE null
133941: END source_value
133942: , null source_meaning
133943: FROM xla_events_gt xet
133944: , AP_INVOICE_EXTRACT_DETAILS_V l1
133945: , ZX_AP_DEF_TAX_EXTRACT_V l3
133946: , ZX_AP_TAX_JRNL_LINE_DESC_V l4
133947: , (select rownum r from all_objects where rownum <= 16 and owner = p_apps_owner)
134160: , h2.AI_INVOICE_CURRENCY_CODE source_80
134161: , h2.INV_DOC_SEQUENCE_CATEGORY source_152
134162: , h2.INV_DOC_SEQUENCE_IDENTIFIER source_153
134163: , h2.INV_DOC_SEQUENCE_VALUE source_154
134164: FROM xla_events_gt xet
134165: , AP_INVOICE_EXTRACT_HEADER_V h2
134166: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
134167: and xet.event_class_code = C_EVENT_CLASS_CODE
134168: and xet.event_status_code <> 'N' AND h2.event_id = xet.event_id
134216: , l1.UPG_CR_ENC_TYPE_ID source_96
134217: , l1.UPG_DR_ENC_TYPE_ID source_97
134218: , l1.AID_INVOICE_DIST_ID source_156
134219: , l1.AID_PARENT_REVERSAL_ID source_157
134220: FROM xla_events_gt xet
134221: , AP_INVOICE_EXTRACT_DETAILS_V l1
134222: , ZX_AP_DEF_TAX_EXTRACT_V l3
134223: , ZX_AP_TAX_JRNL_LINE_DESC_V l4
134224: WHERE xet.event_id between x_first_event_id and x_last_event_id
135084:
135085: ELSE null
135086: END source_value
135087: , null source_meaning
135088: FROM xla_events_gt xet
135089: , PA_XLA_BC_PKT_AP_DETAIL_V l1
135090: , (select rownum r from all_objects where rownum <= 17 and owner = p_apps_owner)
135091: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
135092: AND xet.event_class_code = C_EVENT_CLASS_CODE
135290: ,xet.reference_date_3
135291: ,xet.reference_date_4
135292: ,xet.event_created_by
135293: ,xet.budgetary_control_flag
135294: FROM xla_events_gt xet
135295: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
135296: and xet.event_class_code = C_EVENT_CLASS_CODE
135297: and xet.event_status_code <> 'N'
135298: ORDER BY event_id
135345: , l1.AP_SECOND_DIST_ID source_171
135346: , l1.ACCT_REV_DISTRIBUTION_TYPE source_172
135347: , l1.ENC_UPG_CR_ENC_TYPE_ID source_173
135348: , l1.ENC_UPG_DR_ENC_TYPE_ID source_174
135349: FROM xla_events_gt xet
135350: , PA_XLA_BC_PKT_AP_DETAIL_V l1
135351: WHERE xet.event_id between x_first_event_id and x_last_event_id
135352: and xet.event_date between p_pad_start_date and p_pad_end_date
135353: and xet.event_class_code = C_EVENT_CLASS_CODE
136196:
136197: ELSE null
136198: END source_value
136199: , null source_meaning
136200: FROM xla_events_gt xet
136201: , PA_XLA_BC_PKT_AP_DETAIL_V l1
136202: , (select rownum r from all_objects where rownum <= 17 and owner = p_apps_owner)
136203: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
136204: AND xet.event_class_code = C_EVENT_CLASS_CODE
136402: ,xet.reference_date_3
136403: ,xet.reference_date_4
136404: ,xet.event_created_by
136405: ,xet.budgetary_control_flag
136406: FROM xla_events_gt xet
136407: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
136408: and xet.event_class_code = C_EVENT_CLASS_CODE
136409: and xet.event_status_code <> 'N'
136410: ORDER BY event_id
136457: , l1.AP_SECOND_DIST_ID source_171
136458: , l1.ACCT_REV_DISTRIBUTION_TYPE source_172
136459: , l1.ENC_UPG_CR_ENC_TYPE_ID source_173
136460: , l1.ENC_UPG_DR_ENC_TYPE_ID source_174
136461: FROM xla_events_gt xet
136462: , PA_XLA_BC_PKT_AP_DETAIL_V l1
136463: WHERE xet.event_id between x_first_event_id and x_last_event_id
136464: and xet.event_date between p_pad_start_date and p_pad_end_date
136465: and xet.event_class_code = C_EVENT_CLASS_CODE
137416: WHEN 30 THEN fvl110.meaning
137417:
137418: ELSE null
137419: END source_meaning
137420: FROM xla_events_gt xet
137421: , AP_PAYMENT_EXTRACT_HEADER_V h2
137422: , AP_SYSTEM_PARAMETERS_EXTRACT_V h4
137423: , fnd_lookup_values fvl3
137424: , fnd_lookup_values fvl4
137781: WHEN 46 THEN fvl151.meaning
137782:
137783: ELSE null
137784: END source_meaning
137785: FROM xla_events_gt xet
137786: , AP_PAYMENT_EXTRACT_DETAILS_V l1
137787: , AP_PO_HEADERS_EXTRACT_V l3
137788: , ZX_AP_DEF_TAX_EXTRACT_V l5
137789: , fnd_lookup_values fvl7
138218: , h2.AC_EXCHANGE_RATE_TYPE source_116
138219: , h2.AC_DOC_CATEGORY_CODE source_158
138220: , h2.PAYMENT_DOCUMENT_SEQUENCE_ID source_159
138221: , h2.AC_DOC_SEQUENCE_VALUE source_160
138222: FROM xla_events_gt xet
138223: , AP_PAYMENT_EXTRACT_HEADER_V h2
138224: , AP_SYSTEM_PARAMETERS_EXTRACT_V h4
138225: , fnd_lookup_values fvl3
138226: , fnd_lookup_values fvl4
138343: , l1.BF_RETAINED_INV_DIST_ID_CLR source_147
138344: , l1.BF_RETAINED_INV_ID_CLR source_148
138345: , l1.AWT_AT_PMT_TIME source_151
138346: , fvl151.meaning source_151_meaning
138347: FROM xla_events_gt xet
138348: , AP_PAYMENT_EXTRACT_DETAILS_V l1
138349: , AP_PO_HEADERS_EXTRACT_V l3
138350: , ZX_AP_DEF_TAX_EXTRACT_V l5
138351: , fnd_lookup_values fvl7
141564: WHEN 25 THEN fvl175.meaning
141565:
141566: ELSE null
141567: END source_meaning
141568: FROM xla_events_gt xet
141569: , AP_PAYMENT_EXTRACT_HEADER_V h2
141570: , AP_SYSTEM_PARAMETERS_EXTRACT_V h4
141571: , fnd_lookup_values fvl3
141572: , fnd_lookup_values fvl4
141843: WHEN 28 THEN fvl104.meaning
141844:
141845: ELSE null
141846: END source_meaning
141847: FROM xla_events_gt xet
141848: , AP_PAYMENT_EXTRACT_DETAILS_V l1
141849: , AP_PO_HEADERS_EXTRACT_V l3
141850: , ZX_AP_DEF_TAX_EXTRACT_V l5
141851: , ZX_AP_TAX_JRNL_LINE_DESC_V l6
142205: , h2.PAYMENT_DOCUMENT_SEQUENCE_ID source_159
142206: , h2.AC_DOC_SEQUENCE_VALUE source_160
142207: , h2.TRANSAC_REVERSAL_FLAG source_175
142208: , fvl175.meaning source_175_meaning
142209: FROM xla_events_gt xet
142210: , AP_PAYMENT_EXTRACT_HEADER_V h2
142211: , AP_SYSTEM_PARAMETERS_EXTRACT_V h4
142212: , fnd_lookup_values fvl3
142213: , fnd_lookup_values fvl4
142316: , l1.AI_INVOICE_TYPE_PAID source_101
142317: , fvl101.meaning source_101_meaning
142318: , l1.AID_ENCUMBERED_FLAG source_104
142319: , fvl104.meaning source_104_meaning
142320: FROM xla_events_gt xet
142321: , AP_PAYMENT_EXTRACT_DETAILS_V l1
142322: , AP_PO_HEADERS_EXTRACT_V l3
142323: , ZX_AP_DEF_TAX_EXTRACT_V l5
142324: , ZX_AP_TAX_JRNL_LINE_DESC_V l6
145209: ,p_level => C_LEVEL_STATEMENT
145210: ,p_module => l_log_module);
145211:
145212: trace
145213: (p_msg => '# of events in xla_events_gt: '
145214: ||xla_context_pkg.get_event_count_context
145215: ,p_level => C_LEVEL_STATEMENT
145216: ,p_module => l_log_module);
145217: