Product: | ONT - Order Management |
---|---|
Description: | |
Implementation/DBA Data: |
![]() |
SELECT OSCH.HIST_CREATED_BY
, OSCH.RESPONSIBILITY_ID
, OSCH.HIST_CREATION_DATE
, OSCH.HEADER_ID
, OSCH.SALES_CREDIT_ID
, OH.SOLD_TO_ORG_ID
, OH.ORDER_TYPE_ID
, OH.ORDER_NUMBER
, OSCH.REASON_CODE
, OSCH.HIST_COMMENTS
, OSCH.HIST_TYPE_CODE
, OSCH.SALESREP_ID
, OSCH.PERCENT
, OSCH.SALES_CREDIT_TYPE_ID
, OSCH.CREATED_BY
, OSCH.CREATION_DATE
, OSCH.LAST_UPDATE_DATE
, OSCH.LAST_UPDATED_BY
, OSCH.LAST_UPDATE_LOGIN
, OSCH.REASON_ID
, OSCH.AUDIT_FLAG
, OSCH.VERSION_FLAG
, OSCH.PHASE_CHANGE_FLAG
, OSCH.VERSION_NUMBER
FROM OE_SALES_CREDIT_HISTORY OSCH
, OE_ORDER_HEADERS_ALL OH
WHERE OH.HEADER_ID = OSCH.HEADER_ID
AND OSCH.LINE_ID IS NULL