Enterprise Asset Management - EBS (MOSC)

MOSC Banner

column name mapping for active asset flag

in Enterprise Asset Management - EBS (MOSC) 4 commentsAnswered ✓

Hello,

which is the column name to add list active asset list and operating unit for below query?

select DISTINCT ood.organization_name

mea.INVENTORY_ITEM_ID

mea.SERIAL_NUMBER

mea.DESCRIPTIVE_TEXT

mea.CONTEXT

mea.CURRENT_ORGANIZATION_ID

mea.INV_ORGANIZATION_CODE

mea.CONCATENATED_SEGMENTS "ASSET GROUP"

mea.ASSET_GROUP_DESCRIPTION

mea.ASSET_CRITICALITY

mea.WIP_ACCOUNTING_CLASS_CODE

mea.MAINTAINABLE_FLAG

mea.OPERATIONAL_LOG_FLAG

mea.AREA

mea.OWNING_DEPARTMENT

mea.CREATION_DATE

--mea.LAST_UPDATE_DATE

--mea.CURRENT_STATUS_MEANING

mea.INSTANCE_STATUS

from MTL_EAM_ASSET_NUMBERS_ALL_V mea

apps.org_organization_definitions ood

--where SERIAL_NUMBER='1041-STP-1'

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

EBS EAM Tags

Instructions for posting

×

1. Select a discussion category from the picklist.


2. Enter a title that clearly identifies the subject of your question.


3. In the body, insert detailed information, including Oracle product and version.


Please abide by the Oracle Community guidelines and refrain from posting any customer or personally identifiable information (PI/CI).


Cloud / Fusion customers - Our Cloud community has moved! Please go to Cloud Customer Connect .


New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center