DBA Data[Home] [Help]

APPS.CSTPIICC dependencies on MTL_SYSTEM_ITEMS

Line 79: from mtl_system_items MSI,

75: l_std_lot_size,
76: l_planning_make_buy_code,
77: l_inv_asset_flag,
78: l_def_matl_cost_code_id
79: from mtl_system_items MSI,
80: mtl_parameters MP
81: WHERE MSI.inventory_item_id = i_item_id
82: AND MSI.organization_id = i_org_id
83: AND MSI.costing_enabled_flag = 'Y'

Line 166: from mtl_system_items msi

162: WHEN NO_DATA_FOUND THEN
163: BEGIN
164: select 0
165: into l_temp
166: from mtl_system_items msi
167: where msi.inventory_item_id = i_item_id
168: and msi.organization_id = i_org_id
169: and msi.costing_enabled_flag = 'N';
170: