1. Tables and Views for SCM
  2. RCL_ESTIMATE_HEADERS_VL

RCL_ESTIMATE_HEADERS_VL

Details

  • Schema: FUSION

  • Object owner: RCL

  • Object type: VIEW

Columns

Name

ESTIMATE_HEADER_ID

OBJECT_VERSION_NUMBER

ESTIMATE_NUMBER

ESTIMATE_VERSION_NUMBER

ESTIMATE_TITLE

ESTIMATE_STATUS_CODE

ESTIMATE_CREATOR

ESTIMATE_EXPIRATION_DATE

ESTIMATE_TYPE

REASON_CODE

DOCUMENT_TYPE

DOCUMENT_ID

DOCUMENT_NAME

BU_ORG_ID

PARTY_ID

CUST_ACCOUNT_ID

SHIP_TO_PARTY_SITE_ID

BILL_TO_PARTY_SITE_ID

PRODUCT_ITEM_ID

ASSET_ID

PURCHASE_ORDER

ATTRIBUTE_CATEGORY

ATTRIBUTE_CHAR1

ATTRIBUTE_CHAR2

ATTRIBUTE_CHAR3

ATTRIBUTE_CHAR4

ATTRIBUTE_CHAR5

ATTRIBUTE_CHAR6

ATTRIBUTE_CHAR7

ATTRIBUTE_CHAR8

ATTRIBUTE_CHAR9

ATTRIBUTE_CHAR10

ATTRIBUTE_CHAR11

ATTRIBUTE_CHAR12

ATTRIBUTE_CHAR13

ATTRIBUTE_CHAR14

ATTRIBUTE_CHAR15

ATTRIBUTE_CHAR16

ATTRIBUTE_CHAR17

ATTRIBUTE_CHAR18

ATTRIBUTE_CHAR19

ATTRIBUTE_CHAR20

ATTRIBUTE_NUMBER1

ATTRIBUTE_NUMBER2

ATTRIBUTE_NUMBER3

ATTRIBUTE_NUMBER4

ATTRIBUTE_NUMBER5

ATTRIBUTE_NUMBER6

ATTRIBUTE_NUMBER7

ATTRIBUTE_NUMBER8

ATTRIBUTE_NUMBER9

ATTRIBUTE_NUMBER10

ATTRIBUTE_DATE1

ATTRIBUTE_DATE2

ATTRIBUTE_DATE3

ATTRIBUTE_DATE4

ATTRIBUTE_DATE5

ATTRIBUTE_TIMESTAMP1

ATTRIBUTE_TIMESTAMP2

ATTRIBUTE_TIMESTAMP3

ATTRIBUTE_TIMESTAMP4

ATTRIBUTE_TIMESTAMP5

CREATED_BY

CREATION_DATE

LAST_UPDATED_BY

LAST_UPDATE_DATE

LAST_UPDATE_LOGIN

Query

SQL_Statement

SELECT

rehb.estimate_header_id,

rehb.object_version_number,

rehb.estimate_number,

rehb.estimate_version_number,

reht.estimate_title,

rehb.estimate_status_code,

rehb.estimate_creator,

rehb.estimate_expiration_date,

rehb.estimate_type,

rehb.reason_code,

rehb.document_type,

rehb.document_id,

rehb.document_name,

rehb.bu_org_id,

rehb.party_id,

rehb.cust_account_id,

rehb.ship_to_party_site_id,

rehb.bill_to_party_site_id,

rehb.product_item_id,

rehb.asset_id,

rehb.purchase_order,

rehb.attribute_category,

rehb.attribute_char1,

rehb.attribute_char2,

rehb.attribute_char3,

rehb.attribute_char4,

rehb.attribute_char5,

rehb.attribute_char6,

rehb.attribute_char7,

rehb.attribute_char8,

rehb.attribute_char9,

rehb.attribute_char10,

rehb.attribute_char11,

rehb.attribute_char12,

rehb.attribute_char13,

rehb.attribute_char14,

rehb.attribute_char15,

rehb.attribute_char16,

rehb.attribute_char17,

rehb.attribute_char18,

rehb.attribute_char19,

rehb.attribute_char20,

rehb.attribute_number1,

rehb.attribute_number2,

rehb.attribute_number3,

rehb.attribute_number4,

rehb.attribute_number5,

rehb.attribute_number6,

rehb.attribute_number7,

rehb.attribute_number8,

rehb.attribute_number9,

rehb.attribute_number10,

rehb.attribute_date1,

rehb.attribute_date2,

rehb.attribute_date3,

rehb.attribute_date4,

rehb.attribute_date5,

rehb.attribute_timestamp1,

rehb.attribute_timestamp2,

rehb.attribute_timestamp3,

rehb.attribute_timestamp4,

rehb.attribute_timestamp5,

rehb.created_by,

rehb.creation_date,

rehb.last_updated_by,

rehb.last_update_date,

rehb.last_update_login

FROM

rcl_estimate_headers_b rehb,

rcl_estimate_headers_tl reht

WHERE

rehb.estimate_header_id = reht.estimate_header_id

AND reht.language = userenv('LANG')