DBA Data[Home] [Help]

APPS.EAM_PROCESS_FAILURE_ENTRY_PUB dependencies on CSI_ITEM_INSTANCES

Line 256: FROM csi_item_instances cii,

252: BEGIN
253:
254: SELECT eomd.owning_department_id,eomd.area_id
255: INTO l_msn_department_id, l_eam_location_id
256: FROM csi_item_instances cii,
257: eam_org_maint_defaults eomd,mtl_parameters mp
258: WHERE cii.instance_id = l_object_id
259: AND cii.instance_id = eomd.object_id(+)
260: AND eomd.object_type(+)= 50

Line 526: FROM csi_item_instances cii,

522: BEGIN
523:
524: SELECT eomd.owning_department_id,eomd.area_id
525: INTO l_msn_department_id, l_eam_location_id
526: FROM csi_item_instances cii,
527: eam_org_maint_defaults eomd,mtl_parameters mp
528: WHERE cii.instance_id = l_object_id
529: AND cii.instance_id = eomd.object_id(+)
530: AND eomd.object_type(+)= 50