VIEW: APPS.EDW_ITEM_ITEMORGPF_LCV

Source

View Text - Preformatted

SELECT item_org_pk, 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), substrb(description,1,240) , inventory_item_id , organization_id , make_or_buy_flag, unit_list_price , market_price , taxable_flag , stockable_flag , internal_ord_flag , inv_planning_code , 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 from edwbv_item_itemorgpf_lcv

View Text - HTML Formatted

SELECT ITEM_ORG_PK
, 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)
, SUBSTRB(DESCRIPTION
, 1
, 240)
, INVENTORY_ITEM_ID
, ORGANIZATION_ID
, MAKE_OR_BUY_FLAG
, UNIT_LIST_PRICE
, MARKET_PRICE
, TAXABLE_FLAG
, STOCKABLE_FLAG
, INTERNAL_ORD_FLAG
, INV_PLANNING_CODE
, 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
FROM EDWBV_ITEM_ITEMORGPF_LCV