PO_LOCATIONS_VAL_V

Details

• Schema: FUSION

• Object owner: PO

• Object type: VIEW

Columns

Name
LOCATION_CODE LOCATION_ID DESCRIPTION IN_ORGANIZATION_FLAG SHIP_TO_SITE_FLAG BILL_TO_SITE_FLAG RECEIVING_SITE_FLAG OFFICE_SITE_FLAG SHIP_TO_LOCATION_ID INVENTORY_ORGANIZATION_ID TAX_NAME DESIGNATED_RECEIVER_ID ADDRESS_LINE_1 ADDRESS_LINE_2 ADDRESS_LINE_3 POSTAL_CODE REGION_1 REGION_2 REGION_3 TOWN_OR_CITY COUNTRY TELEPHONE_NUMBER_1 TELEPHONE_NUMBER_2 TELEPHONE_NUMBER_3

Query

SQL_Statement

SELECT to_char(null) LOCATION_CODE , to_number(null) LOCATION_ID , to_char(null) DESCRIPTION , to_char(null) IN_ORGANIZATION_FLAG , to_char(null) SHIP_TO_SITE_FLAG , to_char(null) BILL_TO_SITE_FLAG , to_char(null) RECEIVING_SITE_FLAG , to_char(null) OFFICE_SITE_FLAG , to_number(null) SHIP_TO_LOCATION_ID , to_number(null) INVENTORY_ORGANIZATION_ID , to_char(null) TAX_NAME , to_number(null) DESIGNATED_RECEIVER_ID , to_char(null) ADDRESS_LINE_1 , to_char(null) ADDRESS_LINE_2 , to_char(null) ADDRESS_LINE_3 , to_char(null) POSTAL_CODE , to_char(null) REGION_1 , to_char(null) REGION_2 , to_char(null) REGION_3 , to_char(null) TOWN_OR_CITY , to_char(null) COUNTRY , to_char(null) TELEPHONE_NUMBER_1 , to_char(null) TELEPHONE_NUMBER_2 , to_char(null) TELEPHONE_NUMBER_3 FROM PO_LOOKUP_CODES