APPS.CSE_ASSET_UTIL_PKG dependencies on CSI_I_ASSETS

Line 501: csi_i_assets cia,

497: citdv.inventory_item_id,
498: citdv.inv_organization_id,
499: mmt.primary_quantity
500: FROM csi_inst_txn_details_v citdv,
501: csi_i_assets cia,
502: mtl_material_transactions mmt
503: WHERE citdv.source_header_ref_id=l_wip_entity_id
504: AND cia.instance_id=citdv.instance_id
505: AND citdv.inv_material_transaction_id=mmt.transaction_id ;

Line 1424: ,csi_i_assets cia

1420: IS
1421: SELECT DECODE(msib.asset_creation_code,'1','N','Y')
1422: FROM mtl_system_items_b msib
1423: ,csi_item_instances cii
1424: ,csi_i_assets cia
1425: WHERE msib.organization_id = cii.inv_master_organization_id
1426: AND msib.inventory_item_id = cii.inventory_item_id
1427: AND cii.instance_id = cia.instance_id
1428: AND cia.instance_asset_id = c_instance_asset_id;*/

Line 1435: ,csi_i_assets cia

1431: 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)
1432: IS
1433: SELECT DECODE(msib.asset_creation_code,'1','N','Y')
1434: FROM mtl_system_items_b msib
1435: ,csi_i_assets cia
1436: WHERE msib.organization_id = c_inv_org_id
1437: AND msib.inventory_item_id = c_inv_item_id
1438: AND cia.instance_id = c_inst_id
1439: AND cia.instance_asset_id = c_instance_asset_id;

Line 1692: SELECT 'N' from csi_i_assets

1688: AND msi.organization_id= l_inv_organization_id
1689: AND cii.instance_id=l_instance_id;
1690:
1691: CURSOR c_instance_capitalizes IS
1692: SELECT 'N' from csi_i_assets
1693: WHERE instance_id=l_instance_id
1694: AND (active_end_date >SYSDATE OR active_end_date IS NULL );
1695:
1696: CURSOR c_instance_norm is