VIEW: APPS.OPM_SITE_USES_ALL

Source

View Text - Preformatted

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

View Text - HTML Formatted

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