DBA Data[Home] [Help]

APPS.CSTPECEP dependencies on CSI_ITEM_INSTANCES

Line 259: from csi_item_instances cii

255: AND wdj.status_type IN (1,3,4,6,17)
256: AND p_job_option = 3
257: AND wdj.maintenance_object_id in
258: (select cii.instance_id
259: from csi_item_instances cii
260: where cii.instance_number = p_asset_number
261: AND cii.inventory_item_id = p_inventory_item_id
262: )
263: AND wdj.maintenance_object_type = 3