CST_XLA_COST_ORG_BOOKS_V

Details

• Schema: FUSION

• Object owner: CST

• Object type: VIEW

Columns

Name

COST_ORG_ID COST_BOOK_ID COST_ORG_BOOK_ATTR_CATEGORY COST_ORG_BOOK_ATTRIBUTE_C1 COST_ORG_BOOK_ATTRIBUTE_C2 COST_ORG_BOOK_ATTRIBUTE_C3 COST_ORG_BOOK_ATTRIBUTE_C4 COST_ORG_BOOK_ATTRIBUTE_C5 COST_ORG_BOOK_ATTRIBUTE_C6 COST_ORG_BOOK_ATTRIBUTE_C7 COST_ORG_BOOK_ATTRIBUTE_C8 COST_ORG_BOOK_ATTRIBUTE_C9 COST_ORG_BOOK_ATTRIBUTE_C10 COST_ORG_BOOK_ATTRIBUTE_C11 COST_ORG_BOOK_ATTRIBUTE_C12 COST_ORG_BOOK_ATTRIBUTE_C13 COST_ORG_BOOK_ATTRIBUTE_C14 COST_ORG_BOOK_ATTRIBUTE_C15 COST_ORG_BOOK_ATTRIBUTE_C16 COST_ORG_BOOK_ATTRIBUTE_C17 COST_ORG_BOOK_ATTRIBUTE_C18 COST_ORG_BOOK_ATTRIBUTE_C19 COST_ORG_BOOK_ATTRIBUTE_C20 COST_ORG_BOOK_ATTRIBUTE_N1 COST_ORG_BOOK_ATTRIBUTE_N2 COST_ORG_BOOK_ATTRIBUTE_N3 COST_ORG_BOOK_ATTRIBUTE_N4 COST_ORG_BOOK_ATTRIBUTE_N5 COST_ORG_BOOK_ATTRIBUTE_N6 COST_ORG_BOOK_ATTRIBUTE_N7 COST_ORG_BOOK_ATTRIBUTE_N8 COST_ORG_BOOK_ATTRIBUTE_N9 COST_ORG_BOOK_ATTRIBUTE_N10 COST_ORG_BOOK_ATTRIBUTE_D1 COST_ORG_BOOK_ATTRIBUTE_D2 COST_ORG_BOOK_ATTRIBUTE_D3 COST_ORG_BOOK_ATTRIBUTE_D4 COST_ORG_BOOK_ATTRIBUTE_D5 COST_ORG_BOOK_ATTRIBUTE_TS1 COST_ORG_BOOK_ATTRIBUTE_TS2 COST_ORG_BOOK_ATTRIBUTE_TS3 COST_ORG_BOOK_ATTRIBUTE_TS4 COST_ORG_BOOK_ATTRIBUTE_TS5

Query

SQL_Statement

SELECT cost_org_id cost_org_id , cost_book_id cost_book_id , attribute_category cost_org_book_attr_category , attribute_char1 cost_org_book_attribute_c1 , attribute_char2 cost_org_book_attribute_c2 , attribute_char3 cost_org_book_attribute_c3 , attribute_char4 cost_org_book_attribute_c4 , attribute_char5 cost_org_book_attribute_c5 , attribute_char6 cost_org_book_attribute_c6 , attribute_char7 cost_org_book_attribute_c7 , attribute_char8 cost_org_book_attribute_c8 , attribute_char9 cost_org_book_attribute_c9 , attribute_char10 cost_org_book_attribute_c10 , attribute_char11 cost_org_book_attribute_c11 , attribute_char12 cost_org_book_attribute_c12 , attribute_char13 cost_org_book_attribute_c13 , attribute_char14 cost_org_book_attribute_c14 , attribute_char15 cost_org_book_attribute_c15 , attribute_char16 cost_org_book_attribute_c16 , attribute_char17 cost_org_book_attribute_c17 , attribute_char18 cost_org_book_attribute_c18 , attribute_char19 cost_org_book_attribute_c19 , attribute_char20 cost_org_book_attribute_c20 , attribute_number1 cost_org_book_attribute_n1 , attribute_number2 cost_org_book_attribute_n2 , attribute_number3 cost_org_book_attribute_n3 , attribute_number4 cost_org_book_attribute_n4 , attribute_number5 cost_org_book_attribute_n5 , attribute_number6 cost_org_book_attribute_n6 , attribute_number7 cost_org_book_attribute_n7 , attribute_number8 cost_org_book_attribute_n8 , attribute_number9 cost_org_book_attribute_n9 , attribute_number10 cost_org_book_attribute_n10 , attribute_date1 cost_org_book_attribute_d1 , attribute_date2 cost_org_book_attribute_d2 , attribute_date3 cost_org_book_attribute_d3 , attribute_date4 cost_org_book_attribute_d4 , attribute_date5 cost_org_book_attribute_d5 , attribute_timestamp1 cost_org_book_attribute_ts1 , attribute_timestamp2 cost_org_book_attribute_ts2 , attribute_timestamp3 cost_org_book_attribute_ts3 , attribute_timestamp4 cost_org_book_attribute_ts4 , attribute_timestamp5 cost_org_book_attribute_ts5 FROM cst_cost_org_books