CST_XLA_LOCATORS_V

Details

• Schema: FUSION

• Object owner: CST

• Object type: VIEW

Columns

Name

LOCATOR_ID INV_ORG_ID SUBINVENTORY_ID SUBINVENTORY_CODE STRUCTURE_INSTANCE_NUMBER LOCATOR_DESC LOCATOR_TYPE LOCATOR_DEPRECIABLE_FLAG LOCATOR_SEGMENT1 LOCATOR_SEGMENT2 LOCATOR_SEGMENT3 LOCATOR_SEGMENT4 LOCATOR_SEGMENT5 LOCATOR_SEGMENT6 LOCATOR_SEGMENT7 LOCATOR_SEGMENT8 LOCATOR_SEGMENT9 LOCATOR_SEGMENT10 LOCATOR_SEGMENT11 LOCATOR_SEGMENT12 LOCATOR_SEGMENT13 LOCATOR_SEGMENT14 LOCATOR_SEGMENT15 LOCATOR_SEGMENT16 LOCATOR_SEGMENT17 LOCATOR_SEGMENT18 LOCATOR_SEGMENT19 LOCATOR_SEGMENT20

Query

SQL_Statement

SELECT inventory_location_id locator_id , organization_id inv_org_id , subinventory_id subinventory_id , subinventory_code subinventory_code , structure_instance_number structure_instance_number , description locator_desc , inventory_location_type locator_type , depreciable_flag locator_depreciable_flag , segment1 locator_segment1 , segment2 locator_segment2 , segment3 locator_segment3 , segment4 locator_segment4 , segment5 locator_segment5 , segment6 locator_segment6 , segment7 locator_segment7 , segment8 locator_segment8 , segment9 locator_segment9 , segment10 locator_segment10 , segment11 locator_segment11 , segment12 locator_segment12 , segment13 locator_segment13 , segment14 locator_segment14 , segment15 locator_segment15 , segment16 locator_segment16 , segment17 locator_segment17 , segment18 locator_segment18 , segment19 locator_segment19 , segment20 locator_segment20 FROM inv_item_locations