APPS.WIP_JSI_VALIDATOR dependencies on MTL_EAM_ASSET_ACTIVITIES

Line 1132: from mtl_eam_asset_activities

1128: if(wjsi_row.maintenance_object_type = 1) then
1129: if(wjsi_row.rebuild_item_id is null) then
1130: select start_date_active, end_date_active
1131: into l_start_date, l_end_date
1132: from mtl_eam_asset_activities
1133: where asset_activity_id = wjsi_row.primary_item_id
1134: and organization_id = wjsi_row.organization_id
1135: and inventory_item_id = wjsi_row.asset_group_id
1136: and serial_number = wjsi_row.asset_number;

Line 1140: from mtl_eam_asset_activities

1136: and serial_number = wjsi_row.asset_number;
1137: else
1138: select min(start_date_active), min(end_date_active)
1139: into l_start_date, l_end_date
1140: from mtl_eam_asset_activities
1141: where asset_activity_id = wjsi_row.primary_item_id
1142: and organization_id = wjsi_row.organization_id
1143: and inventory_item_id = wjsi_row.rebuild_item_id
1144: and serial_number = wjsi_row.rebuild_serial_number;

Line 1151: from mtl_eam_asset_activities

1147: wjsi_row.rebuild_item_id is not null) then
1148:
1149: select min(start_date_active), min(end_date_active)
1150: into l_start_date, l_end_date
1151: from mtl_eam_asset_activities
1152: where asset_activity_id = wjsi_row.primary_item_id
1153: and organization_id = wjsi_row.organization_id
1154: and inventory_item_id = wjsi_row.rebuild_item_id;
1155:

Line 1161: from mtl_eam_asset_activities

1157: wjsi_row.rebuild_item_id is not null) then
1158:
1159: select min(start_date_active), min(end_date_active)
1160: into l_start_date, l_end_date
1161: from mtl_eam_asset_activities
1162: where asset_activity_id = wjsi_row.primary_item_id
1163: and organization_id = wjsi_row.organization_id
1164: and inventory_item_id = wjsi_row.rebuild_item_id;
1165: end if;