[Home] [Help]
View: OE_LINE_SAL_CRDT_HIST_V
View Text
SELECT OSCH.HIST_CREATED_BY
, OSCH.RESPONSIBILITY_ID
, OSCH.HIST_CREATION_DATE
, OSCH.HEADER_ID
, OSCH.LINE_ID
, OSCH.SALES_CREDIT_ID
, OH.SOLD_TO_ORG_ID
, OH.ORDER_TYPE_ID
, OH.ORDER_NUMBER
, OL.LINE_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_LINES_ALL OL
, OE_ORDER_HEADERS_ALL OH
WHERE OH.HEADER_ID = OSCH.HEADER_ID
AND OL.HEADER_ID = OSCH.HEADER_ID
AND OL.LINE_ID = OSCH.LINE_ID
Columns
| Name |
| USER_ID |
| RESPONSIBILITY_ID |
| HIST_CREATION_DATE |
| HEADER_ID |
| LINE_ID |
| SALES_CREDIT_ID |
| SOLD_TO_ORG_ID |
| ORDER_TYPE_ID |
| ORDER_NUMBER |
| LINE_NUMBER |
| REASON_CODE |
| HIST_COMMENTS |
| HIST_TYPE_CODE |
| SALESREP_ID |
| PERCENT |
| SALES_CREDIT_TYPE_ID |
| CREATED_BY |
| CREATION_DATE |
| LAST_UPDATE_DATE |
| LAST_UPDATED_BY |
| LAST_UPDATE_LOGIN |
| REASON_ID |
| AUDIT_FLAG |
| VERSION_FLAG |
| PHASE_CHANGE_FLAG |
| VERSION_NUMBER |
APPS.OE_LINE_SAL_CRDT_HIST_V