APPS.XLA_00200_AAD_S_000006_PKG dependencies on XLA_EVENTS_GT

Line 182676: FROM xla_events_gt xet

182672: WHEN 16 THEN fvl159.meaning
182673:
182674: ELSE null
182675: END source_meaning
182676: FROM xla_events_gt xet
182677: , AP_INVOICE_EXTRACT_HEADER_V h2
182678: , AP_SYSTEM_PARAMETERS_EXTRACT_V h4
182679: , fnd_lookup_values fvl3
182680: , fnd_lookup_values fvl35

Line 183069: FROM xla_events_gt xet

183065: WHEN 50 THEN fvl135.meaning
183066:
183067: ELSE null
183068: END source_meaning
183069: FROM xla_events_gt xet
183070: , AP_INVOICE_EXTRACT_DETAILS_V l1
183071: , AP_PO_HEADERS_EXTRACT_V l3
183072: , ZX_AP_DEF_TAX_EXTRACT_V l5
183073: , ZX_AP_TAX_JRNL_LINE_DESC_V l6

Line 183453: FROM xla_events_gt xet

183449: , fvl159.meaning source_159_meaning
183450: , h2.INV_DOC_SEQUENCE_CATEGORY source_165
183451: , h2.INV_DOC_SEQUENCE_IDENTIFIER source_166
183452: , h2.INV_DOC_SEQUENCE_VALUE source_167
183453: FROM xla_events_gt xet
183454: , AP_INVOICE_EXTRACT_HEADER_V h2
183455: , AP_SYSTEM_PARAMETERS_EXTRACT_V h4
183456: , fnd_lookup_values fvl3
183457: , fnd_lookup_values fvl35

Line 183574: FROM xla_events_gt xet

183570: , l1.ENCUMBRANCE_AMOUNT source_143
183571: , l1.ENCUMBRANCE_BASE_AMOUNT source_144
183572: , l1.AID_QUANTITY_VARIANCE source_161
183573: , l1.AID_BASE_QUANTITY_VARIANCE source_162
183574: FROM xla_events_gt xet
183575: , AP_INVOICE_EXTRACT_DETAILS_V l1
183576: , AP_PO_HEADERS_EXTRACT_V l3
183577: , ZX_AP_DEF_TAX_EXTRACT_V l5
183578: , ZX_AP_TAX_JRNL_LINE_DESC_V l6

Line 186900: FROM xla_events_gt xet

186896: WHEN 12 THEN fvl86.meaning
186897:
186898: ELSE null
186899: END source_meaning
186900: FROM xla_events_gt xet
186901: , AP_INVOICE_EXTRACT_HEADER_V h2
186902: , AP_SYSTEM_PARAMETERS_EXTRACT_V h4
186903: , fnd_lookup_values fvl3
186904: , fnd_lookup_values fvl35

Line 187283: FROM xla_events_gt xet

187279: WHEN 49 THEN fvl135.meaning
187280:
187281: ELSE null
187282: END source_meaning
187283: FROM xla_events_gt xet
187284: , AP_INVOICE_EXTRACT_DETAILS_V l1
187285: , AP_PO_HEADERS_EXTRACT_V l3
187286: , ZX_AP_DEF_TAX_EXTRACT_V l5
187287: , ZX_AP_TAX_JRNL_LINE_DESC_V l6

Line 187660: FROM xla_events_gt xet

187656: , h2.INV_EXCHANGE_RATE_TYPE source_138
187657: , h2.INV_DOC_SEQUENCE_CATEGORY source_165
187658: , h2.INV_DOC_SEQUENCE_IDENTIFIER source_166
187659: , h2.INV_DOC_SEQUENCE_VALUE source_167
187660: FROM xla_events_gt xet
187661: , AP_INVOICE_EXTRACT_HEADER_V h2
187662: , AP_SYSTEM_PARAMETERS_EXTRACT_V h4
187663: , fnd_lookup_values fvl3
187664: , fnd_lookup_values fvl35

Line 187775: FROM xla_events_gt xet

187771: , l1.ENCUMBRANCE_AMOUNT source_143
187772: , l1.ENCUMBRANCE_BASE_AMOUNT source_144
187773: , l1.AID_QUANTITY_VARIANCE source_161
187774: , l1.AID_BASE_QUANTITY_VARIANCE source_162
187775: FROM xla_events_gt xet
187776: , AP_INVOICE_EXTRACT_DETAILS_V l1
187777: , AP_PO_HEADERS_EXTRACT_V l3
187778: , ZX_AP_DEF_TAX_EXTRACT_V l5
187779: , ZX_AP_TAX_JRNL_LINE_DESC_V l6

Line 191076: FROM xla_events_gt xet

191072: WHEN 14 THEN fvl105.meaning
191073:
191074: ELSE null
191075: END source_meaning
191076: FROM xla_events_gt xet
191077: , AP_PAYMENT_EXTRACT_HEADER_V h2
191078: , AP_SYSTEM_PARAMETERS_EXTRACT_V h3
191079: , fnd_lookup_values fvl3
191080: , fnd_lookup_values fvl35

Line 191317: FROM xla_events_gt xet

191313: WHEN 23 THEN fvl130.meaning
191314:
191315: ELSE null
191316: END source_meaning
191317: FROM xla_events_gt xet
191318: , AP_PAYMENT_EXTRACT_DETAILS_V l1
191319: , ZX_AP_DEF_TAX_EXTRACT_V l4
191320: , fnd_lookup_values fvl21
191321: , fnd_lookup_values fvl68

Line 191636: FROM xla_events_gt xet

191632: , h2.AC_EXCHANGE_RATE_TYPE source_112
191633: , h2.AC_DOC_CATEGORY_CODE source_169
191634: , h2.PAYMENT_DOCUMENT_SEQUENCE_ID source_170
191635: , h2.AC_DOC_SEQUENCE_VALUE source_171
191636: FROM xla_events_gt xet
191637: , AP_PAYMENT_EXTRACT_HEADER_V h2
191638: , AP_SYSTEM_PARAMETERS_EXTRACT_V h3
191639: , fnd_lookup_values fvl3
191640: , fnd_lookup_values fvl35

Line 191721: FROM xla_events_gt xet

191717: , l4.DEF_REC_SETTLEMENT_OPTION_CODE source_130
191718: , fvl130.meaning source_130_meaning
191719: , l1.PMT_MAT_BASE_AMT_DIFF source_149
191720: , l1.PMT_MAT_GAIN_LOSS_INDICATOR source_156
191721: FROM xla_events_gt xet
191722: , AP_PAYMENT_EXTRACT_DETAILS_V l1
191723: , ZX_AP_DEF_TAX_EXTRACT_V l4
191724: , fnd_lookup_values fvl21
191725: , fnd_lookup_values fvl68

Line 193382: FROM xla_events_gt xet

193378: WHEN 16 THEN fvl159.meaning
193379:
193380: ELSE null
193381: END source_meaning
193382: FROM xla_events_gt xet
193383: , AP_INVOICE_EXTRACT_HEADER_V h2
193384: , AP_SYSTEM_PARAMETERS_EXTRACT_V h4
193385: , fnd_lookup_values fvl3
193386: , fnd_lookup_values fvl35

Line 193785: FROM xla_events_gt xet

193781: WHEN 50 THEN fvl135.meaning
193782:
193783: ELSE null
193784: END source_meaning
193785: FROM xla_events_gt xet
193786: , AP_INVOICE_EXTRACT_DETAILS_V l1
193787: , AP_PO_HEADERS_EXTRACT_V l3
193788: , ZX_AP_DEF_TAX_EXTRACT_V l5
193789: , ZX_AP_TAX_JRNL_LINE_DESC_V l6

Line 194173: FROM xla_events_gt xet

194169: , fvl159.meaning source_159_meaning
194170: , h2.INV_DOC_SEQUENCE_CATEGORY source_165
194171: , h2.INV_DOC_SEQUENCE_IDENTIFIER source_166
194172: , h2.INV_DOC_SEQUENCE_VALUE source_167
194173: FROM xla_events_gt xet
194174: , AP_INVOICE_EXTRACT_HEADER_V h2
194175: , AP_SYSTEM_PARAMETERS_EXTRACT_V h4
194176: , fnd_lookup_values fvl3
194177: , fnd_lookup_values fvl35

Line 194296: FROM xla_events_gt xet

194292: , l1.AID_QUANTITY_VARIANCE source_161
194293: , l1.AID_BASE_QUANTITY_VARIANCE source_162
194294: , l1.BUS_FLOW_RET_INV_DIST_ID source_163
194295: , l1.BUS_FLOW_RET_INV_ID source_164
194296: FROM xla_events_gt xet
194297: , AP_INVOICE_EXTRACT_DETAILS_V l1
194298: , AP_PO_HEADERS_EXTRACT_V l3
194299: , ZX_AP_DEF_TAX_EXTRACT_V l5
194300: , ZX_AP_TAX_JRNL_LINE_DESC_V l6

Line 197695: FROM xla_events_gt xet

197691:
197692: ELSE null
197693: END source_value
197694: , null source_meaning
197695: FROM xla_events_gt xet
197696: , PA_XLA_BC_PKT_AP_DETAIL_V l1
197697: , (select rownum r from all_objects where rownum <= 17 and owner = p_apps_owner)
197698: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
197699: AND xet.event_class_code = C_EVENT_CLASS_CODE

Line 197901: FROM xla_events_gt xet

197897: ,xet.reference_date_3
197898: ,xet.reference_date_4
197899: ,xet.event_created_by
197900: ,xet.budgetary_control_flag
197901: FROM xla_events_gt xet
197902: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
197903: and xet.event_class_code = C_EVENT_CLASS_CODE
197904: and xet.event_status_code <> 'N'
197905: ORDER BY event_id

Line 197956: FROM xla_events_gt xet

197952: , l1.AP_SECOND_DIST_ID source_181
197953: , l1.ACCT_REV_DISTRIBUTION_TYPE source_182
197954: , l1.ENC_UPG_CR_ENC_TYPE_ID source_183
197955: , l1.ENC_UPG_DR_ENC_TYPE_ID source_184
197956: FROM xla_events_gt xet
197957: , PA_XLA_BC_PKT_AP_DETAIL_V l1
197958: WHERE xet.event_id between x_first_event_id and x_last_event_id
197959: and xet.event_date between p_pad_start_date and p_pad_end_date
197960: and xet.event_class_code = C_EVENT_CLASS_CODE

Line 198906: FROM xla_events_gt xet

198902: WHEN 35 THEN fvl185.meaning
198903:
198904: ELSE null
198905: END source_meaning
198906: FROM xla_events_gt xet
198907: , AP_PAYMENT_EXTRACT_HEADER_V h2
198908: , AP_SYSTEM_PARAMETERS_EXTRACT_V h3
198909: , fnd_lookup_values fvl3
198910: , fnd_lookup_values fvl7

Line 199214: FROM xla_events_gt xet

199210: WHEN 34 THEN fvl160.meaning
199211:
199212: ELSE null
199213: END source_meaning
199214: FROM xla_events_gt xet
199215: , AP_PAYMENT_EXTRACT_DETAILS_V l1
199216: , ZX_AP_DEF_TAX_EXTRACT_V l4
199217: , ZX_AP_TAX_JRNL_LINE_DESC_V l5
199218: , fnd_lookup_values fvl21

Line 199611: FROM xla_events_gt xet

199607: , h2.PAYMENT_DOCUMENT_SEQUENCE_ID source_170
199608: , h2.AC_DOC_SEQUENCE_VALUE source_171
199609: , h2.TRANSAC_REVERSAL_FLAG source_185
199610: , fvl185.meaning source_185_meaning
199611: FROM xla_events_gt xet
199612: , AP_PAYMENT_EXTRACT_HEADER_V h2
199613: , AP_SYSTEM_PARAMETERS_EXTRACT_V h3
199614: , fnd_lookup_values fvl3
199615: , fnd_lookup_values fvl7

Line 199727: FROM xla_events_gt xet

199723: , l1.AI_INVOICE_TYPE_PAID source_158
199724: , fvl158.meaning source_158_meaning
199725: , l1.AWT_AT_PMT_TIME source_160
199726: , fvl160.meaning source_160_meaning
199727: FROM xla_events_gt xet
199728: , AP_PAYMENT_EXTRACT_DETAILS_V l1
199729: , ZX_AP_DEF_TAX_EXTRACT_V l4
199730: , ZX_AP_TAX_JRNL_LINE_DESC_V l5
199731: , fnd_lookup_values fvl21

Line 201915: FROM xla_events_gt xet

201911: WHEN 11 THEN fvl86.meaning
201912:
201913: ELSE null
201914: END source_meaning
201915: FROM xla_events_gt xet
201916: , AP_INVOICE_EXTRACT_HEADER_V h1
201917: , AP_SYSTEM_PARAMETERS_EXTRACT_V h4
201918: , fnd_lookup_values fvl3
201919: , fnd_lookup_values fvl86

Line 202271: FROM xla_events_gt xet

202267: WHEN 39 THEN fvl130.meaning
202268:
202269: ELSE null
202270: END source_meaning
202271: FROM xla_events_gt xet
202272: , AP_PREPAYAPP_EXTRACT_DETAILS_V l2
202273: , AP_PREPAY_DEF_TAX_EXTRACT_V l3
202274: , ZX_AP_DEF_TAX_EXTRACT_V l5
202275: , ZX_AP_TAX_JRNL_LINE_DESC_V l6

Line 202623: FROM xla_events_gt xet

202619: , h1.INV_EXCHANGE_RATE_TYPE source_138
202620: , h1.INV_DOC_SEQUENCE_CATEGORY source_165
202621: , h1.INV_DOC_SEQUENCE_IDENTIFIER source_166
202622: , h1.INV_DOC_SEQUENCE_VALUE source_167
202623: FROM xla_events_gt xet
202624: , AP_INVOICE_EXTRACT_HEADER_V h1
202625: , AP_SYSTEM_PARAMETERS_EXTRACT_V h4
202626: , fnd_lookup_values fvl3
202627: , fnd_lookup_values fvl86

Line 202727: FROM xla_events_gt xet

202723: , l2.BF_ACCRUAL_PP_INV source_142
202724: , l2.BASE_AMT_AT_PP_PAY_XRATE source_145
202725: , l2.APAD_BASE_AMOUNT_DIFF source_150
202726: , l2.INV_PREPMT_GAIN_LOSS_INDICATOR source_157
202727: FROM xla_events_gt xet
202728: , AP_PREPAYAPP_EXTRACT_DETAILS_V l2
202729: , AP_PREPAY_DEF_TAX_EXTRACT_V l3
202730: , ZX_AP_DEF_TAX_EXTRACT_V l5
202731: , ZX_AP_TAX_JRNL_LINE_DESC_V l6

Line 204399: FROM xla_events_gt xet

204395: WHEN 12 THEN fvl86.meaning
204396:
204397: ELSE null
204398: END source_meaning
204399: FROM xla_events_gt xet
204400: , AP_INVOICE_EXTRACT_HEADER_V h2
204401: , AP_SYSTEM_PARAMETERS_EXTRACT_V h4
204402: , fnd_lookup_values fvl3
204403: , fnd_lookup_values fvl19

Line 204778: FROM xla_events_gt xet

204774: WHEN 47 THEN fvl135.meaning
204775:
204776: ELSE null
204777: END source_meaning
204778: FROM xla_events_gt xet
204779: , AP_INVOICE_EXTRACT_DETAILS_V l1
204780: , AP_PO_HEADERS_EXTRACT_V l3
204781: , ZX_AP_DEF_TAX_EXTRACT_V l5
204782: , ZX_AP_TAX_JRNL_LINE_DESC_V l6

Line 205159: FROM xla_events_gt xet

205155: , h2.INV_EXCHANGE_RATE_TYPE source_138
205156: , h2.INV_DOC_SEQUENCE_CATEGORY source_165
205157: , h2.INV_DOC_SEQUENCE_IDENTIFIER source_166
205158: , h2.INV_DOC_SEQUENCE_VALUE source_167
205159: FROM xla_events_gt xet
205160: , AP_INVOICE_EXTRACT_HEADER_V h2
205161: , AP_SYSTEM_PARAMETERS_EXTRACT_V h4
205162: , fnd_lookup_values fvl3
205163: , fnd_lookup_values fvl19

Line 205278: FROM xla_events_gt xet

205274: , l1.ENCUMBRANCE_AMOUNT source_143
205275: , l1.ENCUMBRANCE_BASE_AMOUNT source_144
205276: , l1.AID_QUANTITY_VARIANCE source_161
205277: , l1.AID_BASE_QUANTITY_VARIANCE source_162
205278: FROM xla_events_gt xet
205279: , AP_INVOICE_EXTRACT_DETAILS_V l1
205280: , AP_PO_HEADERS_EXTRACT_V l3
205281: , ZX_AP_DEF_TAX_EXTRACT_V l5
205282: , ZX_AP_TAX_JRNL_LINE_DESC_V l6

Line 208599: FROM xla_events_gt xet

208595:
208596: ELSE null
208597: END source_value
208598: , null source_meaning
208599: FROM xla_events_gt xet
208600: , PA_XLA_BC_PKT_AP_DETAIL_V l1
208601: , (select rownum r from all_objects where rownum <= 17 and owner = p_apps_owner)
208602: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
208603: AND xet.event_class_code = C_EVENT_CLASS_CODE

Line 208805: FROM xla_events_gt xet

208801: ,xet.reference_date_3
208802: ,xet.reference_date_4
208803: ,xet.event_created_by
208804: ,xet.budgetary_control_flag
208805: FROM xla_events_gt xet
208806: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
208807: and xet.event_class_code = C_EVENT_CLASS_CODE
208808: and xet.event_status_code <> 'N'
208809: ORDER BY event_id

Line 208860: FROM xla_events_gt xet

208856: , l1.AP_SECOND_DIST_ID source_181
208857: , l1.ACCT_REV_DISTRIBUTION_TYPE source_182
208858: , l1.ENC_UPG_CR_ENC_TYPE_ID source_183
208859: , l1.ENC_UPG_DR_ENC_TYPE_ID source_184
208860: FROM xla_events_gt xet
208861: , PA_XLA_BC_PKT_AP_DETAIL_V l1
208862: WHERE xet.event_id between x_first_event_id and x_last_event_id
208863: and xet.event_date between p_pad_start_date and p_pad_end_date
208864: and xet.event_class_code = C_EVENT_CLASS_CODE

Line 209711: FROM xla_events_gt xet

209707:
209708: ELSE null
209709: END source_value
209710: , null source_meaning
209711: FROM xla_events_gt xet
209712: , PA_XLA_BC_PKT_AP_DETAIL_V l1
209713: , (select rownum r from all_objects where rownum <= 17 and owner = p_apps_owner)
209714: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
209715: AND xet.event_class_code = C_EVENT_CLASS_CODE

Line 209917: FROM xla_events_gt xet

209913: ,xet.reference_date_3
209914: ,xet.reference_date_4
209915: ,xet.event_created_by
209916: ,xet.budgetary_control_flag
209917: FROM xla_events_gt xet
209918: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
209919: and xet.event_class_code = C_EVENT_CLASS_CODE
209920: and xet.event_status_code <> 'N'
209921: ORDER BY event_id

Line 209972: FROM xla_events_gt xet

209968: , l1.AP_SECOND_DIST_ID source_181
209969: , l1.ACCT_REV_DISTRIBUTION_TYPE source_182
209970: , l1.ENC_UPG_CR_ENC_TYPE_ID source_183
209971: , l1.ENC_UPG_DR_ENC_TYPE_ID source_184
209972: FROM xla_events_gt xet
209973: , PA_XLA_BC_PKT_AP_DETAIL_V l1
209974: WHERE xet.event_id between x_first_event_id and x_last_event_id
209975: and xet.event_date between p_pad_start_date and p_pad_end_date
209976: and xet.event_class_code = C_EVENT_CLASS_CODE

Line 210910: FROM xla_events_gt xet

210906: WHEN 30 THEN fvl115.meaning
210907:
210908: ELSE null
210909: END source_meaning
210910: FROM xla_events_gt xet
210911: , AP_PAYMENT_EXTRACT_HEADER_V h2
210912: , AP_SYSTEM_PARAMETERS_EXTRACT_V h3
210913: , fnd_lookup_values fvl3
210914: , fnd_lookup_values fvl7

Line 211248: FROM xla_events_gt xet

211244: WHEN 42 THEN fvl160.meaning
211245:
211246: ELSE null
211247: END source_meaning
211248: FROM xla_events_gt xet
211249: , AP_PAYMENT_EXTRACT_DETAILS_V l1
211250: , ZX_AP_DEF_TAX_EXTRACT_V l4
211251: , fnd_lookup_values fvl21
211252: , fnd_lookup_values fvl68

Line 211650: FROM xla_events_gt xet

211646: , fvl115.meaning source_115_meaning
211647: , h2.AC_DOC_CATEGORY_CODE source_169
211648: , h2.PAYMENT_DOCUMENT_SEQUENCE_ID source_170
211649: , h2.AC_DOC_SEQUENCE_VALUE source_171
211650: FROM xla_events_gt xet
211651: , AP_PAYMENT_EXTRACT_HEADER_V h2
211652: , AP_SYSTEM_PARAMETERS_EXTRACT_V h3
211653: , fnd_lookup_values fvl3
211654: , fnd_lookup_values fvl7

Line 211764: FROM xla_events_gt xet

211760: , l1.AI_INVOICE_TYPE_PAID source_158
211761: , fvl158.meaning source_158_meaning
211762: , l1.AWT_AT_PMT_TIME source_160
211763: , fvl160.meaning source_160_meaning
211764: FROM xla_events_gt xet
211765: , AP_PAYMENT_EXTRACT_DETAILS_V l1
211766: , ZX_AP_DEF_TAX_EXTRACT_V l4
211767: , fnd_lookup_values fvl21
211768: , fnd_lookup_values fvl68

Line 213971: FROM xla_events_gt xet

213967: WHEN 27 THEN fvl185.meaning
213968:
213969: ELSE null
213970: END source_meaning
213971: FROM xla_events_gt xet
213972: , AP_PAYMENT_EXTRACT_HEADER_V h2
213973: , AP_SYSTEM_PARAMETERS_EXTRACT_V h3
213974: , fnd_lookup_values fvl3
213975: , fnd_lookup_values fvl7

Line 214236: FROM xla_events_gt xet

214232: WHEN 17 THEN fvl90.meaning
214233:
214234: ELSE null
214235: END source_meaning
214236: FROM xla_events_gt xet
214237: , AP_PAYMENT_EXTRACT_DETAILS_V l1
214238: , ZX_AP_DEF_TAX_EXTRACT_V l4
214239: , ZX_AP_TAX_JRNL_LINE_DESC_V l5
214240: , fnd_lookup_values fvl21

Line 214575: FROM xla_events_gt xet

214571: , h2.PAYMENT_DOCUMENT_SEQUENCE_ID source_170
214572: , h2.AC_DOC_SEQUENCE_VALUE source_171
214573: , h2.TRANSAC_REVERSAL_FLAG source_185
214574: , fvl185.meaning source_185_meaning
214575: FROM xla_events_gt xet
214576: , AP_PAYMENT_EXTRACT_HEADER_V h2
214577: , AP_SYSTEM_PARAMETERS_EXTRACT_V h3
214578: , fnd_lookup_values fvl3
214579: , fnd_lookup_values fvl7

Line 214676: FROM xla_events_gt xet

214672: , l1.INV_EXCHANGE_RATE source_137
214673: , l1.INV_EXCHANGE_RATE_TYPE source_138
214674: , l1.INV_PMT_BASE_AMT_DIFF source_148
214675: , l1.INV_PMT_GAIN_LOSS_INDICATOR source_153
214676: FROM xla_events_gt xet
214677: , AP_PAYMENT_EXTRACT_DETAILS_V l1
214678: , ZX_AP_DEF_TAX_EXTRACT_V l4
214679: , ZX_AP_TAX_JRNL_LINE_DESC_V l5
214680: , fnd_lookup_values fvl21

Line 216652: (p_msg => '# of events in xla_events_gt: '

216648: ,p_level => C_LEVEL_STATEMENT
216649: ,p_module => l_log_module);
216650:
216651: trace
216652: (p_msg => '# of events in xla_events_gt: '
216653: ||xla_context_pkg.get_event_count_context
216654: ,p_level => C_LEVEL_STATEMENT
216655: ,p_module => l_log_module);
216656: