DBA Data[Home] [Help]

APPS.OE_DEFAULT_SOURCE_TYPE_PVT dependencies on MTL_SYSTEM_ITEMS

Line 75: from mtl_system_items

71:
72: if org_specified = 'Y' then
73: begin
74: select 'Y' into item_in_org
75: from mtl_system_items
76: where inventory_item_id = p_item
77: and organization_id = l_warehouse;
78: exception
79: when no_data_found then null;

Line 86: from mtl_system_items msi

82:
83: begin
84: select msi.purchasing_enabled_flag
85: into purchasable
86: from mtl_system_items msi
87: where msi.inventory_item_id = p_item
88: and msi.organization_id = FND_PROFILE.VALUE_SPECIFIC('SO_ORGANIZATION_ID');
89: exception
90: when no_data_found then P_Return_Status := FND_API.G_RET_STS_ERROR;