DBA Data[Home] [Help]

APPS.XLA_PERIOD_CLOSE_EXP_PKG dependencies on USER_TAB_COLUMNS

Line 849: -- ,user_tab_columns utc

845: -- ,xem.column_title PROMPT
846: -- ,utc.data_type data_type
847: FROM xla_entity_id_mappings xid
848: --,xla_event_mappings_vl xem
849: -- ,user_tab_columns utc
850: WHERE xid.application_id = l_event_class_set(k).application_id
851: AND xid.entity_code = l_event_class_set(k).entity_code)
852: --AND xem.application_id(+) = xid.application_id -- l_event_class_set(k).application_id
853: -- AND xem.entity_code(+) = xid.entity_code -- l_event_class_set(k).entity_code

Line 921: FROM user_tab_columns t , user_objects o

917: (SELECT xem.column_name column_name
918: ,xem.column_title PROMPT
919: ,utc.data_type data_type
920: FROM (SELECT t.table_name , t.column_name ,t.data_type
921: FROM user_tab_columns t , user_objects o
922: WHERE t.table_name = o.object_name
923: AND o.object_name = l_event_class_set(k).reporting_view_name
924: AND o.object_type <> 'SYNONYM'
925: UNION ALL