EAM De-Activate Asset Number Parent Child Relationship using API in Oracle Apps
Hi Developers, Kindly find the script that i have created for where it will remove the Maintainable Flag and Deactivate the Asset at the same time. This API takes out the Parent Child Geneology and then Deactivate the Asset. Hope this helps the Developers Note: 1: You cannot Deactivate a Route Asset as this is intended functionality 2: You cannot Deactivate an Asset if there is Open Work Order or Work Requests for the Asset create or replace procedure check_geneology (p_item_instance in varchar2) is lc_exception varchar2 (1000); --Added for EAM geneology end date API lc_child_serial varchar2 (200); ln_child_inv_id number; ln_child_org_id number; ln_child_inst_number varchar2 (3000); ln_child_inst_id number; ...