APPS.WIP_JSI_VALIDATOR dependencies on MTL_EAM_ASSET_ACTIVITIES

Line 1127: from mtl_eam_asset_activities

1123: if(wjsi_row.maintenance_object_type = 1) then
1124: if(wjsi_row.rebuild_item_id is null) then
1125: select start_date_active, end_date_active
1126: into l_start_date, l_end_date
1127: from mtl_eam_asset_activities
1128: where asset_activity_id = wjsi_row.primary_item_id
1129: and organization_id = wjsi_row.organization_id
1130: and inventory_item_id = wjsi_row.asset_group_id
1131: and serial_number = wjsi_row.asset_number;

Line 1135: from mtl_eam_asset_activities

1131: and serial_number = wjsi_row.asset_number;
1132: else
1133: select min(start_date_active), min(end_date_active)
1134: into l_start_date, l_end_date
1135: from mtl_eam_asset_activities
1136: where asset_activity_id = wjsi_row.primary_item_id
1137: and organization_id = wjsi_row.organization_id
1138: and inventory_item_id = wjsi_row.rebuild_item_id
1139: and serial_number = wjsi_row.rebuild_serial_number;

Line 1146: from mtl_eam_asset_activities

1142: wjsi_row.rebuild_item_id is not null) then
1143:
1144: select min(start_date_active), min(end_date_active)
1145: into l_start_date, l_end_date
1146: from mtl_eam_asset_activities
1147: where asset_activity_id = wjsi_row.primary_item_id
1148: and organization_id = wjsi_row.organization_id
1149: and inventory_item_id = wjsi_row.rebuild_item_id;
1150:

Line 1156: from mtl_eam_asset_activities

1152: wjsi_row.rebuild_item_id is not null) then
1153:
1154: select min(start_date_active), min(end_date_active)
1155: into l_start_date, l_end_date
1156: from mtl_eam_asset_activities
1157: where asset_activity_id = wjsi_row.primary_item_id
1158: and organization_id = wjsi_row.organization_id
1159: and inventory_item_id = wjsi_row.rebuild_item_id;
1160: end if;