FND Design Data [Home] [Help]

View: OPM_SITE_USES_ALL

Product: GMF - Process Manufacturing Financials
Description: OPM site uses view
Implementation/DBA Data: ViewAPPS.OPM_SITE_USES_ALL
View Text

SELECT NULL SITE_USE_ID
, NULL LAST_UPDATE_DATE
, NULL LAST_UPDATED_BY
, NULL CREATION_DATE
, NULL CREATED_BY
, NULL SITE_USE_CODE
, NULL ADDRESS_ID
, NULL PRIMARY_FLAG
, NULL STATUS
, NULL LOCATION
, NULL LAST_UPDATE_LOGIN
, NULL CONTACT_ID
, NULL BILL_TO_SITE_USE_ID
, NULL ORIG_SYSTEM_REFERENCE
, NULL SIC_CODE
, NULL PAYMENT_TERM_ID
, NULL GSA_INDICATOR
, NULL SHIP_PARTIAL
, NULL SHIP_VIA
, NULL FOB_POINT
, NULL ORDER_TYPE_ID
, NULL PRICE_LIST_ID
, NULL FREIGHT_TERM
, NULL WAREHOUSE_ID
, NULL TERRITORY_ID
, NULL ATTRIBUTE_CATEGORY
, NULL ATTRIBUTE1
, NULL ATTRIBUTE2
, NULL ATTRIBUTE3
, NULL ATTRIBUTE4
, NULL ATTRIBUTE5
, NULL ATTRIBUTE6
, NULL ATTRIBUTE7
, NULL ATTRIBUTE8
, NULL ATTRIBUTE9
, NULL ATTRIBUTE10
, NULL REQUEST_ID
, NULL PROGRAM_APPLICATION_ID
, NULL PROGRAM_ID
, NULL PROGRAM_UPDATE_DATE
, NULL TAX_REFERENCE
, NULL SORT_PRIORITY
, NULL TAX_CODE
, NULL ATTRIBUTE11
, NULL ATTRIBUTE12
, NULL ATTRIBUTE13
, NULL ATTRIBUTE14
, NULL ATTRIBUTE15
, NULL ATTRIBUTE16
, NULL ATTRIBUTE17
, NULL ATTRIBUTE18
, NULL ATTRIBUTE19
, NULL ATTRIBUTE20
, NULL ATTRIBUTE21
, NULL ATTRIBUTE22
, NULL ATTRIBUTE23
, NULL ATTRIBUTE24
, NULL ATTRIBUTE25
, NULL LAST_ACCRUE_CHARGE_DATE
, NULL SECOND_LAST_ACCRUE_CHARGE_DATE
, NULL LAST_UNACCRUE_CHARGE_DATE
, NULL SECOND_LAST_UNACCRUE_CHRG_DATE
, NULL DEMAND_CLASS_CODE
, NULL TAX_EXEMPT
, NULL TAX_EXEMPT_NUM
, NULL TAX_EXEMPT_REASON_CODE
, NULL ORG_ID
, NULL TAX_CLASSIFICATION
, NULL TAX_HEADER_LEVEL_FLAG
, NULL TAX_ROUNDING_RULE
, NULL WH_UPDATE_DATE
, NULL GLOBAL_ATTRIBUTE1
, NULL GLOBAL_ATTRIBUTE2
, NULL GLOBAL_ATTRIBUTE3
, NULL GLOBAL_ATTRIBUTE4
, NULL GLOBAL_ATTRIBUTE5
, NULL GLOBAL_ATTRIBUTE6
, NULL GLOBAL_ATTRIBUTE7
, NULL GLOBAL_ATTRIBUTE8
, NULL GLOBAL_ATTRIBUTE9
, NULL GLOBAL_ATTRIBUTE10
, NULL GLOBAL_ATTRIBUTE11
, NULL GLOBAL_ATTRIBUTE12
, NULL GLOBAL_ATTRIBUTE13
, NULL GLOBAL_ATTRIBUTE14
, NULL GLOBAL_ATTRIBUTE15
, NULL GLOBAL_ATTRIBUTE16
, NULL GLOBAL_ATTRIBUTE17
, NULL GLOBAL_ATTRIBUTE18
, NULL GLOBAL_ATTRIBUTE19
, NULL GLOBAL_ATTRIBUTE20
, NULL GLOBAL_ATTRIBUTE_CATEGORY
, NULL PRIMARY_SALESREP_ID
, NULL CUSTOMER_ID
FROM DUAL

Columns

Name
SITE_USE_ID
LAST_UPDATE_DATE
LAST_UPDATED_BY
CREATION_DATE
CREATED_BY
SITE_USE_CODE
ADDRESS_ID
PRIMARY_FLAG
STATUS
LOCATION
LAST_UPDATE_LOGIN
CONTACT_ID
BILL_TO_SITE_USE_ID
ORIG_SYSTEM_REFERENCE
SIC_CODE
PAYMENT_TERM_ID
GSA_INDICATOR
SHIP_PARTIAL
SHIP_VIA
FOB_POINT
ORDER_TYPE_ID
PRICE_LIST_ID
FREIGHT_TERM
WAREHOUSE_ID
TERRITORY_ID
ATTRIBUTE_CATEGORY
ATTRIBUTE1
ATTRIBUTE2
ATTRIBUTE3
ATTRIBUTE4
ATTRIBUTE5
ATTRIBUTE6
ATTRIBUTE7
ATTRIBUTE8
ATTRIBUTE9
ATTRIBUTE10
REQUEST_ID
PROGRAM_APPLICATION_ID
PROGRAM_ID
PROGRAM_UPDATE_DATE
TAX_REFERENCE
SORT_PRIORITY
TAX_CODE
ATTRIBUTE11
ATTRIBUTE12
ATTRIBUTE13
ATTRIBUTE14
ATTRIBUTE15
ATTRIBUTE16
ATTRIBUTE17
ATTRIBUTE18
ATTRIBUTE19
ATTRIBUTE20
ATTRIBUTE21
ATTRIBUTE22
ATTRIBUTE23
ATTRIBUTE24
ATTRIBUTE25
LAST_ACCRUE_CHARGE_DATE
SECOND_LAST_ACCRUE_CHARGE_DATE
LAST_UNACCRUE_CHARGE_DATE
SECOND_LAST_UNACCRUE_CHRG_DATE
DEMAND_CLASS_CODE
TAX_EXEMPT
TAX_EXEMPT_NUM
TAX_EXEMPT_REASON_CODE
ORG_ID
TAX_CLASSIFICATION
TAX_HEADER_LEVEL_FLAG
TAX_ROUNDING_RULE
WH_UPDATE_DATE
GLOBAL_ATTRIBUTE1
GLOBAL_ATTRIBUTE2
GLOBAL_ATTRIBUTE3
GLOBAL_ATTRIBUTE4
GLOBAL_ATTRIBUTE5
GLOBAL_ATTRIBUTE6
GLOBAL_ATTRIBUTE7
GLOBAL_ATTRIBUTE8
GLOBAL_ATTRIBUTE9
GLOBAL_ATTRIBUTE10
GLOBAL_ATTRIBUTE11
GLOBAL_ATTRIBUTE12
GLOBAL_ATTRIBUTE13
GLOBAL_ATTRIBUTE14
GLOBAL_ATTRIBUTE15
GLOBAL_ATTRIBUTE16
GLOBAL_ATTRIBUTE17
GLOBAL_ATTRIBUTE18
GLOBAL_ATTRIBUTE19
GLOBAL_ATTRIBUTE20
GLOBAL_ATTRIBUTE_CATEGORY
PRIMARY_SALESREP_ID
CUSTOMER_ID