Enterprise Asset Management - EBS (MOSC)

MOSC Banner

eam_pmdef_pub.update_pm_def not able to update multiple activity

edited Feb 6, 2016 4:01AM in Enterprise Asset Management - EBS (MOSC) 1 commentAnswered

CREATE OR REPLACE PROCEDURE APPS.abc_EAM__PM_UPDATEPMS (

                                   ERRBUF    OUT VARCHAR2,

                                   RETCODE   OUT VARCHAR2

)

IS

CURSOR c1(p_sch_id number)

    IS  

    SELECT pm.PM_SCHEDULE_ID,cii.instance_number "ASSET_NUMBER",

    pm.NAME,cii.inventory_item_id, pm.RESCHEDULING_POINT,

    decode(pm.type_code,10,'Rule Based',20,'List Based') r_type

    FROM APPS.EAM_PM_SCHEDULINGS PM,csi_item_instances cii,mtl_system_items_vl msik

    WHERE pm.maintenance_object_id = cii.instance_id

    AND msik.organization_id = cii.last_vld_organization_id

    AND msik.inventory_item_id = cii.inventory_item_id

    AND nvl(cii.active_start_date, sysdate - 1) <= sysdate

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center