DBA Data[Home] [Help]

APPS.CZ_PS_COPY dependencies on CZ_RP_ENTRIES

Line 280: INSERT INTO CZ_RP_ENTRIES(object_type,object_id,enclosing_folder,deleted_flag,name)

276: i.PRODUCT_KEY,
277: i.ORGANIZATION_ID,
278: i.INVENTORY_ITEM_ID);
279:
280: INSERT INTO CZ_RP_ENTRIES(object_type,object_id,enclosing_folder,deleted_flag,name)
281: SELECT object_type,NEW_PROJECT_ID,DECODE(ENCLOSE_FOLDER,-1,enclosing_folder,ENCLOSE_FOLDER),deleted_flag,var_name
282: FROM CZ_RP_ENTRIES
283: WHERE object_id=OLD_PROJECT_ID AND deleted_flag=NO_FLAG;
284:

Line 282: FROM CZ_RP_ENTRIES

278: i.INVENTORY_ITEM_ID);
279:
280: INSERT INTO CZ_RP_ENTRIES(object_type,object_id,enclosing_folder,deleted_flag,name)
281: SELECT object_type,NEW_PROJECT_ID,DECODE(ENCLOSE_FOLDER,-1,enclosing_folder,ENCLOSE_FOLDER),deleted_flag,var_name
282: FROM CZ_RP_ENTRIES
283: WHERE object_id=OLD_PROJECT_ID AND deleted_flag=NO_FLAG;
284:
285: PACK;
286: