APPS.ISC_MAINT_ASSET_DT_ETL_PKG dependencies on EAM_ASSET_STATUS_HISTORY

Line 321: from EAM_ASSET_STATUS_HISTORY EASH where (enable_flag = 'Y' or enable_flag is NULL ) and

317: , max(end_date) over(partition by maintenance_object_id order by start_date, end_date)
318: max_so_far
319: , row_number() over(partition by maintenance_object_id order by start_date, end_date)
320: rn
321: from EAM_ASSET_STATUS_HISTORY EASH where (enable_flag = 'Y' or enable_flag is NULL ) and
322: start_date <> end_date
323: and maintenance_object_type = 3
324: )
325: )

Line 617: select * from eam_asset_status_history

613: order by decode(nvl(enable_flag,'Y'),'Y',start_date,null), decode(nvl(enable_flag,'Y'),'Y',end_date,null)) rn
614: from
615: ---
616: (
617: select * from eam_asset_status_history
618: where
619: (
620: ( creation_date > l_collect_from_date and nvl(enable_flag,'Y') = 'Y' )
621: or

Line 668: -- 5 rows from updation of the eam_asset_status_history table.

664: -- 3 rows from updation of the mtl_serial_numbers table.
665: nbmaf.category_id = data.category_id
666: , nbmaf.asset_criticality_code = data.asset_criticality_code
667: , nbmaf.department_id = data.department_id
668: -- 5 rows from updation of the eam_asset_status_history table.
669: , nbmaf.work_order_id = data.work_order_id
670: , nbmaf.operation_seq_number = data.operation_seq_number
671: , nbmaf.description = data.description
672: , nbmaf.start_date = data.start_date