VIEW: APPS.AST_CUST_SITE_USES_V

Source

View Text - Preformatted

SELECT ROWID , SITE_USE_ID , CUST_ACCT_SITE_ID , BILL_TO_SITE_USE_ID , CONTACT_ID , PAYMENT_TERM_ID , SITE_USE_CODE , PRIMARY_FLAG , STATUS , LOCATION , ORIG_SYSTEM_REFERENCE , SIC_CODE , GSA_INDICATOR , SHIP_PARTIAL , SHIP_VIA , FOB_POINT , ORDER_TYPE_ID , PRICE_LIST_ID , FREIGHT_TERM , WAREHOUSE_ID , TERRITORY_ID , TAX_REFERENCE , SORT_PRIORITY , TAX_CODE , LAST_UPDATE_DATE , LAST_UPDATED_BY , CREATION_DATE , CREATED_BY , LAST_UPDATE_LOGIN , REQUEST_ID , PROGRAM_APPLICATION_ID , PROGRAM_ID , PROGRAM_UPDATE_DATE , ATTRIBUTE_CATEGORY , ATTRIBUTE1 , ATTRIBUTE2 , ATTRIBUTE3 , ATTRIBUTE4 , ATTRIBUTE5 , ATTRIBUTE6 , ATTRIBUTE7 , ATTRIBUTE8 , ATTRIBUTE9 , ATTRIBUTE10 , 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 , ORG_ID , TAX_HEADER_LEVEL_FLAG , TAX_ROUNDING_RULE , PRIMARY_SALESREP_ID , FINCHRG_RECEIVABLES_TRX_ID , DATES_NEGATIVE_TOLERANCE , DATES_POSITIVE_TOLERANCE , DATE_TYPE_PREFERENCE , OVER_SHIPMENT_TOLERANCE , UNDER_SHIPMENT_TOLERANCE , ITEM_CROSS_REF_PREF , OVER_RETURN_TOLERANCE , UNDER_RETURN_TOLERANCE , SHIP_SETS_INCLUDE_LINES_FLAG , ARRIVALSETS_INCLUDE_LINES_FLAG , SCHED_DATE_PUSH_FLAG , INVOICE_QUANTITY_RULE , PRICING_EVENT , GL_ID_REC , GL_ID_REV , GL_ID_TAX , GL_ID_FREIGHT , GL_ID_CLEARING , GL_ID_UNBILLED , GL_ID_UNEARNED , GL_ID_UNPAID_REC , GL_ID_REMITTANCE , GL_ID_FACTOR FROM HZ_CUST_SITE_USES_ALL WHERE NVL(ORG_ID,NVL(TO_NUMBER(DECODE(SUBSTRB (USERENV('CLIENT_INFO'),1,1),' ',NULL,SUBSTRB(USERENV('CLIENT_INFO'),1,10))), -99)) = NVL(TO_NUMBER(DECODE(SUBSTRB(USERENV('CLIENT_INFO'),1,1),' ',NULL,SUBSTRB (USERENV('CLIENT_INFO'),1,10))),-99)

View Text - HTML Formatted

SELECT ROWID
, SITE_USE_ID
, CUST_ACCT_SITE_ID
, BILL_TO_SITE_USE_ID
, CONTACT_ID
, PAYMENT_TERM_ID
, SITE_USE_CODE
, PRIMARY_FLAG
, STATUS
, LOCATION
, ORIG_SYSTEM_REFERENCE
, SIC_CODE
, GSA_INDICATOR
, SHIP_PARTIAL
, SHIP_VIA
, FOB_POINT
, ORDER_TYPE_ID
, PRICE_LIST_ID
, FREIGHT_TERM
, WAREHOUSE_ID
, TERRITORY_ID
, TAX_REFERENCE
, SORT_PRIORITY
, TAX_CODE
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_LOGIN
, REQUEST_ID
, PROGRAM_APPLICATION_ID
, PROGRAM_ID
, PROGRAM_UPDATE_DATE
, ATTRIBUTE_CATEGORY
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, 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
, ORG_ID
, TAX_HEADER_LEVEL_FLAG
, TAX_ROUNDING_RULE
, PRIMARY_SALESREP_ID
, FINCHRG_RECEIVABLES_TRX_ID
, DATES_NEGATIVE_TOLERANCE
, DATES_POSITIVE_TOLERANCE
, DATE_TYPE_PREFERENCE
, OVER_SHIPMENT_TOLERANCE
, UNDER_SHIPMENT_TOLERANCE
, ITEM_CROSS_REF_PREF
, OVER_RETURN_TOLERANCE
, UNDER_RETURN_TOLERANCE
, SHIP_SETS_INCLUDE_LINES_FLAG
, ARRIVALSETS_INCLUDE_LINES_FLAG
, SCHED_DATE_PUSH_FLAG
, INVOICE_QUANTITY_RULE
, PRICING_EVENT
, GL_ID_REC
, GL_ID_REV
, GL_ID_TAX
, GL_ID_FREIGHT
, GL_ID_CLEARING
, GL_ID_UNBILLED
, GL_ID_UNEARNED
, GL_ID_UNPAID_REC
, GL_ID_REMITTANCE
, GL_ID_FACTOR
FROM HZ_CUST_SITE_USES_ALL
WHERE NVL(ORG_ID
, NVL(TO_NUMBER(DECODE(SUBSTRB (USERENV('CLIENT_INFO')
, 1
, 1)
, ' '
, NULL
, SUBSTRB(USERENV('CLIENT_INFO')
, 1
, 10)))
, -99)) = NVL(TO_NUMBER(DECODE(SUBSTRB(USERENV('CLIENT_INFO')
, 1
, 1)
, ' '
, NULL
, SUBSTRB (USERENV('CLIENT_INFO')
, 1
, 10)))
, -99)