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 529: FROM csi_item_instances cii,

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