View: MTL_SECONDARY_INVENTORIES_FK_V

Product:	INV - Inventory
Description:	- Retrofitted
Implementation/DBA Data:	APPS.MTL_SECONDARY_INVENTORIES_FK_V

View Text

SELECT A.ROWID ROW_ID
, A.SECONDARY_INVENTORY_NAME
, NVL(A.SUBINVENTORY_TYPE
, 1)
, A.ORGANIZATION_ID
, A.LAST_UPDATE_DATE
, A.LAST_UPDATED_BY
, A.CREATION_DATE
, A.CREATED_BY
, A.LAST_UPDATE_LOGIN
, A.DESCRIPTION
, A.DISABLE_DATE
, A.INVENTORY_ATP_CODE
, A.AVAILABILITY_TYPE
, A.RESERVABLE_TYPE
, A.LOCATOR_TYPE
, A.PICKING_ORDER
, A.MATERIAL_ACCOUNT
, A.MATERIAL_OVERHEAD_ACCOUNT
, A.RESOURCE_ACCOUNT
, A.OVERHEAD_ACCOUNT
, A.OUTSIDE_PROCESSING_ACCOUNT
, A.QUANTITY_TRACKED
, A.ASSET_INVENTORY
, A.SOURCE_TYPE
, A.SOURCE_SUBINVENTORY
, A.SOURCE_ORGANIZATION_ID
, D.ORGANIZATION_CODE SOURCE_ORGANIZATION_CODE
, A.REQUISITION_APPROVAL_TYPE
, A.EXPENSE_ACCOUNT
, A.ENCUMBRANCE_ACCOUNT
, A.ATTRIBUTE_CATEGORY
, A.ATTRIBUTE1
, A.ATTRIBUTE2
, A.ATTRIBUTE3
, A.ATTRIBUTE4
, A.ATTRIBUTE5
, A.ATTRIBUTE6
, A.ATTRIBUTE7
, A.ATTRIBUTE8
, A.ATTRIBUTE9
, A.ATTRIBUTE10
, A.ATTRIBUTE11
, A.ATTRIBUTE12
, A.ATTRIBUTE13
, A.ATTRIBUTE14
, A.ATTRIBUTE15
, A.REQUEST_ID
, A.PROGRAM_APPLICATION_ID
, A.PROGRAM_ID
, A.PROGRAM_UPDATE_DATE
, A.PREPROCESSING_LEAD_TIME
, A.PROCESSING_LEAD_TIME
, A.POSTPROCESSING_LEAD_TIME
, A.DEMAND_CLASS
, A.PROJECT_ID
, A.TASK_ID
, A.SUBINVENTORY_USAGE
, A.NOTIFY_LIST_ID
, E.APPROVAL_LIST_NAME NOTIFY_LIST
, A.DEPRECIABLE_FLAG
, A.LOCATION_ID
, H.LOCATION_CODE
, A.STATUS_ID
, M.STATUS_CODE
, A.DEFAULT_LOC_STATUS_ID
, N.STATUS_CODE DEFAULT_LOC_STATUS_CODE
, NVL(A.LPN_CONTROLLED_FLAG
, 2)
, A.DEFAULT_COST_GROUP_ID
, CG.COST_GROUP DEFAULT_COST_GROUP_NAME
, A.PICK_METHODOLOGY
, A.PICK_UOM_CODE
, A.CARTONIZATION_FLAG
, A.DROPPING_ORDER
, A.PLANNING_LEVEL
, A.DEFAULT_COUNT_TYPE_CODE
, A.ENABLE_BULK_PICK
, A.ENABLE_LOCATOR_ALIAS
, A.ENFORCE_ALIAS_UNIQUENESS
, A.OPP_CYC_COUNT_QUANTITY
, A.OPP_CYC_COUNT_DAYS
, A.OPP_CYC_COUNT_HEADER_ID
, A.ENABLE_OPP_CYC_COUNT
, (SELECT CYCLE_COUNT_HEADER_NAME
FROM MTL_CYCLE_COUNT_HEADERS
WHERE CYCLE_COUNT_HEADER_ID=A.OPP_CYC_COUNT_HEADER_ID) OPP_CYC_CONT_HEADER_NAME
FROM MTL_SECONDARY_INVENTORIES A
, MTL_PARAMETERS D
, ENG_ECN_APPROVAL_LISTS E
, HR_LOCATIONS_ALL H
, MTL_MATERIAL_STATUSES_TL M
, MTL_MATERIAL_STATUSES_TL N
, CST_COST_GROUPS CG
WHERE D.ORGANIZATION_ID (+) = A.SOURCE_ORGANIZATION_ID
AND E.APPROVAL_LIST_ID(+) = A.NOTIFY_LIST_ID
AND H.LOCATION_ID(+)=A.LOCATION_ID
AND NVL(H.BUSINESS_GROUP_ID
, NVL(HR_GENERAL.GET_BUSINESS_GROUP_ID
, -99)) = NVL(HR_GENERAL.GET_BUSINESS_GROUP_ID
, -99)
AND M.STATUS_ID(+)= A.STATUS_ID
AND N.STATUS_ID(+) = A.DEFAULT_LOC_STATUS_ID
AND M.LANGUAGE(+) = USERENV('LANG')
AND N.LANGUAGE(+) = USERENV('LANG')
AND CG.COST_GROUP_ID(+) = A.DEFAULT_COST_GROUP_ID

Columns