VIEW: APPS.EDW_ITEM_ITEMORG_LCV

Source

View Text - Preformatted

SELECT substrb(item_org_pk,1,320), instance, item_number_fk, prod_family_fk, catset_category_fk, substrb(item_org_dp,1,240), substrb(name,1,320), buyer_fk, planner_fk, substrb(item_number,1,240), description , inventory_item_id , organization_id , substrb(make_or_buy_flag,1,40), unit_list_price , market_price , taxable_flag , stockable_flag , internal_ord_flag , substrb(inv_planning_code,1,40) , lot_control , outside_op_flag , price_tol_percent , purchasable_flag , shelf_life_code , shelf_life_days , tax_code , revision_control , insp_required , receipt_required, locator_control , effectivity_control , serial_control , mrp_pln_method , approved_supplier , substitute_rcpt , unordered_rcpt , exprs_delivery , hazard_class_id , un_number_id , rfq_required_flag , segment1, creation_date , last_update_date , operation_code, NULL , NULL , NULL , NULL , NULL , item_type from edwbv_item_itemorg_lcv

View Text - HTML Formatted

SELECT SUBSTRB(ITEM_ORG_PK
, 1
, 320)
, INSTANCE
, ITEM_NUMBER_FK
, PROD_FAMILY_FK
, CATSET_CATEGORY_FK
, SUBSTRB(ITEM_ORG_DP
, 1
, 240)
, SUBSTRB(NAME
, 1
, 320)
, BUYER_FK
, PLANNER_FK
, SUBSTRB(ITEM_NUMBER
, 1
, 240)
, DESCRIPTION
, INVENTORY_ITEM_ID
, ORGANIZATION_ID
, SUBSTRB(MAKE_OR_BUY_FLAG
, 1
, 40)
, UNIT_LIST_PRICE
, MARKET_PRICE
, TAXABLE_FLAG
, STOCKABLE_FLAG
, INTERNAL_ORD_FLAG
, SUBSTRB(INV_PLANNING_CODE
, 1
, 40)
, LOT_CONTROL
, OUTSIDE_OP_FLAG
, PRICE_TOL_PERCENT
, PURCHASABLE_FLAG
, SHELF_LIFE_CODE
, SHELF_LIFE_DAYS
, TAX_CODE
, REVISION_CONTROL
, INSP_REQUIRED
, RECEIPT_REQUIRED
, LOCATOR_CONTROL
, EFFECTIVITY_CONTROL
, SERIAL_CONTROL
, MRP_PLN_METHOD
, APPROVED_SUPPLIER
, SUBSTITUTE_RCPT
, UNORDERED_RCPT
, EXPRS_DELIVERY
, HAZARD_CLASS_ID
, UN_NUMBER_ID
, RFQ_REQUIRED_FLAG
, SEGMENT1
, CREATION_DATE
, LAST_UPDATE_DATE
, OPERATION_CODE
, NULL
, NULL
, NULL
, NULL
, NULL
, ITEM_TYPE
FROM EDWBV_ITEM_ITEMORG_LCV