INV_ORGANIZATION_DEFINITIONS

Details

Schema: FUSION
Object owner: INV
Object type: VIEW

Columns

Name
ORGANIZATION_ID BUSINESS_GROUP_ID USER_DEFINITION_ENABLE_DATE DISABLE_DATE ORGANIZATION_CODE ORGANIZATION_NAME SET_OF_BOOKS_ID CHART_OF_ACCOUNTS_ID CURRENCY_CODE PERIOD_SET_NAME INVENTORY_ENABLED_FLAG BUSINESS_UNIT_NAME BUSINESS_UNIT_ID LEGAL_ENTITY ORGANIZATION_TYPE LOCATION_ID INVENTORY_FLAG DISTRIBUTED_ORGANIZATION_FLAG MASTER_ORGANIZATION_ID MANUAL_RECEIPT_EXP_AT_DEST PROFIT_CENTER_BU_ID MFG_PLANT_FLAG CONTRACT_MFG_FLAG SUPPLIER_ID SUPPLIER_SITE_ID EAM_ENABLED_FLAG TIMEZONE_CODE FILL_KILL_TRANSFER_ORDERS_FLAG INTEGRATED_SYSTEM_CODE ITEM_GROUPING_CODE ITEM_DEFINITION_ORG_ID GROUPING_JOB_STATUS GROUPING_JOB_ID PROJECT_REFERENCE_ENABLED TRACK_COUNTRY_OF_ORIGIN_FLAG LAST_UPDATE_DATE INTERNAL_CUSTOMER_FLAG CUSTOMER_ACCOUNT_NUMBER PARTY_ID CREATED_BY CREATION_DATE LAST_UPDATED_BY LAST_UPDATE_LOGIN INV_LAST_UPDATE_DATE FA_BOOK_TYPE_CODE ALLOW_ITEM_SUBSTITUTIONS WMS_WITH_MFG_ALM FILL_KILL_SALES_ORDER_FLAG

Name

ORGANIZATION_ID

BUSINESS_GROUP_ID

USER_DEFINITION_ENABLE_DATE

DISABLE_DATE

ORGANIZATION_CODE

ORGANIZATION_NAME

SET_OF_BOOKS_ID

CHART_OF_ACCOUNTS_ID

CURRENCY_CODE

PERIOD_SET_NAME

INVENTORY_ENABLED_FLAG

BUSINESS_UNIT_NAME

BUSINESS_UNIT_ID

LEGAL_ENTITY

ORGANIZATION_TYPE

LOCATION_ID

INVENTORY_FLAG

DISTRIBUTED_ORGANIZATION_FLAG

MASTER_ORGANIZATION_ID

MANUAL_RECEIPT_EXP_AT_DEST

PROFIT_CENTER_BU_ID

MFG_PLANT_FLAG

CONTRACT_MFG_FLAG

SUPPLIER_ID

SUPPLIER_SITE_ID

EAM_ENABLED_FLAG

TIMEZONE_CODE

FILL_KILL_TRANSFER_ORDERS_FLAG

INTEGRATED_SYSTEM_CODE

ITEM_GROUPING_CODE

ITEM_DEFINITION_ORG_ID

GROUPING_JOB_STATUS

GROUPING_JOB_ID

PROJECT_REFERENCE_ENABLED

TRACK_COUNTRY_OF_ORIGIN_FLAG

LAST_UPDATE_DATE

INTERNAL_CUSTOMER_FLAG

CUSTOMER_ACCOUNT_NUMBER

PARTY_ID

CREATED_BY

CREATION_DATE

LAST_UPDATED_BY

LAST_UPDATE_LOGIN

INV_LAST_UPDATE_DATE

FA_BOOK_TYPE_CODE

ALLOW_ITEM_SUBSTITUTIONS

WMS_WITH_MFG_ALM

FILL_KILL_SALES_ORDER_FLAG

Query

SQL_Statement
SELECT HOU.ORGANIZATION_ID ORGANIZATION_ID, HOU.BUSINESS_GROUP_ID BUSINESS_GROUP_ID, HOU.effective_start_date USER_DEFINITION_ENABLE_DATE, HOU.effective_end_date DISABLE_DATE , MP.ORGANIZATION_CODE ORGANIZATION_CODE, HOU.NAME ORGANIZATION_NAME, LGR.LEDGER_ID SET_OF_BOOKS_ID, LGR.CHART_OF_ACCOUNTS_ID CHART_OF_ACCOUNTS_ID, LGR.CURRENCY_CODE, LGR.PERIOD_SET_NAME, DECODE(HOI1.STATUS, 'A', 'Y', 'N') INVENTORY_ENABLED_FLAG, BU.BU_NAME BUSINESS_UNIT_NAME, MP.BUSINESS_UNIT_ID BUSINESS_UNIT_ID, MP.LEGAL_ENTITY_ID LEGAL_ENTITY, HOU.TYPE ORGANIZATION_TYPE, HOU.LOCATION_ID LOCATION_ID, MP.INVENTORY_FLAG INVENTORY_FLAG, MP.DISTRIBUTED_ORGANIZATION_FLAG, MP.MASTER_ORGANIZATION_ID, MP.MANUAL_RECEIPT_EXP_AT_DEST, MP.PROFIT_CENTER_BU_ID, MP.MFG_PLANT_FLAG, MP.CONTRACT_MFG_FLAG, MP.SUPPLIER_ID, MP.SUPPLIER_SITE_ID, MP.EAM_ENABLED_FLAG, MP.TIMEZONE_CODE, MP.FILL_KILL_TRANSFER_ORDERS_FLAG, MP.INTEGRATED_SYSTEM_CODE, MP.ITEM_GROUPING_CODE, MP.ITEM_DEFINITION_ORG_ID, MP.GROUPING_JOB_STATUS, MP.GROUPING_JOB_ID, MP.PROJECT_REFERENCE_ENABLED, MP.TRACK_COUNTRY_OF_ORIGIN_FLAG, HOU.LAST_UPDATE_DATE, MP.INTERNAL_CUSTOMER_FLAG, MP.CUSTOMER_ACCOUNT_NUMBER, MP.PARTY_ID, MP.Created_By, MP.Creation_Date, MP.Last_Updated_By, MP.Last_Update_Login, MP.Last_Update_Date Inv_Last_Update_Date, MP.FA_BOOK_TYPE_CODE, MP.ALLOW_ITEM_SUBSTITUTIONS, MP.WMS_WITH_MFG_ALM, MP.FILL_KILL_SALES_ORDER_FLAG FROM HR_ALL_ORGANIZATION_UNITS_X HOU, HR_ORG_UNIT_CLASSIFICATIONS_X HOI1, INV_ORG_PARAMETERS MP, GL_LEDGERS LGR, FUN_ALL_BUSINESS_UNITS_V BU WHERE HOU.ORGANIZATION_ID = HOI1.ORGANIZATION_ID AND HOU.ORGANIZATION_ID = MP.ORGANIZATION_ID AND HOI1.CLASSIFICATION_CODE = 'INV' AND BU.PRIMARY_LEDGER_ID = LGR.LEDGER_ID(+) AND LGR.OBJECT_TYPE_CODE(+) = 'L' AND NVL(LGR.COMPLETE_FLAG, 'Y') = 'Y' AND BU.BU_ID(+) = MP.BUSINESS_UNIT_ID AND (MP.BUSINESS_UNIT_ID IS NULL OR EXISTS (SELECT 1 FROM FUN_BU_USAGES BusinessUnitUsage, FUN_BUSINESS_FUNCTIONS_VL BF WHERE BusinessUnitUsage.BUSINESS_UNIT_ID= MP.BUSINESS_UNIT_ID AND BusinessUnitUsage.MODULE_ID = BF.BUSINESS_FUNCTION_ID AND BF.BUSINESS_FUNCTION_CODE = ('MATERIALS_MANAGEMENT_BF') )) AND (MP.PROFIT_CENTER_BU_ID IS NULL OR EXISTS( SELECT 1 FROM FUN_ALL_BUSINESS_UNITS_V BusinessUnitPEO WHERE BusinessUnitPEO.BU_ID =MP.PROFIT_CENTER_BU_ID AND BusinessUnitPEO.PROFIT_CENTER_FLAG ='Y' AND EXISTS ( SELECT 1 FROM FUN_BU_USAGES BusinessUnitUsage, FUN_BUSINESS_FUNCTIONS_VL BF where BusinessUnitPEO.bu_id = BusinessUnitUsage.business_unit_id AND BusinessUnitUsage.module_id = BF.business_function_id AND BF.BUSINESS_FUNCTION_CODE IN ('MATERIALS_MANAGEMENT_BF', 'REQUISITIONING_BF' )) ))

SQL_Statement

SELECT HOU.ORGANIZATION_ID ORGANIZATION_ID,

HOU.BUSINESS_GROUP_ID BUSINESS_GROUP_ID,

HOU.effective_start_date USER_DEFINITION_ENABLE_DATE,

HOU.effective_end_date DISABLE_DATE ,

MP.ORGANIZATION_CODE ORGANIZATION_CODE,

HOU.NAME ORGANIZATION_NAME,

LGR.LEDGER_ID SET_OF_BOOKS_ID,

LGR.CHART_OF_ACCOUNTS_ID CHART_OF_ACCOUNTS_ID,

LGR.CURRENCY_CODE,

LGR.PERIOD_SET_NAME,

DECODE(HOI1.STATUS, 'A', 'Y', 'N') INVENTORY_ENABLED_FLAG,

BU.BU_NAME BUSINESS_UNIT_NAME,

MP.BUSINESS_UNIT_ID BUSINESS_UNIT_ID,

MP.LEGAL_ENTITY_ID LEGAL_ENTITY,

HOU.TYPE ORGANIZATION_TYPE,

HOU.LOCATION_ID LOCATION_ID,

MP.INVENTORY_FLAG INVENTORY_FLAG,

MP.DISTRIBUTED_ORGANIZATION_FLAG,

MP.MASTER_ORGANIZATION_ID,

MP.MANUAL_RECEIPT_EXP_AT_DEST,

MP.PROFIT_CENTER_BU_ID,

MP.MFG_PLANT_FLAG,

MP.CONTRACT_MFG_FLAG,

MP.SUPPLIER_ID,

MP.SUPPLIER_SITE_ID,

MP.EAM_ENABLED_FLAG,

MP.TIMEZONE_CODE,

MP.FILL_KILL_TRANSFER_ORDERS_FLAG,

MP.INTEGRATED_SYSTEM_CODE,

MP.ITEM_GROUPING_CODE,

MP.ITEM_DEFINITION_ORG_ID,

MP.GROUPING_JOB_STATUS,

MP.GROUPING_JOB_ID,

MP.PROJECT_REFERENCE_ENABLED,

MP.TRACK_COUNTRY_OF_ORIGIN_FLAG,

HOU.LAST_UPDATE_DATE,

MP.INTERNAL_CUSTOMER_FLAG,

MP.CUSTOMER_ACCOUNT_NUMBER,

MP.PARTY_ID,

MP.Created_By,

MP.Creation_Date,

MP.Last_Updated_By,

MP.Last_Update_Login,

MP.Last_Update_Date Inv_Last_Update_Date,

MP.FA_BOOK_TYPE_CODE,

MP.ALLOW_ITEM_SUBSTITUTIONS,

MP.WMS_WITH_MFG_ALM,

MP.FILL_KILL_SALES_ORDER_FLAG

FROM HR_ALL_ORGANIZATION_UNITS_X HOU,

HR_ORG_UNIT_CLASSIFICATIONS_X HOI1,

INV_ORG_PARAMETERS MP,

GL_LEDGERS LGR,

FUN_ALL_BUSINESS_UNITS_V BU

WHERE HOU.ORGANIZATION_ID = HOI1.ORGANIZATION_ID

AND HOU.ORGANIZATION_ID = MP.ORGANIZATION_ID

AND HOI1.CLASSIFICATION_CODE = 'INV'

AND BU.PRIMARY_LEDGER_ID = LGR.LEDGER_ID(+)

AND LGR.OBJECT_TYPE_CODE(+) = 'L'

AND NVL(LGR.COMPLETE_FLAG, 'Y') = 'Y'

AND BU.BU_ID(+) = MP.BUSINESS_UNIT_ID

AND (MP.BUSINESS_UNIT_ID IS NULL

OR EXISTS

(SELECT 1

FROM FUN_BU_USAGES BusinessUnitUsage,

FUN_BUSINESS_FUNCTIONS_VL BF

WHERE BusinessUnitUsage.BUSINESS_UNIT_ID= MP.BUSINESS_UNIT_ID

AND BusinessUnitUsage.MODULE_ID = BF.BUSINESS_FUNCTION_ID

AND BF.BUSINESS_FUNCTION_CODE = ('MATERIALS_MANAGEMENT_BF')

))

AND (MP.PROFIT_CENTER_BU_ID IS NULL

OR EXISTS(

SELECT 1

FROM FUN_ALL_BUSINESS_UNITS_V BusinessUnitPEO

WHERE BusinessUnitPEO.BU_ID =MP.PROFIT_CENTER_BU_ID

AND BusinessUnitPEO.PROFIT_CENTER_FLAG ='Y'

AND EXISTS

( SELECT 1

FROM FUN_BU_USAGES BusinessUnitUsage,

FUN_BUSINESS_FUNCTIONS_VL BF

where BusinessUnitPEO.bu_id = BusinessUnitUsage.business_unit_id

AND BusinessUnitUsage.module_id = BF.business_function_id

AND BF.BUSINESS_FUNCTION_CODE IN ('MATERIALS_MANAGEMENT_BF',

'REQUISITIONING_BF' ))

))