VIEW: APPS.CS_ORDERS_INTERFACE

Source

View Text - Preformatted

SELECT ORDER_INTERFACE_ID , CREATED_BY , CREATION_DATE , TRANSACTION_CODE , LINE_ID , HEADER_ID , CONCURRENT_PROCESS_ID , RETURN_CP_ID , RETURN_QUANTITY , CANCEL_CP_ID , CANCEL_QUANTITY , SERVICE_ITEM_FLAG , CP_SERVICE_ID , CUSTOMER_PRODUCT_ID , SHIPPED_QUANTITY , SHIPPED_DATE , SHIP_TO_SITE_USE_ID , PICKING_HEADER_ID , DELIVERED_FLAG , MASS_RENEW_TXN_TEMP_ID , ORG_ID , SERIAL_NUMBER , LOT_NUMBER , REVISION , LINE_DETAIL_ID , INCLUDED_ITEM_FLAG , ERROR_FLAG , SKIP_FLAG , ERROR_SKIP_REASON FROM CS_ORDERS_INTERFACE_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 ORDER_INTERFACE_ID
, CREATED_BY
, CREATION_DATE
, TRANSACTION_CODE
, LINE_ID
, HEADER_ID
, CONCURRENT_PROCESS_ID
, RETURN_CP_ID
, RETURN_QUANTITY
, CANCEL_CP_ID
, CANCEL_QUANTITY
, SERVICE_ITEM_FLAG
, CP_SERVICE_ID
, CUSTOMER_PRODUCT_ID
, SHIPPED_QUANTITY
, SHIPPED_DATE
, SHIP_TO_SITE_USE_ID
, PICKING_HEADER_ID
, DELIVERED_FLAG
, MASS_RENEW_TXN_TEMP_ID
, ORG_ID
, SERIAL_NUMBER
, LOT_NUMBER
, REVISION
, LINE_DETAIL_ID
, INCLUDED_ITEM_FLAG
, ERROR_FLAG
, SKIP_FLAG
, ERROR_SKIP_REASON
FROM CS_ORDERS_INTERFACE_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)