APPS.CSE_ASSET_UTIL_PKG dependencies on CSI_I_ASSETS

Line 545: csi_i_assets cia,

541: citdv.inventory_item_id,
542: citdv.inv_organization_id,
543: mmt.primary_quantity
544: FROM csi_inst_txn_details_v citdv,
545: csi_i_assets cia,
546: mtl_material_transactions mmt
547: WHERE citdv.source_header_ref_id=l_wip_entity_id
548: AND cia.instance_id=citdv.instance_id
549: AND citdv.inv_material_transaction_id=mmt.transaction_id ;

Line 1549: ,csi_i_assets cia

1545: IS
1546: SELECT DECODE(msib.asset_creation_code,'1','N','Y')
1547: FROM mtl_system_items_b msib
1548: ,csi_item_instances cii
1549: ,csi_i_assets cia
1550: WHERE msib.organization_id = cii.inv_master_organization_id
1551: AND msib.inventory_item_id = cii.inventory_item_id
1552: AND cii.instance_id = cia.instance_id
1553: AND cia.instance_asset_id = c_instance_asset_id;*/

Line 1560: ,csi_i_assets cia

1556: CURSOR catchup_cur (c_instance_asset_id IN NUMBER,c_inv_org_id IN NUMBER,c_inv_item_id IN NUMBER, c_inst_id IN NUMBER)
1557: IS
1558: SELECT DECODE(msib.asset_creation_code,'1','N','Y')
1559: FROM mtl_system_items_b msib
1560: ,csi_i_assets cia
1561: WHERE msib.organization_id = c_inv_org_id
1562: AND msib.inventory_item_id = c_inv_item_id
1563: AND cia.instance_id = c_inst_id
1564: AND cia.instance_asset_id = c_instance_asset_id;

Line 1878: SELECT 'N' from csi_i_assets

1874: AND msi.organization_id= l_inv_organization_id
1875: AND cii.instance_id=l_instance_id;
1876:
1877: CURSOR c_instance_capitalizes IS
1878: SELECT 'N' from csi_i_assets
1879: WHERE instance_id=l_instance_id
1880: AND (active_end_date >SYSDATE OR active_end_date IS NULL );
1881:
1882: CURSOR c_instance_norm is