VIEW: APPS.MTL_SECONDARY_INVENTORIES_FK_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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