DBA Data[Home] [Help]

APPS.XLA_00240_AAD_S_000003_PKG dependencies on XLA_EVENTS_GT

Line 3090: FROM xla_events_gt xet

3086:
3087: ELSE null
3088: END source_value
3089: , null source_meaning
3090: FROM xla_events_gt xet
3091: , PN_XLA_EXTRACT_HEADERS_V h1
3092: ,(select rownum r from all_objects where rownum <= 8 and owner = p_apps_owner)
3093: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
3094: AND xet.event_type_code = C_EVENT_TYPE_CODE

Line 3222: FROM xla_events_gt xet

3218:
3219: ELSE null
3220: END source_value
3221: , null source_meaning
3222: FROM xla_events_gt xet
3223: , PN_XLA_EXTRACT_LINES_V l2
3224: ,(select rownum r from all_objects where rownum <= 8 and owner = p_apps_owner)
3225: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
3226: AND xet.event_type_code = C_EVENT_TYPE_CODE

Line 3436: FROM xla_events_gt xet

3432: , h1.LOCATION_CODE source_5
3433: , h1.LEASE_NUMBER source_6
3434: , h1.PROPERTY_CODE source_7
3435: , h1.PAYMENT_ITEM_ID source_12
3436: FROM xla_events_gt xet
3437: , PN_XLA_EXTRACT_HEADERS_V h1
3438: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
3439: and xet.event_type_code = C_EVENT_TYPE_CODE
3440: and xet.event_status_code <> 'N' AND h1.event_id = xet.event_id

Line 3484: FROM xla_events_gt xet

3480: , l2.CONVERSION_DATE source_15
3481: , l2.CONVERSION_RATE source_16
3482: , l2.CONVERSION_RATE_TYPE source_17
3483: , l2.ACCOUNTED_AMOUNT source_18
3484: FROM xla_events_gt xet
3485: , PN_XLA_EXTRACT_LINES_V l2
3486: WHERE xet.event_id between x_first_event_id and x_last_event_id
3487: and xet.event_date between p_pad_start_date and p_pad_end_date
3488: and xet.event_type_code = C_EVENT_TYPE_CODE

Line 4340: FROM xla_events_gt xet

4336:
4337: ELSE null
4338: END source_value
4339: , null source_meaning
4340: FROM xla_events_gt xet
4341: , PN_XLA_EXTRACT_HEADERS_V h1
4342: ,(select rownum r from all_objects where rownum <= 8 and owner = p_apps_owner)
4343: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
4344: AND xet.event_type_code = C_EVENT_TYPE_CODE

Line 4472: FROM xla_events_gt xet

4468:
4469: ELSE null
4470: END source_value
4471: , null source_meaning
4472: FROM xla_events_gt xet
4473: , PN_XLA_EXTRACT_LINES_V l2
4474: ,(select rownum r from all_objects where rownum <= 8 and owner = p_apps_owner)
4475: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
4476: AND xet.event_type_code = C_EVENT_TYPE_CODE

Line 4686: FROM xla_events_gt xet

4682: , h1.PROPERTY_CODE source_7
4683: , h1.CUSTOMER_NAME source_8
4684: , h1.CUSTOMER_SITE source_9
4685: , h1.PAYMENT_ITEM_ID source_12
4686: FROM xla_events_gt xet
4687: , PN_XLA_EXTRACT_HEADERS_V h1
4688: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
4689: and xet.event_type_code = C_EVENT_TYPE_CODE
4690: and xet.event_status_code <> 'N' AND h1.event_id = xet.event_id

Line 4734: FROM xla_events_gt xet

4730: , l2.CONVERSION_DATE source_15
4731: , l2.CONVERSION_RATE source_16
4732: , l2.CONVERSION_RATE_TYPE source_17
4733: , l2.ACCOUNTED_AMOUNT source_18
4734: FROM xla_events_gt xet
4735: , PN_XLA_EXTRACT_LINES_V l2
4736: WHERE xet.event_id between x_first_event_id and x_last_event_id
4737: and xet.event_date between p_pad_start_date and p_pad_end_date
4738: and xet.event_type_code = C_EVENT_TYPE_CODE

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

5567: ,p_level => C_LEVEL_STATEMENT
5568: ,p_module => l_log_module);
5569:
5570: trace
5571: (p_msg => '# of events in xla_events_gt: '
5572: ||xla_context_pkg.get_event_count_context
5573: ,p_level => C_LEVEL_STATEMENT
5574: ,p_module => l_log_module);
5575: