DBA Data[Home] [Help]

APPS.CSE_ASSET_UTIL_PKG dependencies on MTL_SECONDARY_INVENTORIES

Line 1064: FROM mtl_secondary_inventories

1060: AND msi.organization_id = mmt.organization_id;
1061:
1062: SELECT decode(asset_inventory,2,'Y','N') --1=Asset Subinventory 2=Expense subinventory
1063: INTO l_exp_subinv_flag
1064: FROM mtl_secondary_inventories
1065: WHERE organization_id = l_organization_id
1066: AND secondary_inventory_name = l_subinventory_code;
1067:
1068: --Added debugs while fixing bug 14280158

Line 1870: SELECT 'N' from mtl_secondary_inventories msi , csi_item_instances cii

1866:
1867:
1868:
1869: CURSOR c_get_asset_subinventory IS
1870: SELECT 'N' from mtl_secondary_inventories msi , csi_item_instances cii
1871: WHERE msi.asset_inventory=1
1872: AND msi.secondary_inventory_name=l_inv_subinventory_name
1873: AND msi.organization_id=cii.inv_organization_id
1874: AND msi.organization_id= l_inv_organization_id