VIEW: APPS.CSL_MTL_ITEM_LOCATIONS_V

Source

View Text - Preformatted

SELECT B.INVENTORY_LOCATION_ID , B.ORGANIZATION_ID , B.CONCATENATED_SEGMENTS , B.PADDED_CONCATENATED_SEGMENTS , B.DESCRIPTION , B.SUBINVENTORY_CODE , B.DISABLE_DATE , B.START_DATE_ACTIVE , B.END_DATE_ACTIVE , B.ENABLED_FLAG , B.SUMMARY_FLAG , B.DESCRIPTIVE_TEXT , B.PROJECT_ID , B.TASK_ID , B.PHYSICAL_LOCATION_ID , B.STATUS_ID , B.LOCATOR_STATUS , B.LOCATION_CURRENT_UNITS , B.LOCATION_AVAILABLE_UNITS , B.INVENTORY_ITEM_ID , B.LOCATION_SUGGESTED_UNITS , ACC.ACCESS_ID FROM MTL_ITEM_LOCATIONS_KFV B, CSL_MTL_ITEM_LOCATIONS_ACC ACC WHERE B.INVENTORY_LOCATION_ID = ACC.INVENTORY_LOCATION_ID AND B.ORGANIZATION_ID = ACC.ORGANIZATION_ID AND ACC.RESOURCE_ID = ASG_BASE.GET_RESOURCE_ID

View Text - HTML Formatted

SELECT B.INVENTORY_LOCATION_ID
, B.ORGANIZATION_ID
, B.CONCATENATED_SEGMENTS
, B.PADDED_CONCATENATED_SEGMENTS
, B.DESCRIPTION
, B.SUBINVENTORY_CODE
, B.DISABLE_DATE
, B.START_DATE_ACTIVE
, B.END_DATE_ACTIVE
, B.ENABLED_FLAG
, B.SUMMARY_FLAG
, B.DESCRIPTIVE_TEXT
, B.PROJECT_ID
, B.TASK_ID
, B.PHYSICAL_LOCATION_ID
, B.STATUS_ID
, B.LOCATOR_STATUS
, B.LOCATION_CURRENT_UNITS
, B.LOCATION_AVAILABLE_UNITS
, B.INVENTORY_ITEM_ID
, B.LOCATION_SUGGESTED_UNITS
, ACC.ACCESS_ID
FROM MTL_ITEM_LOCATIONS_KFV B
, CSL_MTL_ITEM_LOCATIONS_ACC ACC
WHERE B.INVENTORY_LOCATION_ID = ACC.INVENTORY_LOCATION_ID
AND B.ORGANIZATION_ID = ACC.ORGANIZATION_ID
AND ACC.RESOURCE_ID = ASG_BASE.GET_RESOURCE_ID