CST_GROSS_MARGIN_DETAILS_V

Details

• Schema: FUSION

• Object owner: CST

• Object type: VIEW

Columns

Name

DOC_LINE_ID GL_DATE PROFIT_CENTER_BU_ID BU_NAME COST_ORG_ID COST_ORG_NAME COST_BOOK_ID COST_BOOK_CODE CURRENCY_CODE EXTENDED_PRECISION PRECISION CURRENCY_NAME INVENTORY_ORG_ID INV_ORG_NAME ITEM_ORGANIZATION_ID INVENTORY_ITEM_ID ITEM_NUMBER CONFIG_INVENTORY_ITEM_ID CONFIG_ITEM_NUMBER ROOT_INVENTORY_ITEM_ID ROOT_ITEM_NUMBER CATEGORY_ID CATEGORY_NAME SHIPMENT_NUMBER SHIPMENT_TYPE DOO_ORDER_NUMBER DOO_ORDER_TYPE ORDER_TYPE_CODE INVOICE_SOURCE INVOICE_NUMBER INVOICE_ID INVOICE_LINE_ID REVENUE_RECOGNITION_SRC CUSTOMER_ID CUSTOMER_NAME CUSTOMER_TYPE SHIP_TO_CUSTOMER_ID SUCCESSOR_BU_NAME SUCCESSOR_BU_ID RECOGNIZED_REV RECOGNIZED_COGS_AMOUNT RECOGNIZED_GROSS_MARGIN RECOGNIZED_COGS_PROFIT_AMT RECOGNIZED_COGS_OVERHEAD_AMT RECOGNIZED_COGS_RESOURCE_AMT UNRECOGNIZED_REV UNRECOGNIZED_COGS_AMOUNT UNRECOGNIZED_GROSS_MARGIN UNRECOGNIZED_COGS_PROFIT_AMT UNRECOGNIZED_COGS_OVERHEAD_AMT UNRECOGNIZED_COGS_RESOURCE_AMT COGS_ACCOUNT_ID

Query

SQL_Statement

SELECT cast(NULL as NUMBER) doc_line_id, cast(NULL as DATE) gl_date, cast(NULL as NUMBER) profit_center_bu_id, cast(NULL as VARCHAR2(240)) bu_name, cast(NULL as NUMBER) cost_org_id, cast(NULL as VARCHAR2(240)) cost_org_name, cast(NULL as NUMBER) cost_book_id, cast(NULL as VARCHAR2(30)) cost_book_code, cast(NULL as VARCHAR2(30))currency_code, cast(NULL as NUMBER(2)) extended_precision, cast(NULL as NUMBER(1)) precision, cast(NULL as VARCHAR2(80)) currency_name, cast(NULL as NUMBER) inventory_org_id, cast(NULL as VARCHAR2(240))inv_org_name, cast(NULL as NUMBER) item_organization_id, cast(NULL as NUMBER) inventory_item_id, cast(NULL as VARCHAR2(300)) item_number, cast(NULL as NUMBER) config_inventory_item_id, cast(NULL as VARCHAR2(300)) config_item_number, cast(NULL as NUMBER) root_inventory_item_id, cast(NULL as VARCHAR2(300)) root_item_number, cast(NULL as NUMBER) category_id, cast(NULL as VARCHAR2(250)) category_name, cast(NULL as VARCHAR2(240)) shipment_number, cast(NULL as VARCHAR2(50)) shipment_type, cast(NULL as VARCHAR2(240)) doo_order_number, cast(NULL as VARCHAR2(50)) doo_order_type, cast(NULL as VARCHAR2(30)) order_type_code, cast(NULL as VARCHAR2(30)) invoice_source, cast(NULL as VARCHAR2(20)) invoice_number, cast(NULL as NUMBER) invoice_id, cast(NULL as NUMBER) invoice_line_id, cast(NULL as VARCHAR2(60)) revenue_recognition_src, cast(NULL as NUMBER) customer_id, cast(NULL as VARCHAR2(360)) customer_name, cast(NULL as CHAR(1)) customer_type, cast(NULL as NUMBER) ship_to_customer_id, cast(NULL as VARCHAR2(240)) successor_bu_name, cast(NULL as NUMBER) successor_bu_id, cast(NULL as NUMBER) recognized_rev, cast(NULL as NUMBER) recognized_cogs_amount, cast(NULL as NUMBER) recognized_gross_margin, cast(NULL as NUMBER) recognized_cogs_profit_amt, cast(NULL as NUMBER) recognized_cogs_overhead_amt, cast(NULL as NUMBER) recognized_cogs_resource_amt, cast(NULL as NUMBER) unrecognized_rev, cast(NULL as NUMBER) unrecognized_cogs_amount, cast(NULL as NUMBER) unrecognized_gross_margin, cast(NULL as NUMBER) unrecognized_cogs_profit_amt, cast(NULL as NUMBER) unrecognized_cogs_overhead_amt, cast(NULL as NUMBER) unrecognized_cogs_resource_amt, cast(NULL as NUMBER) cogs_account_id FROM CST_B_GROSS_MARGIN_DETAILS_V WHERE 1=2