StockingLocations

Columns


Name	Type	Description
StockLocationId [KEY]	Long	Value that uniquely identifies the stocking location.
OrganizationId	Long	Value that uniquely identifies the inventory organization for which service logistics attributes are added or updated.
OrganizationCode	String	Abbreviation that identifies the inventory organization for which service logistics attributes are added or updated.
Subinventory	String	Name of the subinventory for which service logistics attributes are added or updated.
Condition	String	Condition of subinventory stocking locations. Valid values are Usable and Defective. A list of accepted values is defined in the lookup type ORA_RCL_STOCK_LOC_CONDITION.
LocationType	String	Type of location. Valid values are TECHNICIAN, UNMANNED, MANNED, and SITE_DEDICATED. A list of accepted values is defined in the lookup type ORA_RCL_STOCK_LOC_TYPE. You cannot add additional location types.
LocationTypeMeaning	String	Description of the location type. Valid values are Technician, Unmanned Warehouse, Manned Warehouse, and Site Dedicated Warehouse. A list of accepted values is defined in the lookup type ORA_RCL_STOCK_LOC_TYPE. You cannot add additional location types.
ConditionMeaning	String	Value that indicates the condition of subinventory stocking locations. Valid values are Usable and Defective. A list of accepted values is defined in the lookup type ORA_RCL_STOCK_LOC_CONDITION.

SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。