View: IBE_OE_ORDER_SUMMARY_V

View Text

SELECT /*+ INDEX (OH OE_ORDER_HEADERS_N2) */ OH.HEADER_ID
, OH.CREATED_BY
, OH.SOURCE_DOCUMENT_ID
, OH.ORDER_NUMBER
, OH.ORDERED_DATE
, OH.SOLD_TO_ORG_ID CUST_ACCOUNT_ID
, CUST.PARTY_NAME
, OH.CUST_PO_NUMBER
, OH.ORDER_CATEGORY_CODE
FROM ASO_I_OE_ORDER_HEADERS_V OH
, HZ_CUST_ACCOUNTS ACCT
, HZ_PARTIES CUST
WHERE OH.SOLD_TO_ORG_ID = ACCT.CUST_ACCOUNT_ID
AND ACCT.PARTY_ID = CUST.PARTY_ID
AND NVL(OH.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)

Columns