[Home] [Help]
View: INVFV_ABC_CLASSES
View Text
SELECT MAC.ABC_CLASS_ID
, MAC.ABC_CLASS_NAME
, MAC.ORGANIZATION_ID
, MP.ORGANIZATION_CODE
, HOU.NAME
, MAC.DESCRIPTION
, MAC.DISABLE_DATE
, MAC.CREATED_BY
, MAC.CREATION_DATE
, MAC.LAST_UPDATED_BY
, MAC.LAST_UPDATE_DATE
FROM MTL_PARAMETERS MP
, HR_ALL_ORGANIZATION_UNITS HOU
, MTL_ABC_CLASSES MAC
WHERE MP.ORGANIZATION_ID = MAC.ORGANIZATION_ID
AND HOU.ORGANIZATION_ID = MAC.ORGANIZATION_ID
AND '_SEC:MAC.ORGANIZATION_ID' IS NOT NULL WITH READ ONLY
Columns
Name |
ABC_CLASS_ID |
ABC_CLASS_NAME |
ORGANIZATION_ID |
ORGANIZATION_CODE |
ORGANIZATION_NAME |
DESCRIPTION |
INACTIVE_DATE |
CREATED_BY |
CREATION_DATE |
LAST_UPDATED_BY |
LAST_UPDATE_DATE |