VIEW: APPS.OE_LINE_SAL_CRDT_HIST_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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