DBA Data[Home] [Help]

APPS.EAM_WO_DEFAULT_PVT dependencies on CSI_ITEM_INSTANCES

Line 845: csi_item_instances cii,

841: INTO
842: l_priority
843: , l_owning_department
844: FROM
845: csi_item_instances cii,
846: eam_org_maint_defaults eomd
847: WHERE
848: cii.instance_id = p_eam_wo_rec.maintenance_object_id
849: and eomd.object_type (+) = 50

Line 883: csi_item_instances cii,

879: INTO
880: l_priority
881: , l_owning_department
882: FROM
883: csi_item_instances cii,
884: eam_org_maint_defaults eomd
885: WHERE cii.instance_id = p_eam_wo_rec.maintenance_object_id
886: and eomd.object_type (+) = 40
887: and eomd.object_id (+) = cii.instance_id

Line 1239: from csi_item_instances cii, mtl_system_items msi

1235: , msi.eam_item_type
1236: into l_serial_number
1237: , l_inventory_item_id
1238: , l_eam_item_type
1239: from csi_item_instances cii, mtl_system_items msi
1240: where cii.last_vld_organization_id = msi.organization_id
1241: and cii.inventory_item_id = msi.inventory_item_id
1242: and cii.instance_id = p_eam_wo_rec.maintenance_object_id;
1243: