DBA Data[Home] [Help]

VIEW: APPS.BOM_INVENTORY_COMPS_INTER1_DFV

Source

View Text - Preformatted

SELECT ROWID, DDF_CONTEXT2, CHECK_ATP, INCLUDE_ON_SHIP_DOCS, SO_BASIS, MUTUALLY_EXCLUSIVE_OPTIONS, REQUIRED_TO_SHIP, REQUIRED_FOR_REVENUE, LOW_QUANTITY, HIGH_QUANTITY,  
 CHECK_ATP || '-' || INCLUDE_ON_SHIP_DOCS || '-' || SO_BASIS || '-' || MUTUALLY_EXCLUSIVE_OPTIONS || '-' || REQUIRED_TO_SHIP || '-' || REQUIRED_FOR_REVENUE || '-' || LOW_QUANTITY || '-' || HIGH_QUANTITY 
 FROM BOM_INVENTORY_COMPS_INTERFACE
View Text - HTML Formatted

SELECT ROWID
, DDF_CONTEXT2
, CHECK_ATP
, INCLUDE_ON_SHIP_DOCS
, SO_BASIS
, MUTUALLY_EXCLUSIVE_OPTIONS
, REQUIRED_TO_SHIP
, REQUIRED_FOR_REVENUE
, LOW_QUANTITY
, HIGH_QUANTITY
, CHECK_ATP || '-' || INCLUDE_ON_SHIP_DOCS || '-' || SO_BASIS || '-' || MUTUALLY_EXCLUSIVE_OPTIONS || '-' || REQUIRED_TO_SHIP || '-' || REQUIRED_FOR_REVENUE || '-' || LOW_QUANTITY || '-' || HIGH_QUANTITY
FROM BOM_INVENTORY_COMPS_INTERFACE