APPS.EAM_ASSET_OPERATION_TXN_PVT dependencies on CSI_ITEM_INSTANCES

Line 682: FROM csi_item_instances

678:
679: SELECT
680: count(*)
681: INTO l_count
682: FROM csi_item_instances
683: WHERE instance_id=p_instance_id
684: AND
685: p_txn_date BETWEEN nvl(active_start_date,sysdate) AND
686: NVL(active_end_date, sysdate);

Line 1003: mtl_parameters mp, csi_item_instances cii

999: l_asset_instance_number,
1000: l_asset_group_id,
1001: l_asset_number
1002: FROM
1003: mtl_parameters mp, csi_item_instances cii
1004: where
1005: cii.last_vld_organization_id = mp.organization_id
1006: AND cii.instance_id = p_instance_id;
1007:

Line 1369: from csi_item_instances

1365: l_instance_rec.instance_id := p_instance_id;
1366:
1367: select object_version_number
1368: into l_object_version_number
1369: from csi_item_instances
1370: where instance_id = p_instance_id;
1371:
1372: IF SQL%NOTFOUND THEN
1373: l_object_version_number :=null;