SELECT ROWID, AUTO_LOT_ALPHA_PREFIX, ITEM_TYPE, BOM_ITEM_TYPE, REPLENISH_TO_ORDER_FLAG, PICK_COMPONENTS_FLAG, ATP_FLAG, ATP_COMPONENTS_FLAG, MRP_PLANNING_CODE, CUSTOMER_ORDER_ENABLED_FLAG,
ITEM_TYPE || '.' || BOM_ITEM_TYPE || '.' || REPLENISH_TO_ORDER_FLAG || '.' || PICK_COMPONENTS_FLAG || '.' || ATP_FLAG || '.' || ATP_COMPONENTS_FLAG || '.' || MRP_PLANNING_CODE || '.' || CUSTOMER_ORDER_ENABLED_FLAG
FROM MTL_SYSTEM_ITEMS_B
SELECT ROWID
, AUTO_LOT_ALPHA_PREFIX
, ITEM_TYPE
, BOM_ITEM_TYPE
, REPLENISH_TO_ORDER_FLAG
, PICK_COMPONENTS_FLAG
, ATP_FLAG
, ATP_COMPONENTS_FLAG
, MRP_PLANNING_CODE
, CUSTOMER_ORDER_ENABLED_FLAG
,
ITEM_TYPE || '.' || BOM_ITEM_TYPE || '.' || REPLENISH_TO_ORDER_FLAG || '.' || PICK_COMPONENTS_FLAG || '.' || ATP_FLAG || '.' || ATP_COMPONENTS_FLAG || '.' || MRP_PLANNING_CODE || '.' || CUSTOMER_ORDER_ENABLED_FLAG
FROM MTL_SYSTEM_ITEMS_B
|
|
|